Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.dune.com/llms.txt

Use this file to discover all available pages before exploring further.

The kalshi.market_details table is the Kalshi market reference table. Grain: one row per Kalshi ticker. Use it to look up a market’s question, strike type, latest bid/ask, lifecycle status, settlement outcome, and parent event/series metadata.

​
Table Schema

ColumnTypeDescription
tickerVARCHARUnique market identifier (e.g. KXBTCD-26APR04-T99499.99)
event_tickerVARCHARParent event identifier grouping related markets
market_typeVARCHARMarket type (e.g. binary)
titleVARCHARMarket question text
subtitleVARCHARMarket subtitle
yes_sub_titleVARCHARLabel for the Yes outcome
no_sub_titleVARCHARLabel for the No outcome
created_timeTIMESTAMPWhen the market was created
updated_timeTIMESTAMPWhen the market was last updated upstream
open_timeTIMESTAMPWhen trading opened
close_timeTIMESTAMPWhen trading closes
expiration_timeTIMESTAMPMarket expiration time
latest_expiration_timeTIMESTAMPLatest possible expiration time
expected_expiration_timeTIMESTAMPExpected expiration time
settlement_tsTIMESTAMPWhen the market was settled. NULL if unsettled
statusVARCHARMarket lifecycle state (active, finalized, closed, etc.)
resultVARCHARSettlement outcome (yes, no, scalar, or empty if unresolved)
settlement_value_dollarsDOUBLEPayout value per contract at settlement
expiration_valueVARCHARExpiration outcome value
can_close_earlyBOOLEANWhether the market can close before expiration
early_close_conditionVARCHARCondition that triggers early close
yes_bid_dollarsDOUBLELatest best bid for Yes
yes_ask_dollarsDOUBLELatest best ask for Yes
no_bid_dollarsDOUBLELatest best bid for No
no_ask_dollarsDOUBLELatest best ask for No
yes_bid_size_fpDOUBLEDepth at best Yes bid (contracts)
yes_ask_size_fpDOUBLEDepth at best Yes ask (contracts)
last_price_dollarsDOUBLELast traded price
previous_yes_bid_dollarsDOUBLEPrevious best Yes bid
previous_yes_ask_dollarsDOUBLEPrevious best Yes ask
previous_price_dollarsDOUBLEPrevious last traded price
volume_fpDOUBLELifetime contracts traded
volume_24h_fpDOUBLEContracts traded in the last 24 hours
open_interest_fpDOUBLEOpen interest in contracts
strike_typeVARCHARStrike structure (binary, structured, between, greater, custom, etc.)
floor_strikeDOUBLELower bound for range/threshold markets
cap_strikeDOUBLEUpper bound for range markets
custom_strikeVARCHARJSON blob with structured strike metadata
tick_sizeINTEGERMinimum price increment
fractional_trading_enabledBOOLEANWhether fractional contracts are tradeable
rules_primaryVARCHARPrimary resolution rules text
mve_collection_tickerVARCHARMultivariate event collection ticker. NULL for non-MVE markets
series_tickerVARCHARSeries the event belongs to
event_titleVARCHARParent event title
event_sub_titleVARCHARParent event subtitle
collateral_return_typeVARCHARHow collateral is returned
mutually_exclusiveBOOLEANWhether event outcomes are mutually exclusive
available_on_brokersBOOLEANWhether available via broker integrations
product_metadataVARCHARJSON blob with additional product metadata
categoryVARCHARMarket category (e.g. Sports, Politics, Crypto)
competitionVARCHARCompetition name (e.g. Pro Football, NHL, XRP)
strike_dateTIMESTAMPStrike/resolution date
strike_periodVARCHARStrike period description
frequencyVARCHARRecurrence cadence (one_off, annual, monthly, weekly, daily, hourly, etc.)
fee_typeVARCHARFee model (quadratic, quadratic_with_maker_fees)
fee_multiplierDOUBLEFee scalar applied on top of standard rates (1.0 = standard)
source_updated_atTIMESTAMPWhen this market record was last refreshed
_updated_atTIMESTAMPWhen this row was last written by the pipeline

​
Table sample

​
Example query

-- Active sports markets by 24h volume
SELECT
  ticker,
  event_title,
  title,
  volume_24h_fp,
  yes_bid_dollars,
  yes_ask_dollars
FROM kalshi.market_details
WHERE status = 'active'
  AND category = 'Sports'
ORDER BY volume_24h_fp DESC
LIMIT 20