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

# Markets

> Per-market snapshots of Kalshi perpetual markets, including pricing, open interest, mark prices, and leverage.

The `common.perpetuals.kalshi_markets` table provides periodic snapshots of every Kalshi perpetual market. Each row captures a market's status, pricing, open interest, volume, mark prices, and leverage at a point in time.

Use this table for market discovery, tracking mark and reference prices over time, and analyzing available leverage.

### Table Columns

**Data Notes:**

* One row per market per snapshot (`snapshot_ts`).
* `price`, `bid`, `ask`, and the mark prices are per-contract in US dollars. `underlying_price` is the per-underlying-asset equivalent (`price / contract_size`).

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 market snapshot.                     |
| ticker                                   | VARCHAR           | Perp market ticker.                                            |
| snapshot\_ts                             | TIMESTAMP\_NTZ(9) | Snapshot timestamp.                                            |
| status                                   | VARCHAR           | Market status (e.g. active).                                   |
| title                                    | VARCHAR           | Human-readable market title.                                   |
| tick\_size                               | FLOAT             | Minimum price increment for the market (USD).                  |
| contract\_size                           | FLOAT             | Underlying units represented by one contract.                  |
| price                                    | FLOAT             | Last traded price, per contract (USD).                         |
| underlying\_price                        | FLOAT             | Price of the underlying asset in USD (price / contract\_size). |
| bid                                      | FLOAT             | Best bid price, per contract (USD).                            |
| ask                                      | FLOAT             | Best ask price (USD).                                          |
| open\_interest                           | FLOAT             | Open interest (contracts).                                     |
| open\_interest\_notional\_value\_dollars | FLOAT             | Notional USD value of open interest.                           |
| volume                                   | FLOAT             | Lifetime traded volume (contracts).                            |
| volume\_24h                              | FLOAT             | Trailing 24-hour traded volume (contracts).                    |
| volume\_24h\_notional\_value\_dollars    | FLOAT             | Notional USD value of trailing 24-hour volume.                 |
| volume\_notional\_value\_dollars         | FLOAT             | Notional USD value of lifetime volume.                         |
| reference\_price                         | FLOAT             | Reference (index) price for the market (USD).                  |
| reference\_price\_ts                     | TIMESTAMP\_NTZ(9) | Timestamp of the reference price.                              |
| settlement\_mark\_price                  | FLOAT             | Settlement mark price (USD).                                   |
| settlement\_mark\_price\_ts              | TIMESTAMP\_NTZ(9) | Timestamp of the settlement mark price.                        |
| liquidation\_mark\_price                 | FLOAT             | Liquidation mark price (USD).                                  |
| liquidation\_mark\_price\_ts             | TIMESTAMP\_NTZ(9) | Timestamp of the liquidation mark price.                       |
| leverage\_estimate                       | FLOAT             | Estimated available leverage for the market.                   |
| leverage\_estimates                      | OBJECT            | Map of notional size to estimated available leverage.          |
| fractional\_trading\_enabled             | BOOLEAN           | Whether fractional contracts are supported.                    |
| 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
  ticker,
  snapshot_ts,
  status,
  price,
  open_interest,
  reference_price,
  leverage_estimate
from common.perpetuals.kalshi_markets
where partition_date >= current_date - interval '1 day'
qualify row_number() over (partition by ticker order by snapshot_ts desc) = 1
order by ticker
```