Maintained by: Dune (partner data) · Refresh: ~1 hour · Source: Off-chain (Kalshi)
Available Tables
kalshi.market_details
One row per market with lifecycle status, settlement, strike structure, rules, parlay legs, and event and series metadata
kalshi.market_trades
Per-fill trade activity with P(Yes), USD notional, and estimated taker and maker fees
kalshi.ohlcv_hourly
Hourly OHLCV candles with VWAP, volume, and trade count
kalshi.open_interest_hourly
Hourly open interest and traded volume per single market
kalshi.market_report
Legacy daily market-level reporting
kalshi.trade_report
Legacy daily aggregated trade reporting (not individual fills)
Notes
market_details,market_trades,ohlcv_hourly, andopen_interest_hourlyare the current Kalshi tables.market_reportandtrade_reportare legacy daily-aggregated tables kept for historical continuity.market_idis Kalshi’s ticker and is the join key across the current tables.event_idandseries_idare Kalshi’s event and series tickers.market_detailscovers every single market Kalshi has listed, traded or not, plus every parlay with at least one fill.market_tradesandohlcv_hourlyonly cover markets that have traded, so an untraded market has a details row but no trades or candles.market_tradescarries no market metadata; joinmarket_detailsonmarket_idfor the title, status, result and fee terms.trade_reportaggregates by date and price level, so a single(date, ticker)can produce multiple rows.