| project | VARCHAR | Project identifier (ex. jupiter). |
| protocol | VARCHAR | Protocol identifier (kalshi). |
| trade_date | DATE | Date of the trade execution. |
| timestamp | TIMESTAMP_NTZ(9) | Timestamp when the trade was executed on-chain. |
| trade_id | VARCHAR | Unique identifier for the trade. |
| ticker | VARCHAR | Kalshi market ticker identifier. |
| num_contracts | INTEGER | Number of contracts filled in this trade. |
| user_address | VARCHAR | Solana wallet address of the trader. |
| action | VARCHAR | Trade action (buy or sell) - buy increases position, sell decreases position. |
| taker_side | VARCHAR | Side taken by the taker (yes or no). |
| maker_side | VARCHAR | Side taken by the maker (opposite of taker_side). |
| yes_price | FLOAT | YES price at execution (0-1 scale). |
| no_price | FLOAT | NO price at execution (0-1 scale). |
| taker_price | FLOAT | Actual execution price paid by the taker. |
| usdc_price | FLOAT | USDC/USD exchange rate at trade time. |
| venue_fee_usd | FLOAT | Kalshi venue fee paid in USD. |
| market_event_id | VARCHAR | Event identifier for the market. |
| market_name | VARCHAR | Market name. |
| market_question | VARCHAR | Market question text. |
| market_description | VARCHAR | Market description. |
| market_category | VARCHAR | Market category classification. |
| market_status | VARCHAR | Current status of the market. |
| 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 | 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. |
| order_txn_id | VARCHAR | Transaction signature of the order creation. |
| fill_txn_id | VARCHAR | Transaction signature of the trade execution. |
| extras | VARIANT | JSON object containing additional technical fields. |
| _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. |
