> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# polymarket_polygon.combo_prices_hourly

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

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

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

<TableSample tableSchema="polymarket_polygon" tableName="combo_prices_hourly" />

## Example query

```sql theme={null}
-- 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
```