Skip to main content
The polymarket_polygon.ohlcv_hourly table has hourly price candles (open, high, low, close and volume) for every Polymarket outcome token, with the volume-weighted average price (vwap). Each market or combo has two rows per hour, one per side. It covers regular markets and Combos (multi-leg parlays) over the full trading history on Polygon. Each row is unique on (block_month, hour, market_id, outcome_index). For market details, join market_details or combo_details on outcome_id. Hours without trades get a flat bar at the last close, with zero volume. Open markets get bars up to the current hour. A market’s candles end in the hour it resolves. In that last bar:
  • close is the settlement value: 1 for the winning side and 0 for the losing side (from market_details.settlement_value_usd), 0.5 for 50/50 markets, and the payout share for partial combos.
  • open is the last traded price.
  • high and low stretch to include the settlement value, so low <= open, close <= high always holds.
Bars with real trades after resolution are kept with their actual prices. Carried-forward bars after resolution are dropped.
market_outcome shows what was known at each bar: unresolved before the resolution hour, and the result from that hour on. Past bars are never relabeled. For a market’s current state, use market_details or combo_details.
v2 removes market_end_time from the candles. To see when a market resolved, join market_details on outcome_id and use settlement_ts.

Table Schema

Table sample

Query performance

ohlcv_hourly is partitioned by block_month. Always filter on block_month or hour, and on market_id or outcome_id for a single market.

Example query

Previous version

Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.