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

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

Last updated

Was this helpful?