Funding Estimate

The common.perpetuals.kalshi_funding_estimate table provides live, forward-looking funding-rate estimates for Kalshi perpetual markets. Each row is a snapshot of the estimated funding rate and mark price for a market, along with the next scheduled funding time. Perps pay funding every 8 hours to keep the contract price aligned with the underlying. A positive funding rate means longs pay shorts; a negative rate means shorts pay longs. Use this table to monitor funding costs and carry.

Table Columns

Data Notes:

This is the live forward estimate for the upcoming funding time, captured as a snapshot.
One row per market per snapshot (snapshot_ts).

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 estimate snapshot.
market_ticker	VARCHAR	Perp market ticker.
snapshot_ts	TIMESTAMP_NTZ(9)	Snapshot timestamp.
funding_rate	FLOAT	Estimated funding rate for the upcoming funding time.
mark_price	FLOAT	Mark price at the time of the estimate (USD).
computed_time	TIMESTAMP_NTZ(9)	Time the estimate was generated by Kalshi.
next_funding_time	TIMESTAMP_NTZ(9)	Next scheduled funding time.
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
  market_ticker,
  snapshot_ts,
  funding_rate,
  mark_price,
  next_funding_time
from common.perpetuals.kalshi_funding_estimate
where partition_date >= current_date - interval '1 day'
qualify row_number() over (partition by market_ticker order by snapshot_ts desc) = 1
order by market_ticker

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