OHLC candles are an early access dataset available through SQL. To request access, email support@probalytics.io.
Shape
OHLC candles are served by parameterized SQL views, one per bucket size:
Each view takes one market and a time range:
The result has one row per outcome per bucket, ordered by outcome and time. Every bucket in the range is present, including buckets with no trades.
Construction
Candles are computed at query time from fills, so they cover the same venues and history as fills and reflect corrections to fills immediately.- Ordering. Fills with the same timestamp are ordered by on-chain block number and log index where available, so
openandcloseare deterministic. - Carry-forward. For buckets with no trades,
open,high,low, andcloseequal the most recent close, including a close from beforestart. Volume fields are0andvwapisnull. - Outcomes. Every outcome of the market gets a row per bucket, even outcomes that never traded (all prices
null).
Usage tips
- Pick the largest bucket that answers your question. A day of
ohlc_1sis 86,400 rows per outcome. - Use
WHERE tradedto drop filler buckets when you only want real trading activity. closeis a last-trade price, not a book mid. For mid prices usetop_of_book_*.