GoClickHouseApp

Table of Contents

• Scope
• Technology Stack
• Quick Start & Demo
• Full Development setup
• Screenshots
• Next Steps
• References

Scope

• Setup a Clickhouse repository. Populate NIFTY tickdata for a trading day.
• Develop backend Apis using GoLang & GoFiber
• Render NIFTY Tick Data as Candlesticks at 5min, 15min or 1 Hour interval fetching data from Clickhouse Datastore and massaging data in GoLang Api

Technology Stack

• Clickhouse as Repository
• Go with GoFiber as Api Stack
• Angular as UI framework and Apache ECharts as Charting Component

Quick Start & Demo

• Ensure you have Go Installed
• Goto the folder cmd and execute the command go run main.go
• Configure a Data Source of your choice at pkg/config/serverconfig.go
  • (Default) Mock Data from pkg/repository/mock/mockquery.go
  • Run a local docker image. Refer to Repository Setup
  • Point to existing Click house instance
• Access the application at http://localhost:3000

Full Development setup

• Refer to Development Setup

Screenshots

Note

The NIFTY tickdata data has been generated randomly. Dont be alarmed by the Volatality 😊

1 Min Timeframe

5 Min Timeframe

15 Min Timeframe

1 Hr Timeframe

Next Steps

• Deploy to AWS

References

• Using ClickHouse for financial market data - Christoph Wurm (ClickHouse)
• ClickHouse for Financial Analytics - Baudouin Giard (Bloomberg)
• Introduction to High-Velocity Analytics Using ClickHouse Arrays | ClickHouse Webinar | Altinity