polygon.predictions.trades_enriched table is Polymarket trade fills with market question, category, and resolution context on each row. Combos (v3) fills are included: market_name and parlay_description describe the parlay.
Table Details
| Property | Value |
|---|---|
| Table Name | polygon.predictions.trades_enriched |
| Table Status | Beta 🌱 |
| Unique Key | transaction_hash, unique_id |
Table Columns
_str columns are numeric fields cast to varchar to retain precision.
| Column Name | Data Type | Description |
|---|---|---|
| event_name | VARCHAR(16777216) | Type of trade event (OrderFilled, FPMMBuy, FPMMSell). |
| project | VARCHAR(16777216) | Project name where the trade occurred. |
| protocol | VARCHAR(16777216) | Protocol name where the trade occurred. |
| exchange_type | VARCHAR(16777216) | Exchange type: CTFExchange, NegRiskCTFExchange, CTFExchangeV2, NegRiskCTFExchangeV2, ComboExchange, or FPMM. |
| contract_version | VARCHAR(16777216) | Exchange contract version: v1, v2, or v3 (Combos). |
| side | NUMBER(38,0) | Maker order side. 0 = BUY (bid), 1 = SELL (ask). |
| side_name | VARCHAR(16777216) | BUY if the maker posted a bid, SELL if the maker posted an ask. |
| builder | VARCHAR(16777216) | Order attribution field (bytes32). |
| metadata | VARCHAR(16777216) | Per-order data field (bytes32). |
| condition_id | VARCHAR(16777216) | Market condition id, or the combo id on v3 Combos rows. |
| market_id | VARCHAR(16777216) | Market identifier from onchain data. |
| market_name | VARCHAR(16777216) | Title of the neg-risk event the market belongs to, or the market question when no event title is available. ‘single market’ for markets outside a neg-risk event and for native Polymarket Protocol V2 markets. For Polymarket Protocol V2 tokens not listed in the markets table, the token’s own market name (the combo name for combo tokens). |
| market_description_onchain | VARCHAR(16777216) | Market description from onchain events. |
| question_id | VARCHAR(16777216) | Unique question identifier. |
| question | VARCHAR(16777216) | Market question text. |
| question_description | VARCHAR(16777216) | Market description. |
| neg_risk | BOOLEAN | Whether this is a NegRisk market. |
| category | VARCHAR(16777216) | Main category (politics, sports, crypto, etc.). |
| sub_category | VARCHAR(16777216) | Specific subcategory. |
| tags | VARCHAR(16777216) | Category tags published by the venue. |
| asset_id | VARCHAR(16777216) | Outcome token id, or the PositionManager id on v3 Combos rows. |
| token_outcome | VARCHAR(16777216) | Token outcome name. |
| token_outcome_name | VARCHAR(16777216) | Combined outcome and question name. |
| token_price | FLOAT | Current token price. |
| is_winning_outcome | BOOLEAN | Whether this outcome won the market. |
| market_address | VARCHAR(42) | Address of the market contract where the trade occurred. |
| order_hash | VARCHAR(16777216) | Hash of the order. |
| maker | VARCHAR(42) | Address of the maker (order creator) in the trade. |
| taker | VARCHAR(42) | Address of the taker (order fulfiller) in the trade. |
| collateral_amount_raw | VARCHAR(16777216) | Raw unnormalized collateral amount. |
| token_amount_raw | VARCHAR(16777216) | Raw unnormalized outcome token amount. |
| price_str | VARCHAR(16777216) | Trade price per share, as a string. |
| trade_price | FLOAT | Trade price per share. |
| maker_amount_raw | VARCHAR(16777216) | Raw unnormalized amount from maker side of the trade. |
| taker_amount_raw | VARCHAR(16777216) | Raw unnormalized amount from taker side of the trade. |
| fee_charged_raw | VARCHAR(16777216) | Gross fee for the fill in raw collateral units. |
| fee_rebate_raw | VARCHAR(16777216) | Maker rebate for the fill in raw collateral units. |
| fee_raw | VARCHAR(16777216) | Raw unnormalized fee amount. |
| fee_charged_event_count | NUMBER(38,0) | Number of FeeCharged events in the transaction. |
| fee_rebate_event_count | NUMBER(38,0) | Number of FeeRefunded events in the transaction. |
| collateral_amount | VARCHAR(16777216) | Collateral amount. |
| fee_charged_amount | VARCHAR(16777216) | Per-row gross fee in collateral token units. |
| fee_rebate_amount | VARCHAR(16777216) | Per-row maker rebate in collateral token units. |
| fee_amount | VARCHAR(16777216) | Fee amount. |
| fee_bips | VARCHAR(16777216) | Fee in basis points. |
| collateral_token_address | VARCHAR(42) | Address of the collateral token. |
| collateral_token_name | VARCHAR(16777216) | Name of the collateral token. |
| collateral_token_symbol | VARCHAR(16777216) | Symbol of the collateral token. |
| collateral_token_decimals | NUMBER(38,0) | Number of decimals for the collateral token. |
| usd_exchange_rate | FLOAT | USD exchange rate for the collateral token. |
| usd_collateral_amount | FLOAT | USD value of the collateral amount. |
| usd_fee_charged_amount | FLOAT | USD value of the per-row gross fee. |
| usd_fee_rebate_amount | FLOAT | USD value of the per-row maker rebate. |
| usd_fee_amount | FLOAT | USD value of the fee paid in the trade. |
| fee_type | VARCHAR(16777216) | V2 fee scheme classifier (e.g. ‘cubic_v0’). |
| fees_enabled | BOOLEAN | True when fees are charged on this market. |
| rfq_enabled | BOOLEAN | Whether the market accepts RFQ orders. |
| fee_rebate_rate | FLOAT | V2 maker fee rebate rate (0.0-1.0). |
| fee_rate | FLOAT | V2 base fee rate parameter for the cubic fee curve. |
| fee_exponent | FLOAT | V2 cubic fee curve exponent. |
| fee_taker_only | BOOLEAN | True when only the taker is charged a fee. |
| maker_base_fee_bps | NUMBER(38,0) | V2 base maker fee in basis points (1 bps = 0.01%). |
| taker_base_fee_bps | NUMBER(38,0) | V2 base taker fee in basis points. |
| extras | VARIANT | VARIANT column with platform-specific metadata. |
| oracle | VARCHAR(42) | Oracle contract address for market resolution. |
| resolution_outcome | VARCHAR(16777216) | Market resolution outcome (Yes/No/Unresolved). |
| transaction_index | NUMBER(38,0) | Index of the transaction in the block. |
| transaction_hash | VARCHAR(66) | Hash of the transaction containing the trade. |
| log_index | NUMBER(38,0) | Index of the log within the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block containing the trade. |
| block_number | NUMBER(38,0) | Block number containing the trade. |
| block_hash | VARCHAR(66) | Hash of the block containing the trade. |
| unique_id | VARCHAR(16777216) | Concatenated identifier for the trade. |
| _created_at | TIMESTAMP_NTZ(9) | Record creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Record update timestamp. |
| parlay_description | VARCHAR(16777216) | Readable parlay of the combo legs, e.g. YES(Will Spain win?) AND NO(Will France win?). |
| combo_n_legs | NUMBER(38,0) | Number of legs in the combo. |
| combo_all_legs_resolved | BOOLEAN | True when every leg of the combo is identified. |
Sample Query
- Market Analysis
- Combos v3
Analyze trading volume by market category:
select
category,
count(*) as total_trades,
count(distinct market_id) as unique_markets,
sum(usd_collateral_amount) as total_volume_usd
from polygon.predictions.trades_enriched
where block_timestamp >= current_timestamp - interval '30 days'
group by category
order by total_volume_usd desc
Combos fills with parlay text:
select
contract_version,
market_name,
parlay_description,
combo_n_legs,
condition_id,
usd_collateral_amount,
block_timestamp
from polygon.predictions.trades_enriched
where contract_version = 'v3'
and block_timestamp >= current_timestamp - interval '7 days'
order by block_timestamp desc