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

# Metrics Daily

> Daily aggregated metrics across Polymarket, Polymarket US, Kalshi, Gemini, and Solana venues (Jupiter, DFlow, World).

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. For Kalshi this is the published trade fee, rounded up to \$0.0001 per side, summed for the day. NULL for 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, Kalshi). NULL for 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

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