Deposits

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.

​

Sample Query

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.deposits
where project = 'aave'
and token_address = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2') -- WETH Address
and block_timestamp  >= current_date - 90
group 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.deposits
where 1=1 and block_timestamp  >= current_date - 90
group by all

​

Table Columns

Unique Key: unique_id