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.
borrower_address reflects the address emitted by the specific event Allium decodes for a protocol. For most protocols that’s the borrowing wallet, but for protocols that route borrows through a vault, router, or liquidity layer below the user-facing entry point, it can instead be that intermediate contract. When you need reliable end-user attribution, filter on transaction_from_address instead — it’s the transaction originator, though it won’t capture borrows routed through a smart contract wallet, batcher, or aggregator.
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.loanswhere token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'and block_timestamp >= current_date - 90group by allorder 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.loansgroup by all order by borrowers desc
