Event Metrics Daily

The crosschain.predictions.event_metrics_daily table has one row per prediction-market event per day across Polymarket, Polymarket US, Kalshi, Gemini, Jupiter, DFlow, World, and Hyperliquid HIP-4. Volume, trade count, open interest, fees, and yes/no volume are the totals of the event’s markets that day. Prices and resolution are per market, in Market Metrics Daily. For daily totals by category, see Metrics Daily. Set is_aggregator = false for total market volume, and market_type = 'single' to leave out parlays.

Table Columns

Column Name	Description
day	Date the row covers.
project	Venue: polymarket, polymarket_us, kalshi, gemini, jupiter, dflow, world, or hyperliquid.
protocol	Protocol behind the row. Jupiter rows are polymarket or kalshi depending on the market they route to; DFlow rows are kalshi; Hyperliquid rows are hyperliquid_hip4.
chain	Blockchain: polygon for Polymarket, solana for Jupiter, DFlow, and World, hyperliquid for Hyperliquid HIP-4. NULL for Kalshi, Polymarket US, and Gemini.
is_aggregator	True for Jupiter and DFlow. Filter to false for total market volume.
market_type	combo when the event’s markets are parlays, otherwise single.
event_ticker	Identifier of the event.
event_title	Title of the event on its venue.
category	Most common category among the event’s markets that day, in lowercase: politics, crypto, sports, business, technology, international, culture, weather, or other.
event_start_date	Earliest start across the event’s markets. UTC.
event_end_date	Latest end across the event’s markets. UTC.
markets_in_event	Number of markets the venue lists for the event, traded or not.
markets_traded	Number of the event’s markets with at least one trade on this day.
markets_with_oi	Number of the event’s markets with open interest on this day.
trading_volume_usd	Total USD value traded across the event’s markets on this day.
notional_volume	Shares or contracts traded across the event’s markets on this day. Outcome shares for Polymarket, contracts for every other venue.
trade_count	Number of trades across the event’s markets on this day.
open_interest_usd	Open interest in USD across the event’s markets at the end of the day. NULL where no venue in the event reports it.
fee_usd	Net trading fee in USD across the event’s markets, after maker rebates. NULL for Gemini.
gross_fee_usd	Trading fee charged to takers before any rebate, across the event’s markets. NULL for Gemini.
rebate_fee_usd	Maker rebates in USD across the event’s markets. Polymarket V1 markets only.
yes_volume_usd	USD where the taker bought a market’s first outcome or sold the second, across the event. NULL for Polymarket US.
no_volume_usd	USD where the taker bought a market’s second outcome or sold the first, across the event.
net_yes_volume_usd	How far taker volume leaned toward first outcomes across the event. Positive means more taker volume on first outcomes than second outcomes.
first_trade_date	Date of the event’s first trade.
last_trade_date	Date of the event’s most recent trade.
unique_id	Deterministic unique key for the row.

Sample Query

SELECT
    project,
    event_ticker,
    event_title,
    category,
    markets_traded,
    trading_volume_usd,
    open_interest_usd
FROM crosschain.predictions.event_metrics_daily
WHERE day >= CURRENT_DATE - 7
  AND is_aggregator = false
ORDER BY 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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

​Table Columns

​Sample Query

Table Columns

Sample Query