Trades Enriched

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 the trades table plus market metadata

Unique Key: trade_id

Column Name	Data Type	Description
project	VARCHAR	Project identifier, always ‘kalshi’.
protocol	VARCHAR	Protocol identifier, always ‘kalshi’.
trade_date	DATE	Date of the trade (used for partitioning).
created_time	TIMESTAMP_NTZ(9)	Timestamp when the trade was created.
trade_id	VARCHAR	Unique identifier for the trade.
ticker	VARCHAR	Market ticker identifier for this trade.
num_contracts	NUMBER	Number of contracts traded in this trade.
taker_side	VARCHAR	Side taken by the taker (yes or no).
maker_side	VARCHAR	Side taken by the maker (opposite of taker_side).
yes_price	FLOAT	Price for “yes” outcome as a float (0-1 scale).
no_price	FLOAT	Price for “no” outcome as a float (0-1 scale).
taker_price	FLOAT	Price paid by the taker based on taker_side.
market_event_id	VARCHAR	Event identifier for the market.
market_name	VARCHAR	Market name.
market_question	VARCHAR	Market question text.
market_description	VARCHAR	Market description.
market_category	VARCHAR	Market category classification.
market_status	VARCHAR	Current status of the market.
market_start_date	TIMESTAMP_NTZ(9)	Timestamp when the market opened for trading.
market_end_date	TIMESTAMP_NTZ(9)	Timestamp when the market closes for trading.
market_expected_expiration_time	TIMESTAMP_NTZ(9)	Expected timestamp for market expiration.
market_expiration_time	TIMESTAMP_NTZ(9)	Actual expiration timestamp of the market.
market_outcome	VARCHAR	Market outcome resolution.
market_resolved_at	TIMESTAMP_NTZ(9)	Timestamp when the market was resolved.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of the entry creation on Allium’s database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of the entry update on Allium’s database.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns