Metrics

TVL, trading volume, fees, revenue, token incentives and active users. One row per thing per day, at two grains: app, and app 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.

App
App × chain

One row per app per day. Where a table has a provenance column, ladder marks a figure summed from the app’s own markets and pools and projected the project’s series attributed to the app.

Table	Value column	What it holds
`metrics_apps.tvl_daily`	`tvl`	Total value locked across the app’s lending markets and vaults.
`metrics_apps.trading_volume_daily`	`trading_volume`	Value of trades executed by the app, measured on the quote leg at execution price.
`metrics_apps.active_loans_daily`	`active_loans`	USD value of open loans (outstanding borrows) across the app’s lending markets.
`metrics_apps.assets_staked_daily`	`assets_staked`	USD value of assets staked with the app.
`metrics_apps.fees_daily`	`fees`	Fees paid by users of the app across every chain it runs on.
`metrics_apps.fees_supply_side_daily`	`fees_supply_side`	Fees the app passed through to builders and, on HIP-3 markets, to market deployers.
`metrics_apps.revenue_daily`	`revenue`	Fees the app retained across every chain it runs on.
`metrics_apps.token_incentives_daily`	`token_incentives`	Value of tokens the app distributed as incentives.
`metrics_apps.outstanding_supply_daily`	`outstanding_supply`	USD value of borrowed principal outstanding.
`metrics_apps.bridged_supply_daily`	`bridged_supply`	USD value of the app’s stablecoins held outside the chain they were issued on.
`metrics_apps.buybacks_daily`	`buybacks`	USD value of the app’s own tokens repurchased from the market.
`metrics_apps.bridge_deposits_daily`	`bridge_deposits`	USD value of assets held in the app’s bridge contracts on the main chain.
`metrics_apps.transaction_volume_daily`	`transaction_volume`	USD value of transactions processed by the app.
`metrics_apps.open_interest_daily`	`open_interest`	USD notional value of all open positions on the app’s derivatives markets.
`metrics_apps.trade_count_daily`	`trade_count`	Number of trades executed on the app.
`metrics_apps.cost_of_revenue_daily`	`cost_of_revenue`	Direct supply-side cost of the app’s revenue.
`metrics_apps.capital_deployed_daily`	`capital_deployed`	USD value of user deposits the app has allocated into investments.
`metrics_apps.flash_loan_volume_daily`	`flash_loan_volume`	USD value of flash loans taken from the app.
`metrics_apps.expenses_daily`	`expenses`	What the app spent, in USD: cost of revenue, token incentives and operating expenses, wherever each is reported onchain.
`metrics_apps.operating_expenses_daily`	`operating_expenses`	Onchain operating expenses of the app, excluding token incentives.
`metrics_apps.liquidation_volume_daily`	`liquidation_volume`	USD value of debt covered in the app’s liquidations.
`metrics_apps.tradeable_pair_count_daily`	`tradeable_pair_count`	Number of token pairs available for trading on the app.
`metrics_apps.tradeable_asset_count_daily`	`tradeable_asset_count`	Number of tokens tradeable on the app.
`metrics_apps.daily_active_users_daily`	`daily_active_users`	Distinct users active on the app per day.
`metrics_apps.weekly_active_users_daily`	`weekly_active_users`	Distinct users active on the app over a trailing week.
`metrics_apps.monthly_active_users_daily`	`monthly_active_users`	Distinct users active on the app over a trailing month.

One row per app and chain per day. Each figure sits on the chain it comes from. Where a table has a provenance column, ladder marks a figure summed from the app’s own markets and pools on that chain and projected the project’s series attributed to the app.

