polymarket_polygon.combo_trades

The polymarket_polygon.combo_trades table contains trade-level activity for Polymarket Combos (multi-leg parlays) on the v3 Exchange. One row per fill, enriched with combo metadata from combo_details. A combo’s YES token pays out only if every leg wins; its price is the joint probability of that outcome. The exchange emits maker fills plus one aggregate taker fill per settlement — filter WHERE is_taker_side for single-counted volume.

Table Schema

Column	Type	Description
`block_month`	`DATE`	UTC month of the event block time (partition key)
`block_time`	`TIMESTAMP`	UTC event block time
`block_number`	`BIGINT`	Block number in which the trade was executed
`action`	`VARCHAR`	Type of trade (RFQ trade)
`combo_condition_id`	`VARBINARY`	Combo condition ID (bytes31), shared by the combo’s YES and NO tokens; for combo detail join `combo_details` on `token_id = asset_id`
`asset_id`	`UINT256`	v3 PositionManager token ID of the combo side traded; joins `combo_details.token_id`
`outcome_index`	`INTEGER`	Combo side traded: 0 = YES, 1 = NO
`outcome`	`VARCHAR`	Combo side traded as label; Yes pays out only if every leg wins
`amount`	`DOUBLE`	Amount in USD (pUSD treated 1:1 as USD)
`shares`	`DOUBLE`	Amount of combo shares transferred
`price`	`DOUBLE`	Price of the combo side traded = its joint probability (0–1)
`fee`	`DOUBLE`	Per-fill fee in USD (reconciles exactly with the Exchange `FeeCharged` events)
`maker`	`VARBINARY`	Trader whose order is being filled
`taker`	`VARBINARY`	Trader filling the order; the v3 Exchange proxy on the aggregate taker fill
`is_taker_side`	`BOOLEAN`	TRUE on the aggregate taker fill (one per settlement). Filter `WHERE is_taker_side` for single-counted volume
`maker_side`	`VARCHAR`	`BUY` = maker acquiring combo tokens, `SELL` = releasing them
`taker_side`	`VARCHAR`	Inverse of `maker_side`
`maker_amount_raw`	`UINT256`	Raw `makerAmountFilled` (6 decimals)
`taker_amount_raw`	`UINT256`	Raw `takerAmountFilled` (6 decimals)
`order_hash`	`VARBINARY`	EIP-712 hash of the filled order
`builder`	`VARBINARY`	Builder attribution field (bytes32) from the signed order
`metadata`	`VARBINARY`	Order metadata field (bytes32)
`combo_name`	`VARCHAR`	Generated combo name (`question: outcome AND ...`); NULL unless every leg is labeled
`token_outcome_name`	`VARCHAR`	Combination of the side traded and the combo name (`Yes-...` / `No-...`); NULL when `combo_name` is NULL
`leg_count`	`BIGINT`	Number of legs in the combo
`settlement_value`	`DOUBLE`	What the side traded settled at per share (0–1). Realized PnL of a buy = `(settlement_value - price) * shares`. NULL while the combo is undecided
`contract_address`	`VARBINARY`	v3 Exchange proxy that emitted the fill
`evt_index`	`INTEGER`	Index of the event within the transaction
`tx_hash`	`VARBINARY`	Transaction hash
`_updated_at`	`TIMESTAMP`	When this row was last inserted or updated by the dbt pipeline

Table sample

Example query

-- Combo volume and fees by day (single-counted)
SELECT
  DATE_TRUNC('day', block_time) AS day,
  SUM(amount) AS volume_usd,
  SUM(fee) AS fees_usd,
  COUNT(*) AS num_fills
FROM polymarket_polygon.combo_trades
WHERE is_taker_side
  AND block_time >= NOW() - INTERVAL '30' DAY
GROUP BY 1
ORDER BY 1

​Table Schema

​Table sample

​Example query

Table Schema

Table sample

Example query