Lending markets

One row per lending market in dimensions.lending_markets, the boundary inside which deposits and debts back each other: the pool on Aave, one collateral and loan pair on Morpho Blue. lending_market_reserve_id keys dimensions.lending_market_reserves, one row per asset inside a market, and that is the grain a market’s figures are summed from.

Coverage

One row per app, and a tick marks every app that reports the measure at this grain. It is the same table as the Market tab of Lending.

App	Project	TVL	Active loans	Collateral
`aave-v3`	`aave`	✓	✓	✓
`aave-v4`	`aave`	✓	✓	✓

Columns

Markets
Reserves

One row per lending market on one chain.

Column	Type	Description
`lending_market_id`	STRING	Market key, formatted `{lending_market}-{chain_id}`.
`app_id`	STRING	App operating the market, such as `aave-v3` or `morpho-blue`. Joins `dimensions.apps`.
`chain_id`	STRING	Chain the market lives on.
`project_id`	STRING	Project behind the app. Joins `dimensions.projects`.
`lending_market`	STRING	The protocol’s own key for the market: the pool contract address on pool lenders, the market hash on Morpho Blue.
`lending_market_contract_address`	STRING	The deployed contract the market runs on. Matches `lending_market` on pool lenders; every Morpho Blue market on a chain shares one singleton contract.
`lending_market_name`	STRING	Readable name of the market, such as `Core` or `Morpho Blue: cbBTC/USDC 86%`. A label, not a key.

One row per reserve, one asset inside one market. An Aave pool lists one reserve per underlying token and a Morpho Blue market exactly two, the loan side and the collateral side; where a pool lists the same token twice, the key is the protocol’s listing rather than the token.

Column	Type	Description
`lending_market_reserve_id`	STRING	Reserve key, formatted `{lending_market}-{lending_market_reserve}-{chain_id}`.
`lending_market_id`	STRING	Market the reserve belongs to. Joins `dimensions.lending_markets`.
`app_id`	STRING	App operating the market. Joins `dimensions.apps`.
`chain_id`	STRING	Chain the market lives on.
`project_id`	STRING	Project behind the app. Joins `dimensions.projects`.
`lending_market`	STRING	The protocol’s own key for the market, copied from the market row.
`lending_market_contract_address`	STRING	The deployed contract the market runs on, copied from the market row.
`lending_market_name`	STRING	Readable name of the market, copied from the market row.
`lending_market_reserve`	STRING	The protocol’s own key for the reserve inside its market: the underlying token address on Aave-style pools, the vToken contract on Venus, `loan` or `collateral` on Morpho Blue, the numeric reserve id on Aave v4.
`lending_market_reserve_name`	STRING	Readable name: the market name and the token symbol, such as `Core: WETH`. A label, not a key.
`token_id`	STRING	Key of the underlying token in `dimensions.tokens`, formatted `{token_address}-{chain_id}`.
`token_address`	STRING	Address of the underlying token contract.
`token_symbol`	STRING	Ticker symbol of the underlying token.

Sample queries

Rank markets by size
What one market holds

TVL is a balance, so read it on a single day. The registry turns lending_market_id into the market’s name, its app and the chain it lives on.

select
    markets.lending_market_name,
    markets.app_id,
    markets.chain_id,
    market_tvl.tvl
from `metrics_lending_markets.tvl_daily` as market_tvl
join `dimensions.lending_markets` as markets
    using (lending_market_id)
where market_tvl.timestamp = timestamp('2026-08-01')
order by market_tvl.tvl desc
limit 20

The reserve rows sit one level below the market and each names its token, so the registry turns each reserve key into a symbol. Filter the reserve side on lending_market_id to stay inside one market.

select
    reserves.token_symbol,
    reserves.lending_market_reserve,
    reserve_tvl.tvl
from `metrics_lending_market_reserves.tvl_daily` as reserve_tvl
join `dimensions.lending_market_reserves` as reserves
    using (lending_market_reserve_id)
where reserve_tvl.timestamp = timestamp('2026-08-01')
  and reserves.lending_market_id = '0xc13e21b648a5ee794902342038ff3adab66be987-ethereum'
order by reserve_tvl.tvl desc

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Coverage

Columns

Sample queries

​Coverage

​Columns

​Sample queries

Coverage

Columns

Sample queries