Metrics

TVL, active loans, collateral, fees and revenue, in USD. One row per thing per day, at four grains: project, app, market and reserve.

Tables

A tab per grain. Coverage shows which apps report which measure.

Project
App
Market
Reserve

One row per project per day.

Table	Value column	What it holds
`metrics_projects.tvl_daily`	`tvl`	Total value locked.
`metrics_projects.active_loans_daily`	`active_loans`	USD value of open loans (outstanding borrows).
`metrics_projects.collateral_daily`	`collateral`	USD value of deposits actively backing an open loan.
`metrics_projects.fees_daily`	`fees`	Total fees paid by users.
`metrics_projects.fees_supply_side_daily`	`fees_supply_side`	Fees paid out to the supply side.
`metrics_projects.revenue_daily`	`revenue`	Fees retained by the protocol.

One row per app per day.

Table	Value column	What it holds
`metrics_apps.tvl_daily`	`tvl`	Total value locked across the app’s lending markets and vaults.
`metrics_apps.active_loans_daily`	`active_loans`	USD value of open loans (outstanding borrows) across the app’s lending markets.
`metrics_apps.collateral_daily`	`collateral`	USD value of deposits actively backing an open loan across the app’s lending markets.
`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.

One row per market per day.

Table	Value column	What it holds
`metrics_lending_markets.tvl_daily`	`tvl`	USD value of deposits supplied to the lending market (idle + borrowed).
`metrics_lending_markets.active_loans_daily`	`active_loans`	USD value of open loans (outstanding borrows) on the market.
`metrics_lending_markets.collateral_daily`	`collateral`	USD value of deposits actively backing an open loan on the market.

One row per market and token per day.

Table	Value column	What it holds
`metrics_lending_market_reserves.tvl_daily`	`tvl`	USD value of deposits supplied to the reserve (idle + borrowed).
`metrics_lending_market_reserves.active_loans_daily`	`active_loans`	USD value of open loans (outstanding borrows) against the reserve.
`metrics_lending_market_reserves.collateral_daily`	`collateral`	USD value of the reserve’s deposits actively backing an open loan.

Sample queries

One market's series
Every protocol, ranked
One app across chains

Each measure is its own table, so a row with both is a join on lending_market_id and timestamp, bounded on every side. Join the loans side with left join: a market can hold value with no loans open against it.

with markets as (
    select lending_market_id, lending_market_name
    from `dimensions.lending_markets`
    where chain_id = 'ethereum'
      and app_id = 'aave-v3'
),

locked as (
    select lending_market_id, timestamp, tvl
    from `metrics_lending_markets.tvl_daily`
    where chain_id = 'ethereum'
      and timestamp >= timestamp('2026-06-01')
),

loans as (
    select lending_market_id, timestamp, active_loans
    from `metrics_lending_markets.active_loans_daily`
    where chain_id = 'ethereum'
      and timestamp >= timestamp('2026-06-01')
)

select
    locked.timestamp,
    markets.lending_market_name,
    locked.tvl,
    loans.active_loans
from locked
join markets
    using (lending_market_id)
left join loans
    using (lending_market_id, timestamp)
order by locked.timestamp

The project grain rolls up every app and chain a protocol runs, so one row is the protocol’s whole business.

select
    project_id,
    active_loans
from `metrics_projects.active_loans_daily`
where timestamp = timestamp('2026-09-01')
order by active_loans desc
limit 25

metrics_app_chains splits an app’s daily figure by the chain it sits on, keyed on app_id and chain_id together.

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

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries