Lending

A lending protocol lets users deposit one token to earn interest and borrow another against it. The unit it works in is a market: one pool crossed with one asset that can be supplied and borrowed. dimensions.lending_markets lists the Avalanche markets with chain_id = 'avalanche'; a pool groups markets that share collateral, so a deposit in one market can back a loan in another. The lending facts land keyed to these markets, one row per event:

Deposits In progress
Withdrawals In progress
Borrows In progress
Repayments In progress
Liquidations In progress
Flash loans In progress
Interest rates In progress

Every column is documented at Lending.

Sample queries

Markets by pool
Assets one version lends

Count Avalanche markets by protocol version and pool.

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

List the assets one version lends on Avalanche. underlying_token_address is the token being supplied and borrowed; lending_market_address is the market’s own contract.

select
    underlying_symbol,
    market_name,
    underlying_token_address,
    lending_market_address
from `dimensions.lending_markets`
where chain_id = 'avalanche'
  and protocol_id = 'aave-v3'
order by underlying_symbol

Overview

Core entities

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries