Skip to main content
The crosschain.predictions.metrics_daily table provides daily aggregated metrics across Polymarket, Polymarket US, Kalshi, and Jupiter prediction markets at (day, project, category) granularity. Active users are NULL for Kalshi and Polymarket US (off-chain, no on-chain addresses).

​
Table Columns

Column NameDescription
projectPlatform name (polymarket, kalshi, jupiter, polymarket_us).
protocolProtocol name (polymarket, kalshi, jupiter, polymarket_us).
chainBlockchain. polygon for Polymarket, solana for Jupiter, NULL for Kalshi and Polymarket US.
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 notional volume for the day.
trade_countNumber of trades executed.
avg_trade_size_usdAverage trade size in USD.
total_fee_usdTotal fees collected in USD. NULL for Kalshi.
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 and Polymarket US.
total_open_interest_usdAggregate open interest in USD. NULL for Jupiter.
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.
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