> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Markets

> Kalshi prediction markets metadata including market details, pricing, and settlement information.

The `common.predictions.kalshi_markets` table provides comprehensive metadata for Kalshi prediction markets including market details, pricing, settlement rules, and resolution outcomes. This table combines both settled and non-settled markets.

Use this table to discover markets, analyze settlement patterns, understand market structure, and track outcomes across different categories.

### Table Columns

Unique Key: `market_unique_id`

| Column Name                 | Data Type         | Description                                                        |
| --------------------------- | ----------------- | ------------------------------------------------------------------ |
| project                     | VARCHAR           | Project identifier, always 'kalshi'.                               |
| protocol                    | VARCHAR           | Protocol identifier, always 'kalshi'.                              |
| market\_unique\_id          | VARCHAR           | Unique identifier for the Kalshi market ticker.                    |
| market\_event\_id           | VARCHAR           | Event identifier that groups related markets together.             |
| market\_series\_id          | VARCHAR           | Series ticker identifier for the event.                            |
| market\_mve\_id             | VARCHAR           | Multi-variable event (MVE) collection ticker.                      |
| market\_name                | VARCHAR           | Market title describing the prediction question.                   |
| question\_id                | VARCHAR           | Question identifier.                                               |
| question                    | VARCHAR           | Question text from the event.                                      |
| description                 | VARCHAR           | Market description.                                                |
| last\_token\_price          | FLOAT             | Last traded price as a float (0-1 scale).                          |
| market\_status              | VARCHAR           | 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           | 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              | NUMBER            | Settlement timer in seconds.                                       |
| can\_close\_early           | BOOLEAN           | Boolean flag indicating if the market can close before expiration. |
| expiration\_value           | VARCHAR           | Value used to determine market settlement.                         |
| strike\_type                | VARCHAR           | 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           | Primary rules governing the market settlement.                     |
| rules\_secondary            | VARCHAR           | Secondary rules for market settlement.                             |
| early\_close\_condition     | VARCHAR           | Conditions under which the market can close early.                 |
| mve\_collection\_ticker     | VARCHAR           | Multi-variable event collection ticker.                            |
| mve\_selected\_legs         | VARCHAR           | Selected legs for multi-variable events.                           |
| market\_outcome\_resolution | VARCHAR           | Market outcome resolution (or 'unresolved' if still open).         |
| resolved\_at                | TIMESTAMP\_NTZ(9) | Timestamp when the market was resolved (expiration\_time).         |

***

### Understanding Market Structure

#### Market Status Flow

Markets progress through different statuses:

1. **active/open**: Market is accepting trades
2. **closed**: Market has stopped accepting new orders
3. **finalized**: Market is awaiting settlement
4. **settled**: Market outcome has been determined and market is settled

#### Multi-Variable Events (MVE)

MVE markets group multiple related prediction markets and conditions together into one. For example:

* "Which NBA Player will score 20+ pts today?" might have markets for:
  * Yes. Stephen Curry
  * Yes. Lebron James
  * Yes. Kevin Durant

All these related markets share the same `market_mve_id`.