Skip to main content
The common.predictions.kalshi_trades_enriched table provides enhanced trade data with comprehensive market metadata, categorization, event information, and settlement outcomes. This table extends the basic trades data with rich context about markets, questions, and resolution outcomes. Use this table for advanced analytics, market research, category analysis, and outcome tracking across Kalshi prediction markets.

​
Table Columns

Data Precision Notes:
  • Prices are stored as floats on a 0-1 scale (e.g., 0.65 = $0.65)
  • Each contract is worth $1 at settlement
  • Includes all columns from base trades table plus market enrichment data
Unique Key: trade_id
Column NameData TypeDescription
projectVARCHARProject identifier, always ‘kalshi’.
protocolVARCHARProtocol identifier, always ‘kalshi’.
trade_dateDATEDate of the trade (used for partitioning).
created_timeTIMESTAMP_NTZ(9)Timestamp when the trade was created.
trade_idVARCHARUnique identifier for the trade.
tickerVARCHARMarket ticker identifier for this trade.
num_contractsNUMBERNumber of contracts traded in this trade.
taker_sideVARCHARSide taken by the taker (yes or no).
maker_sideVARCHARSide taken by the maker (opposite of taker_side).
yes_priceFLOATPrice for “yes” outcome as a float (0-1 scale).
no_priceFLOATPrice for “no” outcome as a float (0-1 scale).
taker_priceFLOATPrice paid by the taker based on taker_side.
market_event_idVARCHAREvent identifier for the market (from markets table).
market_nameVARCHARMarket name (from markets table).
market_questionVARCHARMarket question text (from markets table).
market_descriptionVARCHARMarket description (from markets table).
market_categoryVARCHARMarket category classification (from markets table).
market_statusVARCHARCurrent status of the market (from markets table).
market_start_dateTIMESTAMP_NTZ(9)Timestamp when the market opened for trading (from markets table).
market_end_dateTIMESTAMP_NTZ(9)Timestamp when the market closes for trading (from markets table).
market_expected_expiration_timeTIMESTAMP_NTZ(9)Expected timestamp for market expiration (from markets table).
market_expiration_timeTIMESTAMP_NTZ(9)Actual expiration timestamp of the market (from markets table).
market_outcomeVARCHARMarket outcome resolution (from markets table).
market_resolved_atTIMESTAMP_NTZ(9)Timestamp when the market was resolved (from markets table).
_created_atTIMESTAMP_NTZ(9)Timestamp of the entry creation on Allium’s database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of the entry update on Allium’s database.