prediction_markets.ohlcv_hourly

The prediction_markets.ohlcv_hourly table provides hourly OHLCV bars across Polymarket and Kalshi, including Polymarket Combos (multi-leg parlays, keyed by the combo condition ID; is_parlay = TRUE in the markets dimension). Grain: one row per (venue, hour, market_id, outcome). Prices are in probability space [0, 1]. Polymarket emits Yes and No bars; Kalshi emits Yes only (No can be derived as 1 - Yes). Hours without trades carry the previous close forward and are flagged via is_forward_filled. Resolved markets are pinned to 1.0 / 0.0 after expiration (Combos to their exact settlement value).

Table Schema

Column	Type	Description
`venue`	`VARCHAR`	`polymarket` or `kalshi`
`block_month`	`DATE`	First day of the calendar month of `hour` (partition key)
`hour`	`TIMESTAMP`	Bar timestamp, truncated to the hour
`market_id`	`VARCHAR`	Polymarket `condition_id` (combo condition ID for Combos) / Kalshi `ticker`
`outcome`	`VARCHAR`	Outcome side this bar represents
`market_name`	`VARCHAR`	Market title (denormalized); for combos the generated combo name, NULL unless every leg is labeled
`category`	`VARCHAR`	Unified category enum
`category_native`	`VARCHAR`	Original upstream category value
`open`	`DOUBLE`	Opening probability of the bar, in `[0, 1]`
`high`	`DOUBLE`	Bar high, in `[0, 1]`
`low`	`DOUBLE`	Bar low, in `[0, 1]`
`close`	`DOUBLE`	Closing probability of the bar, in `[0, 1]`
`vwap`	`DOUBLE`	Volume-weighted average price for the bar. NULL when no trades
`volume_contracts`	`DOUBLE`	Total contracts traded in the hour
`volume_usd`	`DOUBLE`	Total USD notional traded in the hour
`volume_usd_yes`	`DOUBLE`	USD notional traded on the Yes side
`volume_usd_no`	`DOUBLE`	USD notional traded on the No side. NULL for Kalshi (Yes-only)
`trade_count`	`BIGINT`	Number of fills in the hour
`market_end_time`	`TIMESTAMP`	Market expiration time (denormalized)
`market_outcome`	`VARCHAR`	Resolved outcome (denormalized). NULL while unresolved
`event_market_name`	`VARCHAR`	Event group label (denormalized)
`is_forward_filled`	`BOOLEAN`	TRUE when the bar has no trades and was carried forward
`_updated_at`	`TIMESTAMP`	When this row was last written by the pipeline

Table sample

Query performance

block_month is the partition key. Always include a block_month or hour filter.

Example query

-- Daily VWAP across both venues for a single category, last 30 days
SELECT
  venue,
  DATE_TRUNC('day', hour) AS day,
  AVG(vwap) AS avg_daily_vwap,
  SUM(volume_usd) AS volume_usd
FROM prediction_markets.ohlcv_hourly
WHERE hour >= NOW() - INTERVAL '30' DAY
  AND category = 'politics'
  AND vwap IS NOT NULL
GROUP BY 1, 2
ORDER BY 1, 2

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

prediction_markets.ohlcv_hourly

Table Schema

Table sample

Query performance

Example query

​Table Schema

​Table sample

​Query performance

​Example query

Table Schema

Table sample

Query performance

Example query