Loans

Loan events are when a borrower requests a loan from a lending protocol.

The <chain>.lending.loans table contains borrow events from Aave v1, v2, v3 and Compound v2 and v3 and Morpho Blue protocols, consolidated into a single table for easy querying.

This table tracks all borrowing activities across major lending protocols, providing comprehensive information about loan amounts, tokens, borrowers, and transaction details.

​

Sample Query

Total borrowers of UDSC (by contract address) on Ethereum blockchain in the past 90 days.

select
    date(block_timestamp) as date,
    project, 
    count(distinct borrower_address) as borrowers,
    sum(usd_amount) as usd 
from ethereum.lending.loans
where token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
and block_timestamp  >= current_date - 90
group by all
order by date desc

Most commonly borrowed tokens on Ethereum blockchain by borrowers count.

select
    token_address,
    token_name,
    count(distinct borrower_address) as borrowers,
    count(1) as borrow_count,
    sum(usd_amount) as usd 
from ethereum.lending.loans
group by all 
order by borrowers desc

​

Table Columns

Unique Key: unique_id