Registry - Token Terminal Docs

dimensions.lending_markets holds one row per lending market: one asset inside one lending pool, the asset users supply and borrow there. Lending protocols usually call that a reserve. The table brings together every lending protocol we cover.

Columns

Column	Type	Description
`lending_market_id`	`STRING`	Market key: `lending_market_address` joined to `chain_id`.
`deployment_id`	`STRING`	Protocol version deployed on one chain, such as `aave-v3-ethereum`.
`protocol_id`	`STRING`	Protocol version across chains, such as `aave-v3`.
`chain_id`	`STRING`	Chain the market lives on.
`project_id`	`STRING`	Project operating the protocol.
`version`	`STRING`	Protocol version label, such as `v3`.
`lending_pool_address`	`STRING`	Contract of the pool this market belongs to.
`lending_pool_name`	`STRING`	Readable name of the pool, such as `Core` or `Polygon`.
`lending_market_address`	`STRING`	Contract that identifies the market: the receipt token where the protocol issues one, the supplied token itself where it does not.
`underlying_token_address`	`STRING`	Contract of the token users supply and borrow in this market.
`underlying_symbol`	`STRING`	Symbol of the underlying asset.
`market_name`	`STRING`	Display name of the market.

Sample queries

Markets per chain
Markets in one pool
Markets for one asset

Count markets per chain and version.

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

List every market in one pool.

select
    lending_market_id,
    underlying_symbol,
    market_name,
    underlying_token_address
from `dimensions.lending_markets`
where lending_pool_name = 'Core'
order by underlying_symbol

Find every market that lends one asset.

select
    lending_market_id,
    chain_id,
    version,
    lending_pool_name
from `dimensions.lending_markets`
where underlying_symbol = 'USDC'
order by chain_id, version

⌘I