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

Column	Data Type	Description
project	VARCHAR	Name of the lending project
protocol	VARCHAR	Underlying protocol that the lending protocol is utilising
lending_event	VARCHAR	Type of lending event (always ‘deposits’ for this table)
event_name	VARCHAR	Name of the event
market_address	VARCHAR	Address of the lending market
depositor_address	VARCHAR	Address of the depositor
target_address	VARCHAR	Address of the target recipient of the deposit tokens
token_address	VARCHAR	Address of the token deposited
token_name	VARCHAR	Name of the token deposited
token_symbol	VARCHAR	Symbol of the token deposited
token_decimals	INTEGER	Number of decimals of the token deposited
raw_amount_str	VARCHAR	Raw amount of the token deposited, in string to retain precision
raw_amount	FLOAT	Raw amount of the token deposited
amount_str	VARCHAR	Normalised amount of the token deposited, in string to retain precision
amount	FLOAT	Normalised amount of the token deposited
usd_amount	FLOAT	USD amount of the token deposited at the time of the transaction
usd_exchange_rate	FLOAT	Hourly USD exchange rate of the token deposited
receipt_token_address	VARCHAR	Address of the receipt token received (e.g., aToken, cToken)
extra_fields	VARIANT	Extra fields from the event
transaction_hash	VARCHAR	Transaction hash of the event
transaction_index	INTEGER	Index of the transaction in the block
transaction_from_address	VARCHAR	Address of the sender of the transaction
transaction_to_address	VARCHAR	Address of the recipient of the transaction
log_index	INTEGER	Index of the log in the transaction
topic0	VARCHAR	Topic 0 of the event
block_number	INTEGER	Block number of the event
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block
block_hash	VARCHAR	Hash of the block
unique_id	VARCHAR	Unique ID of the event
created_at	TIMESTAMP_NTZ(9)	Timestamp of when the event was created
updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the event was last updated

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Sample Query

Table Columns

​Sample Query

​Table Columns

Sample Query

Table Columns