Skip to main content
The 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 Key: unique_id
Column NameData TypeDescription
projectVARCHARProject identifier, always ‘kalshi’.
protocolVARCHARProtocol identifier, always ‘kalshi’.
dayDATEDate of the open interest snapshot.
market_unique_idVARCHARUnique identifier for the Kalshi market ticker.
market_event_idVARCHAREvent identifier for the market.
market_series_idVARCHARSeries ticker identifier for the event.
market_mve_idVARCHARMulti-variable event (MVE) collection ticker.
market_nameVARCHARMarket name.
question_idVARCHARQuestion identifier.
questionVARCHARQuestion text.
descriptionVARCHARMarket description.
categoryVARCHARMarket category classification.
market_statusVARCHARCurrent status of the market.
market_activeBOOLEANBoolean flag indicating if the market is active.
market_closedBOOLEANBoolean flag indicating if the market is closed.
market_accepting_ordersBOOLEANBoolean flag indicating if the market is accepting orders.
market_start_dateTIMESTAMP_NTZ(9)Timestamp when the market opened for trading.
market_end_dateTIMESTAMP_NTZ(9)Timestamp when the market closes for trading.
market_expected_expiration_timeTIMESTAMP_NTZ(9)Expected timestamp for market expiration.
market_expiration_timeTIMESTAMP_NTZ(9)Actual expiration timestamp of the market.
market_outcome_resolutionVARCHARMarket outcome resolution.
market_resolved_atTIMESTAMP_NTZ(9)Timestamp when the market was resolved.
open_interestFLOATEnd-of-day open interest in contracts (1 contract = $1).
close_priceFLOATEnd-of-day closing price (0-1 scale).
unique_idVARCHARUnique 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,000 means 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