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.metrics_daily table provides daily metrics across Polymarket, Polymarket US, Kalshi, Gemini, and Jupiter prediction markets at (day, project, category) granularity. Active users are NULL for Kalshi, Gemini, and Polymarket US (off-chain, no on-chain addresses). Open interest is NULL for Jupiter and Gemini.

​
Table Columns

Column NameDescription
projectPlatform name (polymarket, kalshi, jupiter, polymarket_us, gemini).
protocolProtocol name (polymarket, kalshi, jupiter, polymarket_us, gemini).
chainBlockchain. polygon for Polymarket, solana for Jupiter, NULL for Kalshi, Polymarket US, and Gemini.
dayThe date for these metrics.
categoryNormalized category in lowercase. Values: politics, crypto, sports, business, technology, international, culture, weather, other.
trading_volume_usdTotal USD trading volume for the day.
notional_volumeTotal contract or share count traded for the day (sum of num_shares).
trade_countNumber of trades executed.
avg_trade_size_usdAverage trade size in USD.
total_fee_usdNET fees collected in USD (gross charged minus on-chain rebate). NULL for Kalshi and Gemini.
gross_fee_usdPre-rebate fees charged to takers. For Polymarket V1, populated from on-chain FeeCharged events. Equals total_fee_usd for Polymarket US, Jupiter, and DFlow (no on-chain rebate). NULL for Kalshi and Gemini.
rebate_fee_usdMaker rebates paid back on-chain (Polymarket V1 only). V2 Polymarket batches rebates off-event (not captured here). NULL for Polymarket US, Jupiter, DFlow, Kalshi, and Gemini.
markets_tradedCount of distinct events/questions with at least one trade on this day.
median_trade_size_usdMedian trade size in USD.
active_usersCount of distinct on-chain addresses that participated. NULL for Kalshi, Gemini, and Polymarket US.
total_open_interest_usdAggregate open interest in USD. NULL for Jupiter and Gemini.
markets_with_oiCount of distinct events/questions with non-zero open interest on this day.
cumulative_trading_volume_usdCumulative trading volume in USD.
cumulative_notional_volumeCumulative notional volume.
cumulative_trade_countCumulative trade count.
cumulative_total_fee_usdCumulative NET fees in USD.
cumulative_gross_fee_usdCumulative gross (pre-rebate) fees in USD.
cumulative_rebate_fee_usdCumulative maker rebates in USD.
unique_idDeterministic unique key.

​
Sample Query

SELECT
    project,
    day,
    category,
    trading_volume_usd,
    trade_count,
    active_users,
    total_open_interest_usd
FROM crosschain.predictions.metrics_daily
WHERE day >= CURRENT_DATE - 30
ORDER BY day DESC, trading_volume_usd DESC
LIMIT 100