Skip to main content
Schema: blast.defi Table: ez_lending_liquidations Type: View This table contains transactions in which a borrower’s collateral asset is liquidated across ORBIT, JUICE AND INIT protocols. 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
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed. This field will not be unique in this table, as a given transaction can include multiple events.
CONTRACT_ADDRESSTEXTThe address interacted with for a given event.
EVENT_NAMETEXTThe decoded event name for a given event.
EVENT_INDEXNUMBEREvent number within a transaction.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of this transaction.
ORIGIN_FROM_ADDRESSTEXTThe from address of this transaction.
ORIGIN_TO_ADDRESSTEXTThe to address of this transaction.
PLATFORMTEXTThe specific protocol where lending event occurred.
LIQUIDATORTEXTThe address that initiated the liquidation call.
BORROWERTEXTAddress that initiated the borrow event.
PROTOCOL_MARKETTEXTThe protocol’s specific lending asset token, ie cWBTC or aETHUni.
COLLATERAL_TOKENTEXTThe asset provided as collateral, which can be liquidated.
COLLATERAL_TOKEN_SYMBOLTEXTThe symbol belonging to the address of the token
AMOUNT_UNADJFLOATThe non-decimal adjusted amount of tokens involved in the lending transaction.
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 belonging to the address of the token
EZ_LENDING_LIQUIDATIONS_IDTEXT
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.