Trades

The common.perpetuals.kalshi_trades table provides individual trade data from Kalshi perpetual markets. Each row represents a single trade with its market ticker, contract count, price, and taker side. Use this table to analyze trading volume, price discovery, and order flow across Kalshi perps.

Table Columns

Data Notes:

price is per-contract in US dollars. A contract represents contract_size units of the underlying asset.
underlying_price is the per-underlying-asset price (price / contract_size), e.g. a BTC perp price of 6.45 with contract_size 0.0001 is an underlying_price of $64,500.
partition_date is the event date of the trade (date of created_time).

Unique Key: trade_id

Column Name	Data Type	Description
project	VARCHAR	Project identifier, always ‘kalshi’.
protocol	VARCHAR	Protocol identifier, always ‘kalshi’.
unique_key	VARCHAR	Unique identifier for the trade (equal to trade_id).
trade_id	VARCHAR	Unique identifier for the trade.
ticker	VARCHAR	Perp market ticker for this trade.
created_time	TIMESTAMP_NTZ(9)	Timestamp when the trade occurred.
num_contracts	NUMBER(38,2)	Number of contracts traded.
price	FLOAT	Trade price in US dollars, per contract.
contract_size	FLOAT	Units of the underlying asset represented by one contract.
underlying_price	FLOAT	Price of the underlying asset in US dollars (price / contract_size).
taker_side	VARCHAR	Side taken by the taker.
partition_date	DATE	Event date of the trade (used for partitioning).
ingested_at	TIMESTAMP_NTZ(9)	Timestamp the record was ingested into Allium’s database.

Sample Query

select
  trade_id,
  ticker,
  created_time,
  num_contracts,
  price,
  contract_size,
  underlying_price,
  taker_side
from common.perpetuals.kalshi_trades
where partition_date >= current_date - interval '7 days'
order by created_time desc
limit 100

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query