Metrics Daily

The crosschain.predictions.metrics_daily table provides daily metrics across Polymarket, Polymarket US, Kalshi, Gemini, and Solana venues (Jupiter, DFlow, World) 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, DFlow, World, and Gemini.

Table Columns

Column Name	Description
project	Platform name (polymarket, kalshi, jupiter, dflow, world, polymarket_us, gemini).
protocol	Protocol name (polymarket, kalshi, world, polymarket_us, gemini). Jupiter rows may show kalshi or polymarket depending on the market; DFlow rows show kalshi; World rows show world.
chain	Blockchain. polygon for Polymarket, solana for Jupiter, DFlow, and World, NULL for Kalshi, Polymarket US, and Gemini.
day	The date for these metrics.
category	Normalized category in lowercase. Values: politics, crypto, sports, business, technology, international, culture, weather, other.
trading_volume_usd	Total USD trading volume for the day.
notional_volume	Total contract or share count traded for the day (sum of num_shares).
trade_count	Number of trades executed.
avg_trade_size_usd	Average trade size in USD.
total_fee_usd	Net fees collected in USD, after maker rebates. NULL for Kalshi and Gemini.
gross_fee_usd	Trading fees charged to takers, before any rebate. Equals total_fee_usd for venues without rebates (Polymarket US, Jupiter, DFlow, World). NULL for Kalshi and Gemini.
rebate_fee_usd	Maker rebates in USD. Polymarket V1 markets only. NULL for all other venues.
markets_traded	Count of distinct events/questions with at least one trade on this day.
median_trade_size_usd	Median trade size in USD.
active_users	Count of distinct on-chain addresses that participated. NULL for Kalshi, Gemini, and Polymarket US.
total_open_interest_usd	Aggregate open interest in USD. NULL for Jupiter, DFlow, World, and Gemini.
markets_with_oi	Count of distinct events/questions with non-zero open interest on this day.
cumulative_trading_volume_usd	Cumulative trading volume in USD.
cumulative_notional_volume	Cumulative notional volume.
cumulative_trade_count	Cumulative trade count.
cumulative_total_fee_usd	Cumulative NET fees in USD.
cumulative_gross_fee_usd	Cumulative gross (pre-rebate) fees in USD.
cumulative_rebate_fee_usd	Cumulative maker rebates in USD.
unique_id	Deterministic 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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query