Funding Rates

The common.perpetuals.kalshi_funding_rates table provides settled funding rates for Kalshi perpetual markets. Funding is exchanged every 8 hours to keep the contract price aligned with the underlying. Each row is one settled funding event for a market. A positive funding rate means longs pay shorts; a negative rate means shorts pay longs. Use this table for funding-cost analysis, carry studies, and reconciling realized funding on positions.

Table Columns

Data Notes:

One row per market per funding time (8-hour cadence).
mark_price is per-contract in US dollars; underlying_mark_price is the per-underlying-asset equivalent (mark_price / contract_size).
partition_date is the event date of the funding time.

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 funding event.
market_ticker	VARCHAR	Perp market ticker.
funding_time	TIMESTAMP_NTZ(9)	Funding time the settled rate applies to.
funding_rate	FLOAT	Settled funding rate (positive: longs pay shorts; negative: shorts pay longs).
mark_price	FLOAT	Mark price at the funding time, per contract (USD).
contract_size	FLOAT	Units of the underlying asset represented by one contract.
underlying_mark_price	FLOAT	Mark price of the underlying asset in USD (mark_price / contract_size).
partition_date	DATE	Event date of the funding time (used for partitioning).
ingested_at	TIMESTAMP_NTZ(9)	Timestamp the record was ingested into Allium’s database.

Sample Query

select
  market_ticker,
  funding_time,
  funding_rate,
  mark_price,
  underlying_mark_price
from common.perpetuals.kalshi_funding_rates
where partition_date >= current_date - interval '7 days'
order by funding_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