polymarket_polygon.combo_prices_hourly

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

Combo actions Users Address Lookup

​Table Schema

​Table sample

​Example query

Table Schema

Table sample

Example query