Metrics

A project is the company or protocol behind one or more apps: Uniswap is a project, uniswap-v3 one of its apps. Four tables carry the same measures at four levels: one row per day per project, project and chain, app, and app and chain. Every measure is in USD, and an empty cell means no figure for that day, not zero.

Tables

Project
Project × chain
App
App × chain

One row per (project_id, timestamp), in metrics.projects_daily, since 2020-05. Everything the project runs, combined: gas from its chains and trading fees from its apps arrive added into a single fee figure.

Column	Type	Description
`timestamp`	`TIMESTAMP`	The day, truncated to UTC midnight. Partition column.
`project_id`	`STRING`	Project the row measures.
`tvl`	`BIGNUMERIC`	Value locked in the project’s contracts at day end, in USD.
`trading_volume`	`BIGNUMERIC`	Cash value of the trades that took place, in USD.
`active_loans`	`BIGNUMERIC`	Value of loans outstanding at day end, in USD.
`notional_trading_volume`	`BIGNUMERIC`	In progress. Face value of perpetual contracts traded, in USD.
`assets_staked`	`BIGNUMERIC`	In progress. Value staked at day end, in USD.
`fees`	`FLOAT64`	Total fees users paid, in USD. Chain gas plus app trading fees.
`revenue`	`FLOAT64`	Fees the project kept, in USD.
`token_incentives`	`FLOAT64`	In progress. Value of the project’s own token paid out as rewards, in USD.
`active_users`	`INT64`	In progress. Distinct addresses that used the project that day.

One row per (project_id, chain_id, timestamp), in metrics.projects_chains_daily, since 2020-05. This is where a chain’s own numbers meet the project that runs it.

Column	Type	Description
`timestamp`	`TIMESTAMP`	The day, truncated to UTC midnight. Partition column.
`project_id`	`STRING`	Project the row measures.
`chain_id`	`STRING`	Chain the row measures.
`tvl`	`BIGNUMERIC`	Value locked in the project’s contracts on the chain at day end, in USD.
`trading_volume`	`BIGNUMERIC`	Cash value of the trades that took place on the chain, in USD.
`active_loans`	`BIGNUMERIC`	Value of loans outstanding on the chain at day end, in USD.
`notional_trading_volume`	`BIGNUMERIC`	In progress. Face value of perpetual contracts traded on the chain, in USD.
`assets_staked`	`BIGNUMERIC`	In progress. Value staked on the chain at day end, in USD.
`fees`	`FLOAT64`	Total fees users paid on the chain, in USD.
`revenue`	`FLOAT64`	Fees the project kept on the chain, in USD.
`token_incentives`	`FLOAT64`	In progress. Value of the project’s own token paid out as rewards on the chain, in USD.
`active_users`	`INT64`	In progress. Distinct addresses that used the project on the chain that day.

One row per (app_id, timestamp), in metrics.apps_daily, since 2020-05. Details such as which project runs the app and which market sectors it belongs to live in dimensions.apps.

Column	Type	Description
`timestamp`	`TIMESTAMP`	The day, truncated to UTC midnight. Partition column.
`app_id`	`STRING`	App the row measures.
`tvl`	`BIGNUMERIC`	Value locked in the app’s contracts at day end, in USD.
`trading_volume`	`BIGNUMERIC`	Cash value of the trades that took place on the app, in USD.
`active_loans`	`BIGNUMERIC`	Value of loans outstanding on the app at day end, in USD.
`notional_trading_volume`	`BIGNUMERIC`	In progress. Face value of perpetual contracts traded on the app, in USD.
`assets_staked`	`BIGNUMERIC`	In progress. Value staked on the app at day end, in USD.
`fees`	`FLOAT64`	Fees paid by users of the app, in USD.
`revenue`	`FLOAT64`	Fees the app kept, in USD.
`token_incentives`	`FLOAT64`	In progress. Value of the project’s own token paid out as rewards through the app, in USD.
`active_users`	`INT64`	In progress. Distinct addresses that used the app that day.

One row per (app_id, chain_id, timestamp), in metrics.apps_chains_daily, since 2020-05: the narrowest level published.

Column	Type	Description
`timestamp`	`TIMESTAMP`	The day, truncated to UTC midnight. Partition column.
`app_id`	`STRING`	App the row measures.
`chain_id`	`STRING`	Chain the row measures.
`tvl`	`BIGNUMERIC`	Value locked in the app’s contracts on the chain at day end, in USD.
`trading_volume`	`BIGNUMERIC`	Cash value of the trades that took place on the app and chain, in USD.
`active_loans`	`BIGNUMERIC`	Value of loans outstanding on the app and chain at day end, in USD.
`notional_trading_volume`	`BIGNUMERIC`	In progress. Face value of perpetual contracts traded on the app and chain, in USD.
`assets_staked`	`BIGNUMERIC`	In progress. Value staked on the app and chain at day end, in USD.
`fees`	`FLOAT64`	Fees paid by users of the app on the chain, in USD.
`revenue`	`FLOAT64`	Fees the app kept on the chain, in USD.
`token_incentives`	`FLOAT64`	In progress. Value of the project’s own token paid out as rewards through the app on the chain, in USD.
`active_users`	`INT64`	In progress. Distinct addresses that used the app on the chain that day.

Sample queries

Project
Project × chain
App
App × chain

Read one project’s daily Fees, Revenue and TVL.

select
    timestamp,
    fees,
    revenue,
    tvl
from `metrics.projects_daily`
where project_id = 'hyperliquid'
  and timestamp >= timestamp('2026-06-01')
order by timestamp

Break one project’s fees down by chain on one day. The project-and-chain table is where a chain’s own numbers meet the project that runs it.

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

Rank apps by fees over one week.

select
    app_id,
    sum(fees) as fees,
    sum(revenue) as revenue
from `metrics.apps_daily`
where timestamp >= timestamp('2026-08-01')
  and timestamp < timestamp('2026-08-08')
group by app_id
order by fees desc

Split one app’s fees by chain over one week. Dropping the chain filter and grouping by chain turns the narrowest table into a comparison across every chain the app runs on.

select
    chain_id,
    sum(fees) as fees,
    sum(revenue) as revenue
from `metrics.apps_chains_daily`
where app_id = 'uniswap-v3'
  and timestamp >= timestamp('2026-08-01')
  and timestamp < timestamp('2026-08-08')
group by chain_id
order by fees desc

Notes

trading_volume, notional_trading_volume, fees, revenue and token_incentives measure a day’s activity and add up freely: a weekly figure is seven daily rows added together, and a project figure is its apps added together plus whatever its own chains contributed. tvl, active_loans and assets_staked are values standing at day end, so a weekly figure for them is a choice of day rather than a sum. Counts of distinct addresses never add up at all. A daily sector figure is a group by over the project table joined to dimensions.projects; group by primary_market_sector, since joining through unnest(market_sectors) counts a project once per tag it carries. Metric definitions holds the rule for every measure as data you can query.

Overview

Core entities

Market verticals

Chain verticals

Tables

Sample queries

Notes

​Tables

​Sample queries

​Notes

Tables

Sample queries

Notes