Lending
Liquidations
Lending
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 |