polymarket_polygon.combo_prices_hourly

Polymarket Combos hourly price snapshots — combo token joint probabilities aggregated by hour.

The polymarket_polygon.combo_prices_hourly table contains hourly combo token prices: the last trade price per token-hour, forward-filled across quiet hours — the combos twin of market_prices_hourly.

The forward-fill stops at the hour the combo is decided (first lost leg, or last leg resolved); that final row carries the exact settlement value from combo_details. For hours after the decision, read combo_details.settlement_value — it can never change again.

Table Schema

Column	Type	Description
block_month	DATE	Month partition derived from hour
hour	TIMESTAMP	The hour for which the price is valid
combo_condition_id	VARBINARY	Combo condition ID (bytes31), shared by the combo’s YES and NO tokens
token_id	UINT256	v3 PositionManager token ID of the combo side; joins combo_details.token_id
price	DOUBLE	Price of the combo token at the end of the hour (its joint probability, 0–1); the decision-hour row is the exact settlement value
_updated_at	TIMESTAMP	When this row was last inserted or updated by the dbt pipeline

Table sample

Example query

-- Price history for a labeled combo
SELECT
  p.hour,
  d.token_outcome,
  p.price
FROM polymarket_polygon.combo_prices_hourly p
JOIN polymarket_polygon.combo_details d
  ON p.token_id = d.token_id
WHERE d.combo_name = 'Team A wins: Yes AND Team B wins: Yes'
ORDER BY p.hour