Skip to main content
Schema: 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 NameData TypeDescription
BLOCKCHAINTEXTBLOCKCHAIN column
PLATFORMTEXTThe specific protocol where lending event occurred.
PROTOCOLTEXTPROTOCOL column
VERSIONTEXTVERSION column
BLOCK_NUMBERNUMBERThe block number at which the transaction is finalized.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe block timestamp of this transaction in UTC
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
CONTRACT_ADDRESSTEXTThe address interacted with for a given event.
PROTOCOL_MARKETTEXTThe protocol’s specific lending asset token, ie cWBTC or aETHUni.
LIQUIDATORTEXTThe address that initiated the liquidation call.
BORROWERTEXTAddress that initiated the borrow event.
COLLATERAL_TOKENTEXTThe asset provided as collateral, which can be liquidated.
COLLATERAL_TOKEN_SYMBOLTEXTThe symbol of the token associated with the lending action.
AMOUNT_RAWNUMBERAMOUNT_RAW column
AMOUNTFLOATThe decimal adjusted amount of tokens involved in the lending transaction, where available.
AMOUNT_USDFLOATThe value of the tokens in USD at the time of the lending transaction, where available.
DEBT_TOKENTEXTThe debt asset, which the user borrowed.
DEBT_TOKEN_SYMBOLTEXTThe symbol of the token associated with the lending action.
EZ_LENDING_LIQUIDATIONS_IDTEXTEZ_LENDING_LIQUIDATIONS_ID column
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.