Table	Value column	What it holds
`metrics_apps_by_chain.tvl_daily`	`tvl`	Total value locked across the app’s lending markets and vaults.
`metrics_apps_by_chain.trading_volume_daily`	`trading_volume`	Value of trades executed by the app, measured on the quote leg at execution price.
`metrics_apps_by_chain.active_loans_daily`	`active_loans`	USD value of open loans (outstanding borrows) across the app’s lending markets.
`metrics_apps_by_chain.fees_daily`	`fees`	Fees paid by users of the app across every chain it runs on.
`metrics_apps_by_chain.fees_supply_side_daily`	`fees_supply_side`	Fees the app passed through to builders and, on HIP-3 markets, to market deployers.
`metrics_apps_by_chain.revenue_daily`	`revenue`	Fees the app retained across every chain it runs on.
`metrics_apps_by_chain.token_incentives_daily`	`token_incentives`	Value of tokens the app distributed as incentives, on one chain.
`metrics_apps_by_chain.outstanding_supply_daily`	`outstanding_supply`	USD value of borrowed principal outstanding, on one chain.
`metrics_apps_by_chain.bridge_deposits_daily`	`bridge_deposits`	USD value of assets held in the app’s bridge contracts on the main chain, on one chain.
`metrics_apps_by_chain.trade_count_daily`	`trade_count`	Number of trades executed on the app, on one chain.
`metrics_apps_by_chain.tradeable_asset_count_daily`	`tradeable_asset_count`	Number of tokens tradeable on the app, on one chain.
`metrics_apps_by_chain.tradeable_pair_count_daily`	`tradeable_pair_count`	Number of token pairs available for trading on the app, on one chain.
`metrics_apps_by_chain.cost_of_revenue_daily`	`cost_of_revenue`	Direct supply-side cost of the app’s revenue, on one chain.
`metrics_apps_by_chain.capital_deployed_daily`	`capital_deployed`	USD value of user deposits the app has allocated into investments, on one chain.
`metrics_apps_by_chain.bridged_supply_daily`	`bridged_supply`	USD value of the app’s stablecoins held outside the chain they were issued on, on one chain.
`metrics_apps_by_chain.assets_staked_daily`	`assets_staked`	USD value of assets staked with the app, on one chain.
`metrics_apps_by_chain.flash_loan_volume_daily`	`flash_loan_volume`	USD value of flash loans taken from the app, on one chain.
`metrics_apps_by_chain.open_interest_daily`	`open_interest`	USD notional value of all open positions on the app’s derivatives markets, on one chain.
`metrics_apps_by_chain.expenses_daily`	`expenses`	What the app spent on the chain, in USD: cost of revenue, token incentives and operating expenses.
`metrics_apps_by_chain.operating_expenses_daily`	`operating_expenses`	Onchain operating expenses of the app, excluding token incentives, on one chain.
`metrics_apps_by_chain.transaction_volume_daily`	`transaction_volume`	USD value of transactions processed by the app, on one chain.
`metrics_apps_by_chain.buybacks_daily`	`buybacks`	USD value of the app’s own tokens repurchased from the market, on one chain.
`metrics_apps_by_chain.liquidation_volume_daily`	`liquidation_volume`	USD value of debt covered in the app’s liquidations, on one chain.

Sample queries

App
App × chain
Apps of one project
Balance rollup

Each measure is its own table, so a row with all three is a join on app_id and timestamp. A full join keeps a day that only one of the tables has a figure for.

with fees as (
    select timestamp, fees
    from `metrics_apps.fees_daily`
    where app_id = 'uniswap-v3'
      and timestamp >= timestamp('2026-06-01')
),

revenue as (
    select timestamp, revenue
    from `metrics_apps.revenue_daily`
    where app_id = 'uniswap-v3'
      and timestamp >= timestamp('2026-06-01')
),

tvl as (
    select timestamp, tvl
    from `metrics_apps.tvl_daily`
    where app_id = 'uniswap-v3'
      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

An app’s chain rows add back to its app row for the same day. tvl is a day-end balance, so read one day across chains rather than a range.

select
    chain_id,
    tvl
from `metrics_apps_by_chain.tvl_daily`
where app_id = 'aave-v3'
  and timestamp = timestamp('2026-08-01')
order by tvl desc

The registry supplies the name and the daily table supplies the figure, joined on app_id. Filtering project_id on the daily table keeps the scan on one project.

select
    apps.app_id,
    apps.name,
    sum(daily.fees) as fees
from `metrics_apps.fees_daily` as daily
join `dimensions.apps` as apps
    using (app_id)
where daily.project_id = 'hyperliquid'
  and daily.timestamp >= timestamp('2026-08-01')
  and daily.timestamp < timestamp('2026-08-08')
group by apps.app_id, apps.name
order by fees desc

tvl stands at day end, so the week’s figure is the last day’s value and the summed column counts the same locked value seven times. daily_active_users is a distinct count and behaves the same way: read the day you want, or read weekly_active_users for the week.

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

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries