polygon.predictions.trades_enriched table provides enhanced trade data with comprehensive market metadata, categorization, and outcome information. This table extends the basic trades data with rich context about markets, questions, and resolution outcomes.
Use this table for advanced analytics, market research, and outcome tracking across prediction markets on Polygon.
Table Columns
_str columns are numeric fields cast to varchar to retain precision.
Unique Key: unique_id
| Column Name | Data Type | Description |
|---|---|---|
| event_name | VARCHAR | Type of trade event (OrderFilled, FPMMBuy, FPMMSell). |
| project | VARCHAR | Project name where the trade occurred. |
| protocol | VARCHAR | Protocol name where the trade occurred. |
| exchange_type | VARCHAR | Exchange type (CTFExchange, NegRiskCTFExchange, FPMM). |
| condition_id | VARCHAR | Condition ID that identifies the prediction market condition. |
| market_id | VARCHAR | Market identifier from onchain data. |
| market_name | VARCHAR | Market name from onchain events. |
| market_description_onchain | VARCHAR | Market description from onchain events. |
| question_id | VARCHAR | Unique question identifier. |
| question | VARCHAR | Market question text. |
| question_description | VARCHAR | Market description from API. |
| neg_risk | BOOLEAN | Whether this is a NegRisk market. |
| category | VARCHAR | Main category (politics, sports, crypto, etc.). |
| sub_category | VARCHAR | Specific subcategory. |
| tags | VARCHAR | API category tags. |
| asset_id | VARCHAR | Asset/token ID of the outcome token being traded. |
| token_outcome | VARCHAR | Token outcome name. |
| token_outcome_name | VARCHAR | Combined outcome and question name. |
| token_price | FLOAT | Current token price. |
| is_winning_outcome | BOOLEAN | Whether this outcome won the market (API data). |
| market_address | VARCHAR | Address of the market contract where the trade occurred. |
| order_hash | VARCHAR | Hash of the order (null for FPMM trades). |
| maker | VARCHAR | Address of the maker (order creator) in the trade. |
| taker | VARCHAR | Address of the taker (order fulfiller) in the trade. |
| collateral_amount_raw | VARCHAR | Raw unnormalized collateral amount. |
| token_amount_raw | VARCHAR | Raw unnormalized outcome token amount. |
| price_str | VARCHAR | Calculated share price as a precise string representation. |
| trade_price | FLOAT | Calculated share price as float for calculations and analytics. |
| maker_amount_raw | VARCHAR | Raw unnormalized amount from maker side of the trade. |
| taker_amount_raw | VARCHAR | Raw unnormalized amount from taker side of the trade. |
| fee_raw | VARCHAR | Raw unnormalized fee amount. |
| collateral_amount | VARCHAR | Collateral amount. |
| fee_amount | VARCHAR | Fee amount. |
| fee_bips | NUMBER | Fee in basis points from market metadata. |
| collateral_token_address | VARCHAR | Address of the collateral token. |
| collateral_token_name | VARCHAR | Name of the collateral token. |
| collateral_token_symbol | VARCHAR | Symbol of the collateral token. |
| collateral_token_decimals | NUMBER | 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_amount | FLOAT | USD value of the fee paid in the trade. |
| oracle | VARCHAR | Oracle contract address for market resolution. |
| resolution_outcome | VARCHAR | Market resolution outcome (Yes/No/Unresolved). |
| transaction_index | NUMBER | Index of the transaction in the block. |
| transaction_hash | VARCHAR | Hash of the transaction containing the trade. |
| log_index | NUMBER | Index of the log within the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block containing the trade. |
| block_number | NUMBER | Block number containing the trade. |
| block_hash | VARCHAR | Hash of the block containing the trade. |
| unique_id | VARCHAR | Unique identifier for each trade. |
| _created_at | TIMESTAMP_NTZ(9) | Record creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Record update timestamp. |
Sample Query
- Market Analysis
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