Market Metrics Daily

The crosschain.predictions.market_metrics_daily table has one row per prediction market per day across Polymarket, Polymarket US, Kalshi, Gemini, Jupiter, DFlow, World, and Hyperliquid HIP-4. A row exists for each day a market traded, and for each day it held open interest while still open. Days with open interest and no trades show zero volume and empty prices. Every row carries its event, so grouping by event_ticker gives event totals. Event Metrics Daily has those totals ready-made. For daily totals by category, see Metrics Daily. Set is_aggregator = false for total market volume: Jupiter and DFlow route to Polymarket and Kalshi, so their volume also appears on the venue. Set 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 for parlays (Polymarket combos and Kalshi multivariate events), otherwise single. A combo’s volume stays on the combo.
n_legs	Number of legs in a combo market. NULL for single markets.
event_ticker	Identifier of the event this market belongs to. Every market in an event shares one value.
event_title	Title of the event on its venue. For a single-market event, the market title.
market_unique_id	Identifier of the market: condition id on Polymarket, ticker on Kalshi and Gemini, slug on Polymarket US, market address on World, outcome id on Hyperliquid. Jupiter and DFlow use the underlying venue’s identifier.
market_title	Title of the market on its venue. For combos, the parlay description.
category	Normalized category in lowercase: politics, crypto, sports, business, technology, international, culture, weather, or other.
market_start_date	When the market opens. UTC.
market_end_date	When the market closes. UTC.
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. For Jupiter and DFlow, the count on the underlying venue.
market_status	Current status of the market, for example active, closed, or settled.
resolution_outcome	How the market resolved: yes when the first outcome won, no when the second won, 50/50 for a Polymarket split, scalar for a Kalshi scalar market. Empty while the market is open.
is_resolved	True once the market has resolved.
trading_volume_usd	Total USD value traded on this day. 0 on days with open interest and no trades.
notional_volume	Shares or contracts traded on this day. Outcome shares for Polymarket, contracts for every other venue.
trade_count	Number of trades on this day. 0 on days with open interest and no trades.
median_trade_size_usd	Median trade size in USD. Empty on days with no trades.
open_yes_price	Price of the first outcome (Yes on yes/no markets) at the day’s first trade, on a 0-1 scale. Empty on days with no trades.
high_yes_price	Highest first-outcome price traded on this day, on a 0-1 scale.
low_yes_price	Lowest first-outcome price traded on this day, on a 0-1 scale.
close_yes_price	First-outcome price at the day’s last trade, on a 0-1 scale.
vwap_yes_price	Volume-weighted average first-outcome price on this day, on a 0-1 scale.
last_traded_yes_price	First-outcome closing price on the market’s most recent trading day. For a resolved market, the last traded price before resolution.
open_interest_usd	Open interest in USD at the end of the day. Polymarket is valued at outcome token prices; Kalshi and Polymarket US at 1 USD per contract. NULL for Gemini, Jupiter, DFlow, World, and Hyperliquid.
fee_usd	Net trading fee in USD, after maker rebates. For Kalshi, the published trade fee rounded up to $0.0001 per side. NULL for Gemini.
gross_fee_usd	Trading fee charged to the taker before any rebate. The same as fee_usd on venues without rebates. NULL for Gemini.
rebate_fee_usd	Maker rebate in USD. Polymarket V1 markets only. NULL everywhere else.
yes_volume_usd	USD where the taker bought the first outcome or sold the second. NULL for Polymarket US, whose trades have no side.
no_volume_usd	USD where the taker bought the second outcome or sold the first. With yes_volume_usd it can total less than trading_volume_usd, because some trades have no side.
net_yes_volume_usd	How far taker volume leaned toward the first outcome. Positive means more taker volume on the first outcome than the second.
first_trade_date	Date of the market’s first trade.
last_trade_date	Date of the market’s most recent trade.
unique_id	Deterministic unique key for the row.

Sample Query

SELECT
    project,
    market_unique_id,
    market_title,
    category,
    trading_volume_usd,
    close_yes_price,
    open_interest_usd
FROM crosschain.predictions.market_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