Open Interest Daily

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.

For platform-specific details, see: Polymarket Open Interest, Polymarket US Open Interest, Kalshi Open Interest.

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

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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query