# Replacing the HDB: ClickHouse for historical ticker data

DevFeed: [Replacing the HDB: ClickHouse for historical ticker data](<https://devfeed.tech/articles/replacing-the-hdb-clickhouse-for-historical-ticker-data-5274.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/historical-ticker-data>)

Author: Mark Needham

Published: 2026-07-15T18:08:16Z

Content type: tutorial

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [compression](<https://devfeed.tech/tags/compression.md>), [cost](<https://devfeed.tech/tags/cost.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [financial-services](<https://devfeed.tech/tags/financial-services.md>), [latency](<https://devfeed.tech/tags/latency.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [research](<https://devfeed.tech/tags/research.md>), [sql](<https://devfeed.tech/tags/sql.md>), [storage](<https://devfeed.tech/tags/storage.md>)

## AI overview

A hands-on article on using ClickHouse as a historical market-data database. It loads Binance tick data and explains columnar storage, compression, and SQL queries for trading-desk analysis.

## Source excerpt

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.