Skip to main content
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 NameData TypeDescription
projectVARCHARProject identifier, always ‘kalshi’.
protocolVARCHARProtocol identifier, always ‘kalshi’.
unique_keyVARCHARUnique identifier for the funding estimate snapshot.
market_tickerVARCHARPerp market ticker.
snapshot_tsTIMESTAMP_NTZ(9)Snapshot timestamp.
funding_rateFLOATEstimated funding rate for the upcoming funding time.
mark_priceFLOATMark price at the time of the estimate (USD).
computed_timeTIMESTAMP_NTZ(9)Time the estimate was generated by Kalshi.
next_funding_timeTIMESTAMP_NTZ(9)Next scheduled funding time.
partition_dateDATESnapshot date (used for partitioning).
ingested_atTIMESTAMP_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