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:
closeis the settlement value: 1 for the winning side and 0 for the losing side (frommarket_details.settlement_value_usd), 0.5 for 50/50 markets, and the payout share forpartialcombos.openis the last traded price.highandlowstretch to include the settlement value, solow <= open, close <= highalways holds.
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.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
Previous version (v1)
Previous version (v1)
Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.