common.predictions.kalshi_trades_enriched table provides enhanced trade data with comprehensive market metadata, categorization, event information, and settlement outcomes. This table extends the basic trades data with rich context about markets, questions, and resolution outcomes.
Use this table for advanced analytics, market research, category analysis, and outcome tracking across Kalshi prediction markets.
Table Columns
Data Precision Notes:- Prices are stored as floats on a 0-1 scale (e.g., 0.65 = $0.65)
- Each contract is worth $1 at settlement
- Includes all columns from the trades table plus market metadata
trade_id
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | Project identifier, always ‘kalshi’. |
| protocol | VARCHAR | Protocol identifier, always ‘kalshi’. |
| trade_date | DATE | Date of the trade (used for partitioning). |
| created_time | TIMESTAMP_NTZ(9) | Timestamp when the trade was created. |
| trade_id | VARCHAR | Unique identifier for the trade. |
| ticker | VARCHAR | Market ticker identifier for this trade. |
| num_contracts | NUMBER | Number of contracts traded in this trade. |
| 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 | Price for “yes” outcome as a float (0-1 scale). |
| no_price | FLOAT | Price for “no” outcome as a float (0-1 scale). |
| taker_price | FLOAT | Price paid by the taker based on taker_side. |
| 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. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation on Allium’s database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update on Allium’s database. |