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

​
Table Columns

Column NameDescription
projectPlatform name (polymarket, kalshi, jupiter).
protocolProtocol name (polymarket, kalshi, jupiter).
chainBlockchain. polygon for Polymarket, solana for Jupiter, NULL for Kalshi.
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 as maker or taker. NULL for Kalshi.
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