| project | VARCHAR(16777216) | Project identifier, always ‘jupiter’. |
| protocol | VARCHAR(16777216) | Protocol identifier, always ‘kalshi’. |
| market_unique_id | VARCHAR(16777216) | Unique identifier for the Kalshi market ticker (e.g., KXFEDDECISION-25DEC-C25). |
| market_event_id | VARCHAR(16777216) | Event identifier that groups related markets together. |
| market_series_id | VARCHAR(16777216) | Series ticker identifier for the event. |
| market_mve_id | VARCHAR(16777216) | Multi-variable event (MVE) collection ticker. |
| is_mve | BOOLEAN | True for multi-variable event markets. |
| market_name | VARCHAR(16777216) | Market title describing the prediction question. |
| question_id | VARCHAR(16777216) | Question identifier. |
| question | VARCHAR(16777216) | Question text from the event. |
| description | VARCHAR(16777216) | Market description. |
| last_token_price | FLOAT | Last traded price as a float (0-1 scale). |
| market_status | VARCHAR(16777216) | Current status (active, open, closed, finalized, settled). |
| active | BOOLEAN | Boolean flag indicating if the market is active or open. |
| closed | BOOLEAN | Boolean flag indicating if closed, finalized, or settled. |
| accepting_orders | BOOLEAN | Boolean flag indicating if currently accepting orders. |
| category | VARCHAR(16777216) | Category classification of the market. |
| start_date | TIMESTAMP_NTZ(9) | Timestamp when the market opened for trading. |
| end_date | TIMESTAMP_NTZ(9) | Timestamp when the market closes for trading. |
| expected_expiration_time | TIMESTAMP_NTZ(9) | Expected timestamp for market expiration. |
| expiration_time | TIMESTAMP_NTZ(9) | Actual expiration timestamp of the market. |
| latest_expiration_time | TIMESTAMP_NTZ(9) | Latest possible expiration timestamp. |
| seconds_delay | FLOAT | Settlement timer in seconds. |
| can_close_early | BOOLEAN | Boolean flag indicating if the market can close before expiration. |
| expiration_value | VARCHAR(16777216) | Value used to determine market settlement. |
| strike_type | VARCHAR(16777216) | Type of strike price (if applicable). |
| floor_strike | FLOAT | Floor strike price for ranged markets. |
| cap_strike | FLOAT | Cap strike price for ranged markets. |
| rules_primary | VARCHAR(16777216) | Primary rules governing the market settlement. |
| rules_secondary | VARCHAR(16777216) | Secondary rules for market settlement. |
| early_close_condition | VARCHAR(16777216) | Conditions under which the market can close early. |
| mve_collection_ticker | VARCHAR(16777216) | Multi-variable event collection ticker. |
| mve_selected_legs | VARCHAR(16777216) | Selected legs for multi-variable events. |
| market_outcome_resolution | VARCHAR(16777216) | Market outcome resolution (or ‘unresolved’ if still open). |
| resolved_at | TIMESTAMP_NTZ(9) | Timestamp when the market was resolved. |
