Liquidations

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

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 ‘liquidations’ for this table)
event_name	VARCHAR	Name of the event
market_address	VARCHAR	Address of the lending market where the liquidation occurred
borrower_address	VARCHAR	Address of the borrower being liquidated
liquidator_address	VARCHAR	Address of the liquidator performing the liquidation
token_address	VARCHAR	Address of the collateral token being liquidated
token_name	VARCHAR	Name of the collateral token being liquidated
token_symbol	VARCHAR	Symbol of the collateral token being liquidated
token_decimals	INTEGER	Number of decimals of the collateral token
raw_amount_str	VARCHAR	Raw amount of collateral liquidated, in string to retain precision
amount_str	VARCHAR	Normalised amount of collateral liquidated, in string to retain precision
amount	FLOAT	Normalised amount of collateral liquidated
usd_amount	FLOAT	USD value of the collateral liquidated at the time of the transaction
usd_exchange_rate	FLOAT	Hourly USD exchange rate of the collateral token
repay_token_address	VARCHAR	Address of the token used to repay the debt. This is null for Compound V3 events
repay_token_name	VARCHAR	Name of the token used to repay the debt. This is null for Compound V3 events
repay_token_symbol	VARCHAR	Symbol of the token used to repay the debt. This is null for Compound V3 events
repay_token_decimals	INTEGER	Number of decimals of the repayment token. This is null for Compound V3 events
repay_raw_amount_str	VARCHAR	Raw amount of debt repaid, in string to retain precision. This is null for Compound V3 events
repay_amount_str	VARCHAR	Normalised amount of debt repaid, in string to retain precision. This is null for Compound V3 events
repay_amount	FLOAT	Normalised amount of debt repaid. This is null for Compound V3 events
repay_usd_amount	FLOAT	USD value of the debt repaid at the time of the transaction. This is null for Compound V3 events
extra_fields	VARIANT	Additional protocol-specific fields from the event
transaction_hash	VARCHAR	Transaction hash of the liquidation event
transaction_index	INTEGER	Index of the transaction in the block
transaction_from_address	VARCHAR	Address of the sender of the liquidation transaction
transaction_to_address	VARCHAR	Address of the recipient of the liquidation 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 liquidation event
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block
block_hash	VARCHAR	Hash of the block
unique_id	VARCHAR	Unique ID of the liquidation 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