polymarket_polygon.combo_trades_v2

The polymarket_polygon.combo_trades_v2 table lists trades of Polymarket Combos (multi-leg parlays) on the v3 Exchange. There is one row per fill, unique on (block_month, trade_id). Each fill carries the combo’s labels and settlement from combo_details_v2 as they were when the fill was recorded. combo_details_v2 has the current values. A combo’s Yes side pays out only if every leg wins, so its price is the probability that all legs win. The exchange records one fill per maker order plus one combined fill for the taker. Filter WHERE is_taker_side to count each trade once. settlement_value_usd is usually NULL here, because combos settle after the fill. For the current value, join combo_details_v2 on outcome_id.

Table Schema

Column	Type	Description
`block_month`	`DATE`	UTC month of block_time
`block_time`	`TIMESTAMP`	UTC block time of the fill
`block_number`	`BIGINT`	Block number of the fill
`action`	`VARCHAR`	Type of trade; always ‘RFQ trade’ (combos are quoted by market makers, not traded on the order book)
`market_id`	`VARBINARY`	Id of the combo: its condition id (bytes), shared by the combo’s Yes and No tokens. For combo detail join combo_details on outcome_id
`outcome_id`	`UINT256`	Token id of the combo side traded; joins combo_details.outcome_id
`outcome_index`	`INTEGER`	Combo side traded: 0 = Yes, 1 = No
`outcome`	`VARCHAR`	Combo side traded as a label. Yes pays only if every leg wins
`amount`	`DOUBLE`	USD value of the fill (pUSD collateral treated 1:1 as USD)
`shares`	`DOUBLE`	Number of combo shares transferred
`price`	`DOUBLE`	Price per share of the side traded, 0-1; equals the implied joint probability that the side wins
`fee`	`DOUBLE`	Fee charged on this fill in USD
`maker`	`VARBINARY`	Address whose order was filled. On the aggregate taker fill this is the trader who took liquidity
`taker`	`VARBINARY`	Address filling the order. On the aggregate taker fill this is the V3 exchange itself
`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`	Side of maker’s order: ‘BUY’ if the maker acquired combo tokens, ‘SELL’ if the maker released them
`taker_side`	`VARCHAR`	Side of taker’s leg: always the inverse of maker_side. On the aggregate taker fill the taker is the exchange, so the trader’s own side is maker_side
`event_id`	`VARCHAR`	Always NULL: a combo has no parent event. Present so combo_trades and market_trades share the same columns
`maker_amount_raw`	`UINT256`	Raw maker amount filled, 6 decimals
`taker_amount_raw`	`UINT256`	Raw taker amount filled, 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) from the signed order
`combo_name`	`VARCHAR`	Generated combo name (‘question: outcome AND …’); null unless every leg is labeled
`leg_count`	`BIGINT`	Number of legs in the combo
`settlement_value_usd`	`DOUBLE`	Per-share payout of the side traded (0-1) as of when the fill was last written; usually null because combos settle after the incremental window. For the current value join combo_details on outcome_id
`contract_address`	`VARBINARY`	V3 exchange contract that emitted the fill
`evt_index`	`INTEGER`	Index of the event within the transaction
`tx_hash`	`VARBINARY`	Transaction hash
`trade_id`	`VARCHAR`	Fill identifier, ‘0x’ + tx_hash + ’:’ + evt_index; unique per fill
`_updated_at`	`TIMESTAMP`	When this row was last written. Unchanged rows keep their stamp.

Table sample

Query performance

combo_trades_v2 is partitioned by block_month. Always filter on block_time or block_month.

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_v2
WHERE is_taker_side
  AND block_time >= NOW() - INTERVAL '30' DAY
GROUP BY 1
ORDER BY 1

Previous version

polymarket_polygon.combo_trades (previous version)

Columns of the previous version, for queries that still use it until it is removed. The migration guide maps each old column to its new name.

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`	Address whose order was filled. On the aggregate taker fill this is the trader who took liquidity
`taker`	`VARBINARY`	Address filling the order. On the aggregate taker fill this is the v3 Exchange itself
`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`	Side of the taker’s leg: always the inverse of `maker_side`. On the aggregate taker fill the taker is the exchange, so the trader’s own side is `maker_side`
`event_id`	`VARCHAR`	Always NULL: a combo has no parent event. Present so `combo_trades` and `market_trades` share the same columns
`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

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index