Skip to main content
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 NameData TypeDescription
projectVARCHARProject identifier, always ‘kalshi’.
protocolVARCHARProtocol identifier, always ‘kalshi’.
unique_keyVARCHARUnique identifier for the funding event.
market_tickerVARCHARPerp market ticker.
funding_timeTIMESTAMP_NTZ(9)Funding time the settled rate applies to.
funding_rateFLOATSettled funding rate (positive: longs pay shorts; negative: shorts pay longs).
mark_priceFLOATMark price at the funding time, per contract (USD).
contract_sizeFLOATUnits of the underlying asset represented by one contract.
underlying_mark_priceFLOATMark price of the underlying asset in USD (mark_price / contract_size).
partition_dateDATEEvent date of the funding time (used for partitioning).
ingested_atTIMESTAMP_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