Deposit events are when a user deposits tokens into a lending protocol, to earn interest or as collateral to borrow other assets from the protocol.The <chain>.lending.deposits table contains deposit 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 deposit activities across major lending protocols, providing comprehensive information about deposit amounts, tokens, participants, and transaction details.
depositor_address reflects the address emitted by the specific event Allium decodes for a protocol. For most protocols that’s the depositing wallet, but for protocols that route deposits through a vault, router, or liquidity layer below the user-facing entry point, it can instead be that intermediate contract (for example, a receipt-token contract like Fluid’s fUSDC). When you need reliable end-user attribution, filter on transaction_from_address instead — it’s the transaction originator, though it won’t capture deposits routed through a smart contract wallet, batcher, or aggregator.
How much WETH has been deposited into Aave on Ethereum in the past 90 days?
select date(block_timestamp) as date, project, token_address, token_name, sum(usd_amount) as usd from ethereum.lending.depositswhere project = 'aave'and token_address = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2') -- WETH Addressand block_timestamp >= current_date - 90group by all
What is the total deposit volume of all lending projects on Ethereum in the past 90 days?
select date(block_timestamp) as date, project, token_address, token_name, sum(usd_amount) as usd from ethereum.lending.depositswhere 1=1 and block_timestamp >= current_date - 90group by all
