Metrics

TVL, active loans, collateral, fees and revenue, in USD. One row per thing per day, at four grains: project, app, market and reserve. TVL, active loans and collateral are balances, not flows. They add up across reserves, markets, apps and chains, but never across days: a week’s figure is the last day in it, and adding seven days counts the same balance seven times. Fees and revenue are flows and add up both ways. Metric definitions has the rule in full.

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 in the app.
`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_apps_by_chain 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_apps_by_chain.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