> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Market Metrics Daily

> Daily volume, prices, open interest, fees, and resolution for each prediction market.

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](/historical-data/predictions/crosschain/event-metrics-daily) has those totals ready-made. For daily totals by category, see [Metrics Daily](/historical-data/predictions/crosschain/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

```sql theme={null}
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
```