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

# Open Interest Daily

> Daily open interest across Polymarket, Polymarket US, and Kalshi prediction markets.

The `crosschain.predictions.open_interest_daily` table provides daily open interest snapshots across Polymarket (Polygon), Polymarket US, and Kalshi (API). Gemini is not included in this table yet. Categories and statuses use a shared normalized taxonomy across platforms.

<Info>
  For platform-specific details, see:
  [Polymarket Open Interest](/historical-data/supported-blockchains/evm/polygon/predictions/open-interest-daily),
  [Polymarket US Open Interest](/historical-data/predictions/polymarket-us/open-interest-daily),
  [Kalshi Open Interest](/historical-data/predictions/kalshi/open-interest-daily).
</Info>

## Table Columns

| Column Name         | Description                                                                                                                       |
| ------------------- | --------------------------------------------------------------------------------------------------------------------------------- |
| project             | Platform name (polymarket, kalshi, polymarket\_us).                                                                               |
| protocol            | Protocol name (polymarket, kalshi, polymarket\_us).                                                                               |
| chain               | Blockchain. polygon for Polymarket, NULL for Kalshi and Polymarket US.                                                            |
| day                 | Snapshot date.                                                                                                                    |
| market\_unique\_id  | Market identifier.                                                                                                                |
| event\_ticker       | Event-level grouping identifier.                                                                                                  |
| market\_name        | Market name.                                                                                                                      |
| question            | The market question text.                                                                                                         |
| category            | Normalized category in lowercase. Values: politics, crypto, sports, business, technology, international, culture, weather, other. |
| market\_status      | Normalized market status. Values: active, closed, settled.                                                                        |
| open\_interest      | Open interest count.                                                                                                              |
| open\_interest\_usd | Open interest in USD.                                                                                                             |
| unique\_id          | Deterministic unique key.                                                                                                         |

## Sample Query

```sql theme={null}
SELECT
    project,
    day,
    category,
    SUM(open_interest_usd) AS total_oi_usd,
    COUNT(DISTINCT market_unique_id) AS markets
FROM crosschain.predictions.open_interest_daily
WHERE day >= CURRENT_DATE - 30
  AND market_status = 'active'
GROUP BY project, day, category
ORDER BY day DESC, total_oi_usd DESC
LIMIT 100
```