Skip to main content
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 open and close are deterministic.
  • Carry-forward. For buckets with no trades, open, high, low, and close equal the most recent close, including a close from before start. Volume fields are 0 and vwap is null.
  • 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_1s is 86,400 rows per outcome.
  • Use WHERE traded to drop filler buckets when you only want real trading activity.
  • close is a last-trade price, not a book mid. For mid prices use top_of_book_*.