Life & fun · alternatives · 2026
24 alternatives to Storing and Analyzing 160 billion Quotes in ClickHouse
Exploring efficient data storage and analysis for quant trading using ClickHouse. This article compares various storage solutions and demonstrates the impressive performance of ClickHouse for handling large-scale financial data.
Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Storing and Analyzing 160 billion Quotes in ClickHouse launched in 2024; newer entries below may have overtaken it.
- 1
Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: https://github.com/ClickHouse/ClickHouse/pull/150 Development continued in the past 6 years, and now clickhouse-local becomes a swiss-army knife for data processing. Say "ffmpeg" for datasets and more. It can resemble textql, octosql, dsq, duckdb, trdsql, q, datafusion-cli, spyql, but has better capabilities and performance. Here is a tutorial:…
2023 · clickhouse.com · its alternatives →
- 2
ClickHouse▲12ClickHouse is a free analytic DBMS for big data.
2016 · clickhouse.com · its alternatives →
- 3
QuestDB live demo. Query three large datasets and more than 2 billion rows in milliseconds with SQL
2020 · try.questdb.io · its alternatives →
- 4
Performance comparison of ClickHouse vs PostgreSQL using LLM-style query patterns on realistic aircraft tracking data - GitHub - 514-labs/LLM-query-test: Performance comparison of ClickHouse vs PostgreSQL using LLM-style query patterns on realistic aircraft tracking data
2025 · github.com · its alternatives →
- 5
Hello! For the past year I’ve been working on a fully-managed data warehouse built on Clickhouse. I built this because I was frustrated with how much work was required to run an OLAP database in prod: re-writing my app to do batch inserts, managing clusters and needing to look up special CREATE TABLE syntax every time I made a change. I found pricing for other warehouses confusing (what is a “credit” exactly?) and worried about getting capacity-planning wrong. I was previously building accounting software for firms with millions of transactions. I desperately needed to move from Postgres to…
2023 · github.com · its alternatives →
- 6
Open source APM: OpenTelemetry traces, metrics, and logs - uptrace/uptrace
2021 · github.com · its alternatives →
- 7
High-performance TensorFlow library for quantitative finance. - google/tf-quant-finance
2021 · github.com · its alternatives →
- 8
Hi HN, My name is JR and I had a need for a simple analytics solution that allowed me to store (timestamp, json) logs and run SQL over them. It was hard to find the right solution. Solutions like Mixpanel and Amplitude optimized for particular report types. Whereas solutions like Snowflake, BigQuery, etc. required a lot of setup. I built GraphJSON to fit in the middle. I strived for the ease of use of tools like Mixpanel and Amplitude, but wanted to ensure affordances were built to support use cases that big data warehouses enable. Under the hood, GraphJSON is powered by ClickHouse. This…
2022 · graphjson.com · its alternatives →
- 9
Hey HN, I'm Marc. I run Numia, a blockchain data company serving real-time APIs at near-petabyte scale. ObsessionDB is managed ClickHouse we built for ourselves that costs roughly 50% less than other managed options. Now we're launching it as a standalone service. We had the classic split: ClickHouse for real-time analytics APIs, BigQuery for data warehouse workloads. Data replicated between both, costs adding up. Managed ClickHouse worked but was too expensive to put our warehouse workload into. Self-hosted meant replica nodes doubling storage and waiting days to copy 25TB to new replicas.…
Jan 2026 · obsessiondb.com · its alternatives →
- 10PN
The source for financial, economic, and alternative datasets, serving investment professionals.
2013 · quandl.com · its alternatives →
- 11
PennyWhale▲67A search engine for fundamental financial data
2014 · pennywhale.com · its alternatives →
- 12
- 13
4/6 · The workflow of a professional quant trading firm.
2016 · soundcloud.com · its alternatives →
- 14
Hey HN, We are excited to announce that we’ve open-sourced AGX, a fast and lightweight data explorer for ClickHouse. It is designed for developers and analysts who want to leverage SQL-native querying in an IDE-like environment. Here’s what makes AGX stand out: - Built on ClickHouse (accessible via embedded chdb or remote instance). - IDE-like user interface: features tabs, a Monaco editor, and a fast keyboard workflow. - Zero setup required: no infrastructure or complex dashboards to manage. - Ideal for exploring live blockchain data, while also flexible enough for general ClickHouse usage…
2025 · github.com · its alternatives →
- 15
5/6 · The workflow of a professional quant trading firm.
2016 · soundcloud.com · its alternatives →
- 16
Invest in algo-driven, automatically rebalanced portfolios built by quants. Congressional trades, AI stocks, leveraged strategies and more. Start with $50.
2021 · getquantbase.com · its alternatives →
- 17CO
Thought i'd share some recent work i'd done after being generally frustrated as to the available analytics for Python modules. Most seem to be either limited in time or incur charges to query. Code is Apache 2 at https://github.com/clickHouse/clickpy The downloads for Python modules are actually available in BigQuery - a row for every package download in the world. Last time i checked it's the largest BigQuery public dataset at almost 700b rows. Wanting to do some serious analytics led to a few frustrations though: - speed for queries - BigQuery is great for complex SQL,…
2023 · clickpy.clickhouse.com · its alternatives →
- 18
ClickHouse is an open-source analytics DBMS for big data
2020 · clickhouse.com · its alternatives →
- 19
30x cheaper than Datadog. Predictable pricing. Exceptional customer support. 7,000+ happy customers. 60-day money back guarantee.
2021 · logtail.com · its alternatives →
- 20
While building an IoT telemetry solution, we ran into hurdles with Clickhouse. For one, you can't insert quickly AND durably into Clickhouse without setting up something like Kafka, which gets complicated for quick projects wanting to make use of Clickhouse's powerful features. Then, trying to actually query Clickhouse and show data in a UI required a whole backend API to handle auth and permissions. We figured that all these parts together – fast, durable ingest, row-level and column-level security and roles, and realtime streaming – were a lot of scaffolding to have to rebuild for every…
Aug 2026 · wavehouse.dev · its alternatives →
- 21
Escaping randomness, and turning to data for an edge
2016 · soundcloud.com · its alternatives →
- 22
I've built a type-safe semantic layer in code, for ClickHouse. If you're building analytics off ClickHouse in TypeScript, I would love your feedback. With hypequery there is no platform to adopt, no YAML sprawl. It runs where your app runs. Key features: - Define metrics once, reuse them everywhere: Declare dimensions and measures in one place and then pull from the same source of truth. - Compiles to ClickHouse SQL: No service, no proxy, no extra runtime to deploy. It's a library that generates SQL and runs where your app runs. - Multi-tenancy & Authentication ready: Cross-tenant queries…
Jun 2026 · github.com · its alternatives →
- 23
A simple re-implementation of Google's sparsehash as a learning excercise. - qpfiffer/Simple-Sparsehash
2015 · github.com · its alternatives →
- 24
I posted this a few weeks ago and the server died under the traffic. Fixed that by adding an in-mem caching layer with Redis/valkey and added CloudFront caching for static content. Also upgraded the server. Also fixed the Firefox bugs, trying again. It's a research tool for US stocks. Financials for ~10k companies pulled from SEC filings. You can chart any metric across companies, filter news by ticker, ask questions in plain English and get a chart back. There's also SQL console against the whole database, which is the part I like to use together with the AI chat (generates an SQL…
Jun 2026 · terminal.tesseractanalytics.ai · its alternatives →
Also compare
- ClickHouse-local – a small tool for serverless data analytics alternatives
- ClickHouse alternatives
- Query 1.6B rows in milliseconds, live alternatives
- A benchmark + latency sim for LLM db queries: ClickHouse / Postgres alternatives
- ScratchDB – Open-Source Snowflake on ClickHouse alternatives
- Distributed Tracing Using OpenTelemetry and ClickHouse alternatives
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →