| project | VARCHAR | Project identifier (jupiter or dflow). |
| protocol | VARCHAR | Protocol identifier (kalshi). |
| trade_date | DATE | Date of the trade execution. |
| timestamp | TIMESTAMP_NTZ(9) | Timestamp when the fill instruction was executed on-chain. |
| trade_id | VARCHAR | Unique identifier for the trade (Kalshi order ID). |
| 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 | Derived YES price at execution (0-1 scale). |
| no_price | FLOAT | Derived NO price at execution (0-1 scale). |
| taker_price | FLOAT | Actual execution price paid by the taker. |
| settlement_token_price | FLOAT | Settlement token USD price at trade time (USDC or CASH depending on project). |
| venue_fee_usd | FLOAT | Kalshi venue fee paid in USD. |
| market_event_id | VARCHAR | Event identifier for the market (from Kalshi markets table). |
| market_name | VARCHAR | Market name (from Kalshi markets table). |
| market_question | VARCHAR | Market question text (from Kalshi markets table). |
| market_description | VARCHAR | Market description (from Kalshi markets table). |
| market_category | VARCHAR | Market category classification (from Kalshi markets table). |
| market_status | VARCHAR | Current status of the market (from Kalshi markets table). |
| market_start_date | TIMESTAMP_NTZ(9) | Timestamp when the market opened for trading (from Kalshi markets table). |
| market_end_date | TIMESTAMP_NTZ(9) | Timestamp when the market closes for trading (from Kalshi markets table). |
| market_expected_expiration_time | TIMESTAMP_NTZ(9) | Expected timestamp for market expiration (from Kalshi markets table). |
| market_expiration_time | TIMESTAMP_NTZ(9) | Actual expiration timestamp of the market (from Kalshi markets table). |
| market_outcome | VARCHAR | Market outcome resolution (from Kalshi markets table). |
| market_resolved_at | TIMESTAMP_NTZ(9) | Timestamp when the market was resolved (from Kalshi markets table). |
| order_created_time | TIMESTAMP_NTZ(9) | Timestamp when the order was created on-chain. |
| order_txn_id | VARCHAR | Transaction signature of the create_order instruction. |
| fill_txn_id | VARCHAR | Transaction signature of the fill instruction. |
| extras | VARIANT | JSON object containing technical fields (position_pda, order_pda, external_order_id). |
| _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. |
