Withdrawal events are when a user withdraws tokens (tokens deposited or added as collateral previously) from a lending protocol.

The <chain>.lending.withdrawals table contains withdrawal 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 withdrawal activities across major lending protocols, providing comprehensive information about withdrawn amounts, tokens, participants, and transaction details.

​
Sample Query

Total withdrawals of all lending projects on Ethereum in the past 90 days.

select
    project, 
    sum(usd_amount) as usd 
from ethereum.lending.withdrawals
where block_timestamp  >= current_date - 90
group by all
order by usd desc

Total withdrawals by token of Aave on Ethereum in the past 90 days.

select 
    project, 
    token_address,
    token_name,
    token_symbol,
    sum(usd_amount) as usd 
from ethereum.lending.withdrawals
where project = 'aave'
and block_timestamp  >= current_date - 90
group by all
order by usd desc

​
Table Columns

Unique Key: unique_id

ColumnData TypeDescription
projectVARCHARName of the lending project
protocolVARCHARUnderlying protocol that the lending protocol is utilising
lending_eventVARCHARType of lending event (always ‘withdrawals’ for this table)
event_nameVARCHARName of the event
market_addressVARCHARAddress of the lending market
withdrawer_addressVARCHARAddress of the withdrawer
recipient_addressVARCHARAddress of the recipient of the withdrawn tokens
token_addressVARCHARAddress of the token withdrawn
token_nameVARCHARName of the token withdrawn
token_symbolVARCHARSymbol of the token withdrawn
token_decimalsINTEGERNumber of decimals of the token withdrawn
raw_amount_strVARCHARRaw amount of the token withdrawn, in string to retain precision
raw_amountFLOATRaw amount of the token withdrawn
amount_strVARCHARNormalised amount of the token withdrawn, in string to retain precision
amountFLOATNormalised amount of the token withdrawn
usd_amountFLOATUSD amount of the token withdrawn at the time of the transaction
usd_exchange_rateFLOATHourly USD exchange rate of the token withdrawn
receipt_token_addressVARCHARAddress of the receipt token burned (e.g., aToken, cToken)
extra_fieldsVARIANTExtra fields from the event
transaction_hashVARCHARTransaction hash of the event
transaction_indexINTEGERIndex of the transaction in the block
transaction_from_addressVARCHARAddress of the sender of the transaction
transaction_to_addressVARCHARAddress of the recipient of the transaction
log_indexINTEGERIndex of the log in the transaction
topic0VARCHARTopic 0 of the event
block_numberINTEGERBlock number of the event
block_timestampTIMESTAMP_NTZ(9)Timestamp of the block
block_hashVARCHARHash of the block
unique_idVARCHARUnique ID of the event
_created_atTIMESTAMP_NTZ(9)Timestamp of when the event was created
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the event was last updated