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.bridged_supply_daily`	`bridged_supply`	USD value of the project’s stablecoins held outside the chain they were issued on.
`metrics_projects.buybacks_daily`	`buybacks`	USD value of the project’s own tokens repurchased from the market.
`metrics_projects.bridge_deposits_daily`	`bridge_deposits`	USD value of assets held in the project’s bridge contracts on the main chain.
`metrics_projects.transaction_volume_daily`	`transaction_volume`	USD value of transactions processed by the project.
`metrics_projects.open_interest_daily`	`open_interest`	USD notional value of all open positions on the project’s derivatives markets.
`metrics_projects.trade_count_daily`	`trade_count`	Number of trades executed.
`metrics_projects.cost_of_revenue_daily`	`cost_of_revenue`	Direct supply-side cost of revenue.
`metrics_projects.capital_deployed_daily`	`capital_deployed`	USD value of user deposits an asset manager has allocated into investments.
`metrics_projects.flash_loan_volume_daily`	`flash_loan_volume`	Total flash loan volume.
`metrics_projects.operating_expenses_daily`	`operating_expenses`	Onchain operating expenses, excluding token incentives.
`metrics_projects.liquidation_volume_daily`	`liquidation_volume`	USD value of debt covered in liquidations.
`metrics_projects.tradeable_pair_count_daily`	`tradeable_pair_count`	Number of token pairs available for trading on the exchange.
`metrics_projects.tradeable_asset_count_daily`	`tradeable_asset_count`	Number of tokens tradeable on the exchange.
`metrics_projects.monthly_active_developers_daily`	`monthly_active_developers`	Number of active developers.
`metrics_projects.code_commit_count_daily`	`code_commit_count`	Commits to public repositories.
`metrics_projects.price_daily`	`price`	Project token price in USD.
`metrics_projects.market_cap_circulating_daily`	`market_cap_circulating`	Market cap on circulating supply.
`metrics_projects.market_cap_fully_diluted_daily`	`market_cap_fully_diluted`	Market cap on maximum supply.
`metrics_projects.staking_market_cap_daily`	`staking_market_cap`	USD value of the native token staked to secure the chains the project operates, summed across them.
`metrics_projects.token_supply_circulating_daily`	`token_supply_circulating`	Circulating token supply.
`metrics_projects.token_supply_maximum_daily`	`token_supply_maximum`	Maximum token supply.
`metrics_projects.token_trading_volume_daily`	`token_trading_volume`	Trading volume of the project’s own token.
`metrics_projects.token_holders_daily`	`token_holders`	Addresses holding the project’s token.
`metrics_projects.daily_active_addresses_daily`	`daily_active_addresses`	Distinct addresses transacting with the project’s contracts per day.
`metrics_projects.weekly_active_addresses_daily`	`weekly_active_addresses`	Distinct addresses transacting with the project’s contracts over a rolling 7 days.
`metrics_projects.monthly_active_addresses_daily`	`monthly_active_addresses`	Distinct addresses transacting with the project’s contracts over a rolling 30 days.
`metrics_projects.transaction_count_contracts_daily`	`transaction_count_contracts`	Transactions calling the project’s contracts.
`metrics_projects.gas_used_daily`	`gas_used`	Gas consumed by transactions calling the project’s contracts.
`metrics_projects.fees_per_daily_active_user_daily`	`fees_per_daily_active_user`	Average fees per user.
`metrics_projects.revenue_per_daily_active_user_daily`	`revenue_per_daily_active_user`	Average revenue per user.
`metrics_projects.gross_profit_daily`	`gross_profit`	Revenue minus cost of revenue.
`metrics_projects.liquidity_turnover_daily`	`liquidity_turnover`	Trading volume relative to liquidity.
`metrics_projects.trade_size_average_daily`	`trade_size_average`	Average trading volume per trade.
`metrics_projects.trading_volume_per_daily_active_user_daily`	`trading_volume_per_daily_active_user`	Average trading volume per user.
`metrics_projects.price_to_fees_fully_diluted_daily`	`price_to_fees_fully_diluted`	Fully diluted market cap over annualized fees (trailing 30d run-rate).
`metrics_projects.price_to_fees_circulating_daily`	`price_to_fees_circulating`	Circulating market cap over annualized fees (trailing 30d run-rate).
`metrics_projects.price_to_revenue_fully_diluted_daily`	`price_to_revenue_fully_diluted`	Fully diluted market cap over annualized revenue (trailing 30d run-rate).
`metrics_projects.price_to_revenue_circulating_daily`	`price_to_revenue_circulating`	Circulating market cap over annualized revenue (trailing 30d run-rate).
`metrics_projects.take_rate_daily`	`take_rate`	Share of fees the project retains as revenue.
`metrics_projects.token_turnover_fully_diluted_daily`	`token_turnover_fully_diluted`	Token trading volume over fully diluted market cap.
`metrics_projects.token_turnover_circulating_daily`	`token_turnover_circulating`	Token trading volume over circulating market cap.
`metrics_projects.daily_active_users_daily`	`daily_active_users`	Distinct addresses that used the project that day. A HyperLogLog estimate, not a sum of the daily series.
`metrics_projects.weekly_active_users_daily`	`weekly_active_users`	Distinct addresses that used the project in the trailing 7 days. A HyperLogLog estimate.
`metrics_projects.monthly_active_users_daily`	`monthly_active_users`	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_projects_by_chain.tvl_daily`	`tvl`	Value locked in the project’s contracts on the chain at day end, in USD.
`metrics_projects_by_chain.trading_volume_daily`	`trading_volume`	Cash value of the trades that took place on the chain, in USD.
`metrics_projects_by_chain.active_loans_daily`	`active_loans`	Value of loans outstanding on the chain at day end, in USD.
`metrics_projects_by_chain.assets_staked_daily`	`assets_staked`	Value staked on the chain at day end, in USD.
`metrics_projects_by_chain.fees_daily`	`fees`	Total fees users paid on the chain, in USD.
`metrics_projects_by_chain.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_projects_by_chain.revenue_daily`	`revenue`	Fees the project kept on the chain, in USD.
`metrics_projects_by_chain.token_incentives_daily`	`token_incentives`	Value of the project’s own token paid out as rewards on the chain, in USD.
`metrics_projects_by_chain.outstanding_supply_daily`	`outstanding_supply`	Stablecoin supply issued by the project and outstanding on the chain today, in USD. Stablecoin issuers only.
`metrics_projects_by_chain.bridged_supply_daily`	`bridged_supply`	USD value of the project’s stablecoins held outside the chain they were issued on.
`metrics_projects_by_chain.buybacks_daily`	`buybacks`	USD value of the project’s own tokens repurchased from the market.
`metrics_projects_by_chain.bridge_deposits_daily`	`bridge_deposits`	USD value of assets held in the project’s bridge contracts on the main chain.
`metrics_projects_by_chain.transaction_volume_daily`	`transaction_volume`	USD value of transactions processed by the project.
`metrics_projects_by_chain.open_interest_daily`	`open_interest`	USD notional value of all open positions on the project’s derivatives markets.
`metrics_projects_by_chain.trade_count_daily`	`trade_count`	Number of trades executed.
`metrics_projects_by_chain.cost_of_revenue_daily`	`cost_of_revenue`	Direct supply-side cost of revenue.
`metrics_projects_by_chain.capital_deployed_daily`	`capital_deployed`	USD value of user deposits an asset manager has allocated into investments.
`metrics_projects_by_chain.flash_loan_volume_daily`	`flash_loan_volume`	Total flash loan volume.
`metrics_projects_by_chain.expenses_daily`	`expenses`	What the project spent on the chain, in USD: cost of revenue, token incentives and operating expenses.
`metrics_projects_by_chain.operating_expenses_daily`	`operating_expenses`	Onchain operating expenses, excluding token incentives.
`metrics_projects_by_chain.liquidation_volume_daily`	`liquidation_volume`	USD value of debt covered in liquidations.
`metrics_projects_by_chain.tradeable_pair_count_daily`	`tradeable_pair_count`	Number of token pairs available for trading on the exchange.
`metrics_projects_by_chain.tradeable_asset_count_daily`	`tradeable_asset_count`	Number of tokens tradeable on the exchange.
`metrics_projects_by_chain.daily_active_users_daily`	`daily_active_users`	Distinct addresses that used the project on the chain that day. A HyperLogLog estimate.
`metrics_projects_by_chain.weekly_active_users_daily`	`weekly_active_users`	Distinct addresses that used the project on the chain in the trailing 7 days. A HyperLogLog estimate.
`metrics_projects_by_chain.monthly_active_users_daily`	`monthly_active_users`	Distinct addresses that used the project on the chain in the trailing 30 days. A HyperLogLog estimate.
`metrics_projects_by_chain.daily_active_addresses_daily`	`daily_active_addresses`	Distinct addresses transacting with the project’s contracts per day, on one chain.
`metrics_projects_by_chain.weekly_active_addresses_daily`	`weekly_active_addresses`	Distinct addresses transacting with the project’s contracts over a rolling 7 days, on one chain.
`metrics_projects_by_chain.monthly_active_addresses_daily`	`monthly_active_addresses`	Distinct addresses transacting with the project’s contracts over a rolling 30 days, on one chain.
`metrics_projects_by_chain.transaction_count_contracts_daily`	`transaction_count_contracts`	Transactions calling the project’s contracts, on one chain.
`metrics_projects_by_chain.gas_used_daily`	`gas_used`	Gas consumed by transactions calling the project’s contracts, on one chain.
`metrics_projects_by_chain.token_holders_daily`	`token_holders`	Addresses holding the project’s token, on one chain.
`metrics_projects_by_chain.treasury_daily`	`treasury`	Value the project held at day end, in USD, its own token included, on one chain.
`metrics_projects_by_chain.treasury_net_daily`	`treasury_net`	Value the project held at day end excluding its own token, in USD, on one chain.

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_projects_by_chain.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 market sector of a project, so unnesting it in the from clause counts a project once per sector.

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