Skip to main content
The kalshi.market_details table has one row per Kalshi market, unique on market_id (Kalshi’s ticker). It covers every single market Kalshi has listed, traded or not, plus every parlay that has traded at least once. Use it to look up a market’s question, strikes, status, result and payout, resolution rules, parlay legs, and its event and series, including fee terms. The table has no prices or volume. Those are in kalshi.ohlcv_hourly and kalshi.market_trades, which join on market_id. A single market that never traded has no trades or candles. Compared with v1, source_updated_at and updated_time are removed. _updated_at now changes only when a row’s values change. created_date is new and is the partition column.
status comes from Kalshi’s market status updates. Where those are missing, it uses the latest market data and the open and close times. settlement_value_usd is the source of truth for settlement: if a yes/no result disagrees with the payout, result is corrected to match.

Table Schema

Table sample

Query performance

market_details is partitioned by created_date, the UTC date the market was created. Filter on created_date when you only need recently listed markets. Lookups by market_id, status or settlement time still work, but they read the whole table.

Example queries

Single markets settled in the last 7 days, by category and result:
Active sports markets by 7-day USD volume:

Previous version

Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.