Case Study: Coinhall achieves real-time blockchain analytics at 40x lower cost with ClickHouse

How Coinhall uses ClickHouse to power its blockchain data platform

Coinhall is an omnichain trading terminal that aggregates swap data from 23 blockchain networks to deliver real-time price charts and trading insights. As its data volumes grew, the company found its original stack too slow and expensive, with BigQuery queries averaging around two seconds and costs climbing as usage scaled.

Coinhall migrated to ClickHouse after evaluating several databases, choosing it for its performance and self-hosting cost efficiency. With ClickHouse, Coinhall achieved candlestick queries in 20 ms, latest-price queries in 8 ms, and ASOF JOIN queries in 50 ms, while cutting monthly database cost to about $50 versus up to $2,000 for managed alternatives—roughly 40x savings.

Coinhall

Aaron Choo

Co-Founder and CTO