Columnar open source time-series database with high performance ingestion and blazingly fast SQL analytics. Self-hosted or fully managed.
Query three large datasets and more than 2 billion rows in milliseconds with SQL
Try QuestDB demo in your browser
QuestDB enhances ANSI SQL with time series extensions to manipulate time stamped data
SELECT timestamp, tempCFROM sensorsWHERE timestamp IN '2021-05-14;1M';
-- Search timeSELECT timestamp, tempCFROM sensorsWHERE timestamp IN '2021-05-14;1M';
SELECT timestamp, avg(tempC)FROM sensorsSAMPLE BY 5m;
-- Slice timeSELECT timestamp, avg(tempC)FROM sensorsSAMPLE BY 5m;
SELECT timestamp, sensorName, tempCFROM sensorsLATEST ON timestamp PARTITION BY sensorName;
-- Navigate timeSELECT timestamp, sensorName, tempCFROM sensorsLATEST ON timestamp PARTITION BY sensorName;
SELECT sensors.timestamp ts, rain1HFROM sensorsASOF JOIN weather;
-- Merge timeSELECT sensors.timestamp ts, rain1HFROM sensorsASOF JOIN weather;
Interactive console to import data (drag and drop) and start querying right away.
Check our Web Console documentation to get started.