Skip to main content
Liquidation events are when a borrower’s collateral is seized by a liquidator to repay their debt. The <chain>.lending.liquidations table contains liquidation events from Aave v1, v2, v3, Compound v2, v3 and Morpho Blue protocols, consolidated into a single table for easy querying. This table tracks all liquidation activities across major lending protocols, providing comprehensive information about liquidated collateral, repaid debt, and the parties involved in the liquidation process.

​
Sample Query

Total liquidation volume of all lending projects on Ethereum in the past 180 days. 
select
    project, 
    sum(usd_amount) as usd 
from ethereum.lending.liquidations
where block_timestamp  >= current_date - 180
group by all
order by usd desc
Number of borrowers and total liquidation volume of all lending projects on Ethereum in the past 90 days. 
select
    project, 
    count(distinct borrower_address) as borrwers,
    sum(usd_amount) as usd 
from ethereum.lending.liquidations
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 ‘liquidations’ for this table)
event_nameVARCHARName of the event
market_addressVARCHARAddress of the lending market where the liquidation occurred
borrower_addressVARCHARAddress of the borrower being liquidated
liquidator_addressVARCHARAddress of the liquidator performing the liquidation
token_addressVARCHARAddress of the collateral token being liquidated
token_nameVARCHARName of the collateral token being liquidated
token_symbolVARCHARSymbol of the collateral token being liquidated
token_decimalsINTEGERNumber of decimals of the collateral token
raw_amount_strVARCHARRaw amount of collateral liquidated, in string to retain precision
amount_strVARCHARNormalised amount of collateral liquidated, in string to retain precision
amountFLOATNormalised amount of collateral liquidated
usd_amountFLOATUSD value of the collateral liquidated at the time of the transaction
usd_exchange_rateFLOATHourly USD exchange rate of the collateral token
repay_token_addressVARCHARAddress of the token used to repay the debt. This is null for Compound V3 events
repay_token_nameVARCHARName of the token used to repay the debt. This is null for Compound V3 events
repay_token_symbolVARCHARSymbol of the token used to repay the debt. This is null for Compound V3 events
repay_token_decimalsINTEGERNumber of decimals of the repayment token. This is null for Compound V3 events
repay_raw_amount_strVARCHARRaw amount of debt repaid, in string to retain precision. This is null for Compound V3 events
repay_amount_strVARCHARNormalised amount of debt repaid, in string to retain precision. This is null for Compound V3 events
repay_amountFLOATNormalised amount of debt repaid. This is null for Compound V3 events
repay_usd_amountFLOATUSD value of the debt repaid at the time of the transaction. This is null for Compound V3 events
extra_fieldsVARIANTAdditional protocol-specific fields from the event
transaction_hashVARCHARTransaction hash of the liquidation event
transaction_indexINTEGERIndex of the transaction in the block
transaction_from_addressVARCHARAddress of the sender of the liquidation transaction
transaction_to_addressVARCHARAddress of the recipient of the liquidation transaction
log_indexINTEGERIndex of the log in the transaction
topic0VARCHARTopic 0 of the event
block_numberINTEGERBlock number of the liquidation event
block_timestampTIMESTAMP_NTZ(9)Timestamp of the block
block_hashVARCHARHash of the block
unique_idVARCHARUnique ID of the liquidation event
_created_atTIMESTAMP_NTZ(9)Timestamp of when the event was created
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the event was last updated
⌘I