Skip to main content
Schema: blast.blitz Table: ez_perp_trades Type: View Blitz perpetuals are derivative contracts on an underlying spot asset. On Blitz, all perpetual contracts trade against USDC.

​
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.
SYMBOLTEXTThe specific Blitz product symbol, if it is a futures product it will have a -PERP suffix.
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.
TRADE_TYPETEXTThey type of trade taken, long/short for perps or buy/sell for spot.
ORDER_TYPETEXTDecode from raw expiration number to binary then converted back to int from the most significant two bits:
0 ⇒ Default order, where it will attempt to take from the book and then become a resting limit order if there is quantity remaining 1 ⇒ Immediate-or-cancel order, which is the same as a default order except it doesn’t become a resting limit order 2 ⇒ Fill-or-kill order, which is the same as an IOC order except either the entire order has to be filled or none of it. 3 ⇒ Post-only order, where the order is not allowed to take from the book. An error is returned if the order would cross the bid ask spread. | | MARKET_REDUCE_FLAG | TEXT | A reduce-only is an order that will either close or reduce your position. The reduce-only flag can only be set on IOC or FOK order types. Send a reduce-only order by setting the 3rd most significant bit on the expiration field. | | EXPIRATION | TIMESTAMP_NTZ | Time after which the order should automatically be cancelled, as a timestamp in seconds after the unix epoch, converted to datetime. | | NONCE | NUMBER | Number used to differentiate between the same order multiple times, and a user trying to place an order with the same parameters twice. Represented as a string. | | IS_TAKER | BOOLEAN | Boolean representing if the trader was the taker or maker. | | PRICE_AMOUNT_UNADJ | NUMBER | The price amount that the trade was executed at. | | PRICE_AMOUNT | FLOAT | The price amount that the trade was executed at, decimal adjusted. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract. | | 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_USD | FLOAT | The size of the trade in USD. Base Delta multiplied by the price amount. | | FEE_AMOUNT_UNADJ | NUMBER | The fees on the trade. | | FEE_AMOUNT | FLOAT | The fees on the trade, decimal adjusted. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract. | | BASE_DELTA_AMOUNT_UNADJ | NUMBER | Represents the net change in the total quantity of orders at a particular price level, the sum of these across the same digest is equal to the amount. This is the first currency listed in the pair and acts as the reference point for the exchange rate, in this case the crypto asset trading against USDC. | | BASE_DELTA_AMOUNT | FLOAT | Represents the net change in the total quantity of orders at a particular price level, decimal adjusted. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract. The sum of these across the same digest is equal to the amount. This is the first currency listed in the pair and acts as the reference point for the exchange rate, in this case the crypto asset trading against USDC. | | QUOTE_DELTA_AMOUNT_UNADJ | NUMBER | A positive value is an increase in spread and a negative value is a decrease in spread. Quote is currency used to express the value of the base currency. It’s often the more well-known or stable currency in the pair. In this case, USDC. | | QUOTE_DELTA_AMOUNT | FLOAT | The net change in the best bid and best ask prices in the order book, decimal adjusted. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract. A positive value is an increase in spread and a negative value is a decrease in spread. Quote is currency used to express the value of the base currency. It’s often the more well-known or stable currency in the pair. In this case, USDC. | | EZ_PERP_TRADES_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. |