Registry

The identity tables behind every lending figure. Every fact and metric joins to one of them, and Coverage introduces each grain.

Tables

Projects
Apps
Markets
Reserves

One row per project in the catalog.

Column	Type	Description
`project_id`	STRING	The project, such as `aave`.
`name`	STRING	Display name.
`symbol`	STRING	Ticker of the project’s token, where it has one.
`status_label`	STRING	Whether the project is active or archived.
`market_sectors`	ARRAY<STRING>	Every sector the project is tagged with.
`primary_market_sector`	STRING	The first of those, for grouping.

One row per app in the catalog.

Column	Type	Description
`app_id`	STRING	The app, such as `aave-v3`.
`project_id`	STRING	The project operating it.
`name`	STRING	Display name.
`market_sectors`	ARRAY<STRING>	Every sector the app is tagged with.
`primary_market_sector`	STRING	The first of those, for grouping.
`created_at`	TIMESTAMP	When the app was added.

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, `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

Markets per chain
Markets in one app
Reserves of one market
Where one token is listed

A project can run several apps and each app several markets on a chain, so the count is per app and chain together.

select
    chain_id,
    app_id,
    count(*) as markets
from `dimensions.lending_markets`
where project_id = 'aave'
group by chain_id, app_id
order by markets desc

lending_market_id is the key every lending fact and metric joins on. lending_market_contract_address is what to look up onchain.

select
    lending_market_id,
    lending_market_name,
    chain_id,
    lending_market_contract_address
from `dimensions.lending_markets`
where app_id = 'aave-v3'
order by chain_id, lending_market_name

lending_market_reserve is the protocol’s own key for the listing and lending_market_reserve_id the catalog key built from it.

select
    lending_market_reserve_id,
    lending_market_reserve,
    token_symbol,
    token_address
from `dimensions.lending_market_reserves`
where lending_market_id = '0xc13e21b648a5ee794902342038ff3adab66be987-ethereum'
order by token_symbol

token_address is the underlying token, not the receipt token an app issues against it.

select
    app_id,
    chain_id,
    lending_market_id,
    lending_market_name,
    lending_market_reserve
from `dimensions.lending_market_reserves`
where token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
  and chain_id = 'ethereum'
order by app_id, lending_market_name

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries