Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Daily open interest across Polymarket, Polymarket US, and Kalshi prediction markets.
crosschain.predictions.open_interest_daily table provides daily open interest snapshots across Polymarket (Polygon), Polymarket US, and Kalshi. Gemini is not included in this table yet. Categories and statuses use a shared normalized taxonomy across platforms.
| 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. |
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
Was this page helpful?