Markets - Allium Documentation Hub

The common.perpetuals.kalshi_markets table provides periodic snapshots of every Kalshi perpetual market. Each row captures a market’s status, pricing, open interest, volume, mark prices, and leverage at a point in time. Use this table for market discovery, tracking mark and reference prices over time, and analyzing available leverage.

Table Columns

Data Notes:

One row per market per snapshot (snapshot_ts).
price, bid, ask, and the mark prices are per-contract in US dollars. underlying_price is the per-underlying-asset equivalent (price / contract_size).

Unique Key: unique_key

Column Name	Data Type	Description
project	VARCHAR	Project identifier, always ‘kalshi’.
protocol	VARCHAR	Protocol identifier, always ‘kalshi’.
unique_key	VARCHAR	Unique identifier for the market snapshot.
ticker	VARCHAR	Perp market ticker.
snapshot_ts	TIMESTAMP_NTZ(9)	Snapshot timestamp.
status	VARCHAR	Market status (e.g. active).
title	VARCHAR	Human-readable market title.
tick_size	FLOAT	Minimum price increment for the market (USD).
contract_size	FLOAT	Underlying units represented by one contract.
price	FLOAT	Last traded price, per contract (USD).
underlying_price	FLOAT	Price of the underlying asset in USD (price / contract_size).
bid	FLOAT	Best bid price, per contract (USD).
ask	FLOAT	Best ask price (USD).
open_interest	FLOAT	Open interest (contracts).
open_interest_notional_value_dollars	FLOAT	Notional USD value of open interest.
volume	FLOAT	Lifetime traded volume (contracts).
volume_24h	FLOAT	Trailing 24-hour traded volume (contracts).
volume_24h_notional_value_dollars	FLOAT	Notional USD value of trailing 24-hour volume.
volume_notional_value_dollars	FLOAT	Notional USD value of lifetime volume.
reference_price	FLOAT	Reference (index) price for the market (USD).
reference_price_ts	TIMESTAMP_NTZ(9)	Timestamp of the reference price.
settlement_mark_price	FLOAT	Settlement mark price (USD).
settlement_mark_price_ts	TIMESTAMP_NTZ(9)	Timestamp of the settlement mark price.
liquidation_mark_price	FLOAT	Liquidation mark price (USD).
liquidation_mark_price_ts	TIMESTAMP_NTZ(9)	Timestamp of the liquidation mark price.
leverage_estimate	FLOAT	Estimated available leverage for the market.
leverage_estimates	OBJECT	Map of notional size to estimated available leverage.
fractional_trading_enabled	BOOLEAN	Whether fractional contracts are supported.
partition_date	DATE	Snapshot date (used for partitioning).
ingested_at	TIMESTAMP_NTZ(9)	Timestamp the record was ingested into Allium’s database.

Sample Query

select
  ticker,
  snapshot_ts,
  status,
  price,
  open_interest,
  reference_price,
  leverage_estimate
from common.perpetuals.kalshi_markets
where partition_date >= current_date - interval '1 day'
qualify row_number() over (partition by ticker order by snapshot_ts desc) = 1
order by ticker

​Table Columns

​Sample Query

Table Columns

Sample Query