| project | VARCHAR(16777216) | Project identifier (jupiter, dflow, or world). |
| protocol | VARCHAR(16777216) | Protocol identifier (kalshi, polymarket, or world). |
| trade_date | DATE | Date of the trade execution. |
| timestamp | TIMESTAMP_NTZ(9) | Timestamp when the trade executed on-chain. |
| trade_id | VARCHAR(16777216) | Unique identifier for the trade (venue order ID). |
| ticker | VARCHAR(16777216) | Market ticker identifier. On-chain market address for World rows. |
| num_contracts | FLOAT | Number of contracts filled in this trade. |
| user_address | VARCHAR(16777216) | Solana wallet address of the trader. |
| action | VARCHAR(16777216) | Trade action (buy or sell) - buy increases position, sell decreases position. |
| taker_side | VARCHAR(16777216) | Side taken by the taker (yes or no). |
| maker_side | VARCHAR(16777216) | Side taken by the maker (opposite of taker_side). |
| yes_price | FLOAT | YES outcome price at execution, on a 0-1 scale. yes_price + no_price = 1. |
| no_price | FLOAT | NO outcome price at execution, on a 0-1 scale. yes_price + no_price = 1. |
| taker_price | FLOAT | Execution price paid by the taker for their side, on a 0-1 scale. |
| settlement_token_price | FLOAT | Settlement token USD price at trade time (USDC, JupUSD, or CASH depending on project). |
| venue_fee_usd | FLOAT | Venue fee paid in USD. |
| market_event_id | VARCHAR(16777216) | Event identifier for the market. |
| market_name | VARCHAR(16777216) | Market name. |
| market_question | VARCHAR(16777216) | Market question text. |
| market_description | VARCHAR(16777216) | Market description. |
| is_mve | BOOLEAN | True for multi-variable event markets. |
| market_category | VARCHAR(16777216) | Market category classification. |
| market_sub_category | VARCHAR(16777216) | Polymarket sub-category. Populated for Polymarket markets; null for Kalshi, DFlow, and World. |
| market_status | VARCHAR(16777216) | Current status of the market. World markets report active or settled. |
| market_start_date | TIMESTAMP_NTZ(9) | Timestamp when the market opened for trading. |
| market_end_date | TIMESTAMP_NTZ(9) | Timestamp when the market closes for trading. |
| market_expected_expiration_time | TIMESTAMP_NTZ(9) | Expected timestamp for market expiration. |
| market_expiration_time | TIMESTAMP_NTZ(9) | Actual expiration timestamp of the market. |
| market_outcome | VARCHAR(16777216) | Market outcome resolution. |
| market_resolved_at | TIMESTAMP_NTZ(9) | Timestamp when the market was resolved. |
| order_created_time | TIMESTAMP_NTZ(9) | Timestamp when the order was created on-chain. Null for World, which has no separate order-creation step. |
| order_txn_id | VARCHAR(16777216) | Transaction signature of the order-creation transaction. Null for World. |
| fill_txn_id | VARCHAR(16777216) | Transaction signature of the fill transaction. |
| extras | VARIANT | Platform-specific metadata for the trade. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was created in Allium’s database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated in Allium’s database. |
