> ## 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.

# Event Metrics Daily

> Daily volume, open interest, and fees for each prediction-market event.

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

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