QuestDB is the world's fastest growing open-source time-series database. It offers massive ingestion throughput, millisecond queries, powerful time-series SQL extensions, and scales well with minimal and maximal hardware. Save costs with better performance and efficiency.
Query over 1.2 billion rows in milliseconds
Try QuestDB demo in your browser
Easily adopted, time-series optimized SQL
SELECT timestamp, symbol, priceFROM tradesWHERE timestamp IN '2024-06-21;1M';
-- Search timeSELECT timestamp, symbol, priceFROM tradesWHERE timestamp IN '2024-06-21;1M';
SELECT timestamp, symbol, avg(price)FROM tradesSAMPLE BY 5m FILL(LINEAR);
-- Slice timeSELECT timestamp, symbol, avg(price)FROM tradesSAMPLE BY 5m FILL(LINEAR);
SELECT timestamp, symbol, priceFROM tradesLATEST ON timestamp PARTITION BY symbol;
-- Navigate timeSELECT timestamp, symbol, priceFROM tradesLATEST ON timestamp PARTITION BY symbol;
SELECT timestamp, bid_price, ask_priceFROM bidsASOF JOIN asks;
-- Merge timeSELECT timestamp, bid_price, ask_priceFROM bidsASOF JOIN asks;
Hyper ingestion
For massive volumes of time-series data, trust a specialized time-series database. Timestamps are first-class, and blistering throughput is sustained even through the highest data cardinality. Deduplication and out-of-order ingestion also work right out-of-the-box.
Category user reviews on G2 rate QuestDB with the highest user satisfaction. Visit our vibrant Slack to chat with the community, the QuestDB core developers, and our technical AI-bot, to find out why.
Max performance, min hardware
Compute costs keep rising. Keep them low with an efficient solution. QuestDB runs well on low hardware, within high cardinality data and with deduplication and out-of-order indexing. On just a 4GB Raspberry Pi, QuestDB outperforms competitors on robust hardware. Have robust hardware? QuestDB scales up to many millions of rows per second.
QuestDB is a time series database truly built by developers for developers. We found that QuestDB provides a unicorn solution to handle extreme TPS while also offering a simplified SQL programming interface.