Skip to main content
Schema: blast.blitz Table: ez_liquidations Type: View All Blitz liquidations. Once an account’s maintenance margin reaches $0, the account is eligible for liquidation. Liquidation events happen one by one, with the riskiest positions being liquidated first. Liquidations are based on the oracle price.

​
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.
DIGESTTEXTThe identifier for a specific trade, this can be split across two or more base deltas in order to fill the entire amount of the trade.
TRADERTEXTThe wallet address of the trader, there can be multiple subaccounts associated with a trader.
SUBACCOUNTTEXTIndependent Blitz account of trader with its own margin, balance, positions, and trades. Any wallet can open an arbitrary number of these. Risk is not carried over from subaccount to subaccount.
PRODUCT_IDNUMBERThe product to liquidate as well as the liquidation mode:
Perp Liquidation: Any valid perp product_id with is_encode_spread set to false. Spot Liquidation: Any valid spot product_id with is_encode_spread set to false. Spread Liquidation: If there are perp and spot positions in different directions, liquidate both at the same time. is_encode_spread must be set to true. If it is a spread liquidation this column will show the perp product_id, for both ids refer to the spread_product_ids array. | | HEALTH_GROUP | NUMBER | The spot / perp product pair of health group i where health_groups[i][0] is the spot product_id and health_groups[i][1] is the perp product_id. Additionally, it is possible for a health group to only have either a spot or perp product, in which case, the product that doesn’t exist is set to 0. | | HEALTH_GROUP_SYMBOL | TEXT | The token symbol represented by the specific health group. For example WBTC and BTC-PERP is BTC. | | AMOUNT_UNADJ | NUMBER | The total size of the trade in units of the asset being traded. | | AMOUNT | FLOAT | The total size of the trade in units of the asset being traded across one digest, decimal adjusted. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract. | | AMOUNT_QUOTE_UNADJ | NUMBER | To liquidate a position, there must be a payment (transfer) between the liquidator and the position holder. This done in the quote currency, USDC. Payments are signed as positive, meaning you received the USDC, or negative, meaning you paid. For perpetual liquidations, users should expect to see a (+) USDC payment. They will see a (-) USDC payment for borrowers since they need to pay the user for buying their borrow. | | AMOUNT_QUOTE | FLOAT | To liquidate a position, there must be a payment (transfer) between the liquidator and the position holder. This done in the quote currency, USDC. Payments are signed as positive, meaning you received the USDC, or negative, meaning you paid. For perpetual liquidations, users should expect to see a (+) USDC payment. They will see a (-) USDC payment for borrowers since they need to pay the user for buying their borrow. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract. | | IS_ENCODED_SPREAD | BOOLEAN | | | SPREAD_PRODUCT_IDS | ARRAY | Array of product_ids that have been decoded from binary. Only available when is_encode_spread is true. | | EZ_LIQUIDATIONS_ID | TEXT | The unique identifier for each row in the table. | | 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. |