> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Funding Rates

> Settled funding rates for Kalshi perpetual markets, exchanged every 8 hours.

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

```sql theme={null}
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
```