New on the #QuestDB blog: how QWP gets a timestamp down to a single bit.
Gorilla encoding stores how much the gap between rows changed rather than the timestamp. On a steady cadence that is zero every time.
4.9x on a burst of crypto trades, about 57x on a sampled series.
A blotter that flashes on every tick, candles building in front of you, top of book across four ECNs. All of it inside a #QuestDB notebook, refreshing as new data arrives, with colours driven by your own thresholds.
Coming soon to the Web Console.
You can now run #QuestDB Enterprise on your own data for 30 days. The full build: replication, restart-free promotion, cold storage, access control. No limits on cores or nodes.
No discovery call. Fill the form, the download link arrives within one business day.
ASOF JOIN, WINDOW JOIN or HORIZON JOIN? If the sentence describing what you want has "during" in it, you want a window. If it has "earlier" or "later", you want a horizon.
New on the #QuestDB blog: a guide to the five time-series joins, with queries that run on the live demo.
481,132 EURUSD trades so far today. SUBSAMPLE sdt brings that to 3,300 rows, or to 46, depending on the error tolerance you give it.
It picks rows rather than computing them, so every point is a real trade with its original timestamp. New in #QuestDB.