Skip to main content
The crosschain.predictions.open_interest_daily table provides daily open interest snapshots across Polymarket (Polygon) and Kalshi (API). Categories and statuses are normalized across platforms.
For platform-specific details, see: Polymarket Open Interest, Kalshi Open Interest.

​
Table Columns

Column NameDescription
projectPlatform name (polymarket, kalshi).
protocolProtocol name (polymarket, kalshi).
chainBlockchain. polygon for Polymarket, NULL for Kalshi.
daySnapshot date.
market_unique_idMarket identifier.
event_tickerEvent-level grouping identifier.
market_nameMarket name.
questionThe market question text.
categoryNormalized category in lowercase. Values: politics, crypto, sports, business, technology, international, culture, weather, other.
market_statusNormalized market status. Values: active, closed, settled.
open_interestOpen interest count.
open_interest_usdOpen interest in USD.
unique_idDeterministic 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