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: a pool that takes deposits and lends them out. The assets inside a market are its reserves. dimensions.lending_markets lists the Avalanche markets with chain_id = 'avalanche'. The reserves inside one market share collateral, so a deposit in one 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 per app
Markets one app runs

Count Avalanche markets by the app that runs them.

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

List the markets one app runs on Avalanche. lending_market_contract_address is the market’s own contract.

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

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Sample queries

​Sample queries

Sample queries