Kalshi Markets
Series, events, markets, and trades
@kalshi.markets
Series, events, markets, and trades
@kalshi.markets
Kalshi prediction-market content modeled in three layers:
Series – a theme that groups related questions.
Event – a specific question template within a series (often adds time/scope).
Market – a tradable contract that targets one outcome/subject under an event.
| Series | Event | Market (example) |
|---|---|---|
| Best Actor in a Motion Picture – Musical or Comedy | Golden Globe nominations for Best Actor (that category) | Will Leonardo DiCaprio be on the list of nominees at the 83rd Golden Globes? |
| Best Television Series – Drama | Golden Globe nominations for Best TV Series – Drama | Will The Last of Us be on the list of nominees at the 83rd Golden Globes? |
| #1 most searched on Google | #1 Searched Person on Google in 2025 | Will Bianca Censori be ranked #1 (Global – People)? |
| ATP Tennis Match | Djokovic vs Borges | Will Novak Djokovic win the Djokovic vs Borges match? |
Tables included
series — one row per series (theme).events — one row per event, linked to its series.markets — one row per tradable market with identifiers, status, timing, pricing and liquidity fields.market_trades — executed trades (“ticks”) per market.All timestamps are UTC. Fields with the suffix “_dollars” are USD-denominated counterparts when provided by the source.
CREATE TABLE events (
"event_ticker" VARCHAR,
"series_ticker" VARCHAR,
"sub_title" VARCHAR,
"title" VARCHAR,
"collateral_return_type" VARCHAR,
"mutually_exclusive" BOOLEAN,
"category" VARCHAR,
"strike_date" TIMESTAMP,
"strike_period" VARCHAR,
"available_on_brokers" BOOLEAN,
"product_metadata" VARCHAR
);CREATE TABLE markets (
"ticker" VARCHAR,
"event_ticker" VARCHAR,
"series_ticker" VARCHAR,
"market_type" VARCHAR,
"title" VARCHAR,
"subtitle" VARCHAR,
"yes_sub_title" VARCHAR,
"no_sub_title" VARCHAR,
"open_time" VARCHAR,
"close_time" VARCHAR,
"expected_expiration_time" VARCHAR,
"expiration_time" VARCHAR,
"latest_expiration_time" VARCHAR,
"fee_waiver_expiration_time" VARCHAR,
"settlement_timer_seconds" VARCHAR,
"status" VARCHAR,
"response_price_units" VARCHAR,
"yes_bid" VARCHAR,
"yes_bid_dollars" VARCHAR,
"yes_ask" VARCHAR,
"yes_ask_dollars" VARCHAR,
"no_bid" VARCHAR,
"no_bid_dollars" VARCHAR,
"no_ask" VARCHAR,
"no_ask_dollars" VARCHAR,
"last_price" VARCHAR,
"last_price_dollars" VARCHAR,
"volume" VARCHAR,
"volume_24h" VARCHAR,
"open_interest" VARCHAR,
"liquidity" VARCHAR,
"liquidity_dollars" VARCHAR,
"result" VARCHAR,
"can_close_early" VARCHAR,
"notional_value" VARCHAR,
"notional_value_dollars" VARCHAR,
"settlement_value" VARCHAR,
"settlement_value_dollars" VARCHAR,
"expiration_value" VARCHAR,
"previous_yes_bid" VARCHAR,
"previous_yes_bid_dollars" VARCHAR,
"previous_yes_ask" VARCHAR,
"previous_yes_ask_dollars" VARCHAR,
"previous_price" VARCHAR,
"previous_price_dollars" VARCHAR,
"risk_limit_cents" VARCHAR,
"early_close_condition" VARCHAR,
"tick_size" VARCHAR,
"strike_type" VARCHAR,
"floor_strike" VARCHAR,
"cap_strike" VARCHAR,
"custom_strike" VARCHAR,
"rules_primary" VARCHAR,
"rules_secondary" VARCHAR,
"mve_collection_ticker" VARCHAR,
"mve_selected_legs" VARCHAR,
"mve_selected_legs_count" VARCHAR,
"primary_participant_key" VARCHAR,
"price_level_structure" VARCHAR,
"price_ranges" VARCHAR
);CREATE TABLE market_trades (
"trade_id" VARCHAR,
"market_ticker" VARCHAR,
"price" VARCHAR,
"count" VARCHAR,
"yes_price" VARCHAR,
"no_price" VARCHAR,
"yes_price_dollars" VARCHAR,
"no_price_dollars" VARCHAR,
"taker_side" VARCHAR,
"created_time" VARCHAR
);CREATE TABLE series (
"series_ticker" VARCHAR,
"frequency" VARCHAR,
"title" VARCHAR,
"category" VARCHAR,
"tags" VARCHAR,
"settlement_sources" VARCHAR,
"contract_url" VARCHAR,
"contract_terms_url" VARCHAR,
"fee_type" VARCHAR,
"fee_multiplier" DOUBLE,
"additional_prohibitions" VARCHAR
);Anyone who has the link will be able to view this.