| event_name | VARCHAR(16777216) | Type of trade event (OrderFilled, FPMMBuy, FPMMSell). |
| project | VARCHAR(16777216) | Name of the project (e.g., Polymarket). |
| protocol | VARCHAR(16777216) | Protocol name (e.g., polymarket). |
| 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). |
| market_address | VARCHAR(42) | Address of the prediction market contract. |
| order_hash | VARCHAR(16777216) | Unique hash of the order. |
| maker | VARCHAR(42) | Address of the maker in the trade. |
| taker | VARCHAR(42) | Address of the taker in the trade. |
| 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. Null for FPMM. |
| 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. |
| asset_id | VARCHAR(16777216) | Outcome token id, or the PositionManager id on v3 Combos rows. |
| collateral_amount_raw | VARCHAR(16777216) | Raw collateral amount (unnormalized). |
| token_amount_raw | VARCHAR(16777216) | Raw share amount (unnormalized). |
| price_str | VARCHAR(16777216) | Trade price per share, as a string. |
| price | FLOAT | Share price as a float. |
| maker_amount_raw | VARCHAR(16777216) | Raw amount provided by the maker. |
| taker_amount_raw | VARCHAR(16777216) | Raw amount provided by the taker. |
| 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 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_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) | Decimals of the collateral token. |
| collateral_amount | VARCHAR(16777216) | Collateral amount (normalized). |
| 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 (normalized). |
| usd_exchange_rate | FLOAT | USD exchange rate of the collateral token at the time of trade. |
| usd_collateral_amount | FLOAT | Collateral amount in USD. |
| 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 | Fee amount in USD. |
| transaction_index | NUMBER(38,0) | Index of the transaction in the block. |
| transaction_hash | VARCHAR(66) | Hash of the transaction. |
| log_index | NUMBER(38,0) | Log index of the trade event. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block containing the trade. |
| block_number | NUMBER(38,0) | Block number of 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) | The timestamp of the creation of the trade. |
| _updated_at | TIMESTAMP_NTZ(9) | The timestamp of the last update of the trade. |
