Skip to main content

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.

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 NameDescription
projectPlatform name (polymarket, kalshi, polymarket_us).
protocolProtocol name (polymarket, kalshi, polymarket_us).
chainBlockchain. polygon for Polymarket, NULL for Kalshi and Polymarket US.
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