Metrics

TVL, fees, revenue, expenses, earnings and active users. One row per thing per day, at two grains: project, and project and chain.

Tables

Daily DEX pool trading volume, Hyperliquid trading contributions and bridge transfer volumes cover closed UTC days and follow the availability cutoff of each contributing chain.

Project
Project × chain

One row per project per day. Everything the project runs, combined: gas from its chains and trading fees from its apps arrive added into one fee figure.

Table	Value column	What it holds
`metrics_projects.tvl_daily`	`tvl`	Value locked in the project’s contracts at day end, in USD.
`metrics_projects.trading_volume_daily`	`trading_volume`	Cash value of the trades that took place, in USD.
`metrics_projects.active_loans_daily`	`active_loans`	Value of loans outstanding at day end, in USD.
`metrics_projects.assets_staked_daily`	`assets_staked`	Value staked at day end, in USD.
`metrics_projects.fees_daily`	`fees`	Total fees users paid, in USD. Chain gas plus app trading fees.
`metrics_projects.fees_supply_side_daily`	`fees_supply_side`	The part of those fees the project passed on to the supply side, in USD.
`metrics_projects.revenue_daily`	`revenue`	Fees the project kept, in USD.
`metrics_projects.token_incentives_daily`	`token_incentives`	Value of the project’s own token paid out as rewards, in USD.
`metrics_projects.expenses_daily`	`expenses`	What the project spent, in USD: cost of revenue, token incentives and operating expenses, wherever each is reported onchain.
`metrics_projects.earnings_daily`	`earnings`	What the project kept after costs, in USD. Goes negative when a project pays out more than it retains.
`metrics_projects.treasury_daily`	`treasury`	Value the project held at day end, in USD, its own token included.
`metrics_projects.treasury_net_daily`	`treasury_net`	Value the project held at day end excluding its own token, in USD.
`metrics_projects.outstanding_supply_daily`	`outstanding_supply`	Stablecoin supply issued by the project and outstanding today, in USD. Stablecoin issuers only.
`metrics_projects.user_dau_daily`	`user_dau`	Distinct addresses that used the project that day. A HyperLogLog estimate, not a sum of the daily series.
`metrics_projects.user_wau_daily`	`user_wau`	Distinct addresses that used the project in the trailing 7 days. A HyperLogLog estimate.
`metrics_projects.user_mau_daily`	`user_mau`	Distinct addresses that used the project in the trailing 30 days. A HyperLogLog estimate.

One row per project and chain per day. A chain’s own numbers meet the project that runs it there.

Table	Value column	What it holds
`metrics_project_chains.tvl_daily`	`tvl`	Value locked in the project’s contracts on the chain at day end, in USD.
`metrics_project_chains.trading_volume_daily`	`trading_volume`	Cash value of the trades that took place on the chain, in USD.
`metrics_project_chains.active_loans_daily`	`active_loans`	Value of loans outstanding on the chain at day end, in USD.
`metrics_project_chains.assets_staked_daily`	`assets_staked`	Value staked on the chain at day end, in USD.
`metrics_project_chains.fees_daily`	`fees`	Total fees users paid on the chain, in USD.
`metrics_project_chains.fees_supply_side_daily`	`fees_supply_side`	The part of those fees the project passed on to the supply side on the chain, in USD.
`metrics_project_chains.revenue_daily`	`revenue`	Fees the project kept on the chain, in USD.
`metrics_project_chains.token_incentives_daily`	`token_incentives`	Value of the project’s own token paid out as rewards on the chain, in USD.
`metrics_project_chains.outstanding_supply_daily`	`outstanding_supply`	Stablecoin supply issued by the project and outstanding on the chain today, in USD. Stablecoin issuers only.
`metrics_project_chains.user_dau_daily`	`user_dau`	Distinct addresses that used the project on the chain that day. A HyperLogLog estimate.
`metrics_project_chains.user_wau_daily`	`user_wau`	Distinct addresses that used the project on the chain in the trailing 7 days. A HyperLogLog estimate.
`metrics_project_chains.user_mau_daily`	`user_mau`	Distinct addresses that used the project on the chain in the trailing 30 days. A HyperLogLog estimate.

Sample queries

Project
Project × chain
Balance rollup
Sector total

Each measure is its own table, so a row with all three is a join on project_id and timestamp. Bound the day range on every side, or the unbounded side reads its whole table.

with fees as (
    select timestamp, fees
    from `metrics_projects.fees_daily`
    where project_id = 'hyperliquid'
      and timestamp >= timestamp('2026-06-01')
),

revenue as (
    select timestamp, revenue
    from `metrics_projects.revenue_daily`
    where project_id = 'hyperliquid'
      and timestamp >= timestamp('2026-06-01')
),

tvl as (
    select timestamp, tvl
    from `metrics_projects.tvl_daily`
    where project_id = 'hyperliquid'
      and timestamp >= timestamp('2026-06-01')
)

select
    timestamp,
    fees.fees,
    revenue.revenue,
    tvl.tvl
from fees
full join revenue
    using (timestamp)
full join tvl
    using (timestamp)
order by timestamp

A project’s chain rows add back to its project row for the same day, where the measure adds up at all.

select
    chain_id,
    fees
from `metrics_project_chains.fees_daily`
where project_id = 'hyperliquid'
  and timestamp = timestamp('2026-08-01')
order by fees desc

tvl is a value standing at day end, and its rule in dimensions.metrics reads over_time = 'last_value': the week’s figure is the last day’s value. The second column adds seven day-end balances and counts the same locked value seven times, so only one of these is a TVL.

select
    array_agg(tvl order by timestamp desc limit 1)[offset(0)] as tvl,
    sum(tvl) as tvl_summed
from `metrics_projects.tvl_daily`
where project_id = 'aave'
  and timestamp >= timestamp('2026-08-01')
  and timestamp < timestamp('2026-08-08')

Group on primary_market_sector, where every project appears exactly once. market_sectors holds every tag on a project, so unnesting it in the from clause counts a project once per tag.

select
    projects.primary_market_sector,
    sum(daily.fees) as fees
from `metrics_projects.fees_daily` as daily
join `dimensions.projects` as projects
    using (project_id)
where daily.timestamp = timestamp('2026-08-01')
group by projects.primary_market_sector
order by fees desc

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries