Lending

In progress. This vertical is on the way. Contact us if you are interested in this dataset. We want to hear more about your use case!

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 Celo markets with chain_id = 'celo'. 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 Celo markets by the app that runs them.

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

List the markets one app runs on Celo. lending_market_address is the market’s own contract.

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

⌘I

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries