Skip to content

Blog

replacing hdb clickhouse historical ticker data

Engineering

Replacing the HDB: ClickHouse for historical ticker data

A hands-on walkthrough of loading billions of Binance tick records into ClickHouse, showing how columnar storage and codecs compress trade and quote data 19x, and how standard SQL handles VWAP, OHLC candles, and as-of joins at millisecond granularity.

mark needham
Mark Needham
Jul 15, 2026 · 23 minutes read
Kaushik Iska · Jul 14, 2026
Karolina Ruiz Rogelj and Melvyn Peignon · Jul 10, 2026
Luke Gannon · Jul 10, 2026
David Wheeler and Philip Dubé · Jul 8, 2026
Auxten Wang and Nakul Mishra (AWS) · Jul 7, 2026
ClickHouse · Jul 3, 2026
Aaron Knudtson · Jul 2, 2026