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.

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.

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