common.predictions.kalshi_open_interest_daily table provides daily end-of-day snapshots of open interest for each Kalshi prediction market, enriched with comprehensive market metadata. Each row represents one market on one day with the closing price and total outstanding contracts.
Use this table for market liquidity analysis, total value locked tracking, market size comparisons, and understanding long-term position trends.
Table Columns
Data Notes:- One row per (day, market_ticker) combination
- Open interest represents outstanding contracts at end of day
- Each contract is worth $1 at settlement
- Includes comprehensive market metadata for filtering and analysis
unique_id
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | Project identifier, always ‘kalshi’. |
| protocol | VARCHAR | Protocol identifier, always ‘kalshi’. |
| day | DATE | Date of the open interest snapshot. |
| market_unique_id | VARCHAR | Unique identifier for the Kalshi market ticker. |
| market_event_id | VARCHAR | Event identifier for the market. |
| market_series_id | VARCHAR | Series ticker identifier for the event. |
| market_mve_id | VARCHAR | Multi-variable event (MVE) collection ticker. |
| market_name | VARCHAR | Market name. |
| question_id | VARCHAR | Question identifier. |
| question | VARCHAR | Question text. |
| description | VARCHAR | Market description. |
| category | VARCHAR | Market category classification. |
| market_status | VARCHAR | Current status of the market. |
| market_active | BOOLEAN | Boolean flag indicating if the market is active. |
| market_closed | BOOLEAN | Boolean flag indicating if the market is closed. |
| market_accepting_orders | BOOLEAN | Boolean flag indicating if the market is accepting orders. |
| 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_resolution | VARCHAR | Market outcome resolution. |
| market_resolved_at | TIMESTAMP_NTZ(9) | Timestamp when the market was resolved. |
| open_interest | FLOAT | End-of-day open interest in contracts (1 contract = $1). |
| close_price | FLOAT | End-of-day closing price (0-1 scale). |
| unique_id | VARCHAR | Unique identifier combining day and market_unique_id. |
Understanding Open Interest
What is Open Interest?
Open interest represents the total number of outstanding contracts in a market at the end of the day. Since each Kalshi contract is worth $1 at settlement:open_interest = 10,000means 10,000 contracts worth $10,000 total are outstanding- This represents the total amount at stake in the market
Open Interest vs Volume
- Open Interest: Total outstanding contracts (stock analogy: shares outstanding)
- Volume: Contracts traded during a period (stock analogy: daily trading volume or daily notional volume)
- High open interest indicates significant market participation
- Low open interest suggests limited liquidity or interest