> ## 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 Estimate

> Live forward funding-rate estimates for Kalshi perpetual markets.

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

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