Liquidations
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.
Table Columns
Unique Key: unique_id
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
Last updated
Was this helpful?