Skip to main content
Top of Book is an early access dataset available through SQL. It requires orderbook access. To request access, email support@probalytics.io.
Best bid and ask, their sizes, spread, and mid for each outcome. Computed at query time from verified orderbook snapshots (state = 'VERIFIED').

Raw view

top_of_book has one row per verified snapshot. It reads orderbook_snapshots directly, so always filter by market_id and a timestamp range:

Sampled views

The _1s, _10s, _1m, and _5m views are parameterized and return the book as of each bucket boundary, on a regular time grid:
  • Each row describes the last verified snapshot at or before timestamp. The book is carried forward through buckets with no updates.
  • The views look back at most 1 day before start for the starting book. If an outcome had no update in that window, its rows are null until the first update.
  • Rows are returned only for outcomes with at least one snapshot in the lookback window or range.

Fields

Usage tips