crosschain.defi Table: ez_lending_liquidations Type: View
What
A comprehensive table that contains all blockchain and platform specific liquidations. This table contains liquidation events in which a borrower’s collateral asset is liquidated across Arbitrum, Avalanche, Base, BSC, Gnosis, Ethereum, Optimism, Polygon, Solana and Aptos. Liquidations occur when a borrower’s health factor goes below 1 due to their collateral value not properly covering their loan/debt value. This might happen when the collateral decreases in value or the borrowed debt increases in value against each other. This collateral vs loan value ratio is shown in the health factor. In a liquidation, up to 50% of a borrower’s debt is repaid and that value + liquidation fee is taken from the collateral available, so after a liquidation the amount liquidated from one’s debt is repaid.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | BLOCKCHAIN column |
| PLATFORM | TEXT | The specific protocol where lending event occurred. |
| PROTOCOL | TEXT | PROTOCOL column |
| VERSION | TEXT | VERSION column |
| BLOCK_NUMBER | NUMBER | The block number at which the transaction is finalized. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this transaction in UTC |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| CONTRACT_ADDRESS | TEXT | The address interacted with for a given event. |
| PROTOCOL_MARKET | TEXT | The protocol’s specific lending asset token, ie cWBTC or aETHUni. |
| LIQUIDATOR | TEXT | The address that initiated the liquidation call. |
| BORROWER | TEXT | Address that initiated the borrow event. |
| COLLATERAL_TOKEN | TEXT | The asset provided as collateral, which can be liquidated. |
| COLLATERAL_TOKEN_SYMBOL | TEXT | The symbol of the token associated with the lending action. |
| AMOUNT_RAW | NUMBER | AMOUNT_RAW column |
| AMOUNT | FLOAT | The decimal adjusted amount of tokens involved in the lending transaction, where available. |
| AMOUNT_USD | FLOAT | The value of the tokens in USD at the time of the lending transaction, where available. |
| DEBT_TOKEN | TEXT | The debt asset, which the user borrowed. |
| DEBT_TOKEN_SYMBOL | TEXT | The symbol of the token associated with the lending action. |
| EZ_LENDING_LIQUIDATIONS_ID | TEXT | EZ_LENDING_LIQUIDATIONS_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |