Skip to main content
Schema: blast.blitz Table: ez_edge_trades Type: View All edge trades paired with the associated trader/subaccount.

​
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.
EDGE_EVENT_INDEXNUMBEREvent number within a transaction.
USER_EVENT_INDEXNUMBEREvent number within a transaction.
EDGE_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.
USER_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.
SYMBOLTEXTThe specific Blitz product symbol, if it is a futures product it will have a -PERP suffix.
EDGE_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. | | USER_ORDER_TYPE | TEXT | Decode 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. | | EDGE_TRADE_TYPE | TEXT | They type of trade taken, long/short for perps or buy/sell for spot. | | USER_TRADE_TYPE | TEXT | They type of trade taken, long/short for perps or buy/sell for spot. | | EDGE_IS_TAKER | BOOLEAN | Boolean representing if the trader was the taker or maker. | | USER_IS_TAKER | BOOLEAN | Boolean representing if the trader was the taker or maker. | | EDGE_PRICE_AMOUNT_UNADJ | NUMBER | The price amount that the trade was executed at. | | USER_PRICE_AMOUNT_UNADJ | NUMBER | The price amount that the trade was executed at. | | EDGE_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. | | USER_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. | | EDGE_AMOUNT_UNADJ | NUMBER | The total size of the trade in units of the asset being traded. | | USER_AMOUNT_UNADJ | NUMBER | The total size of the trade in units of the asset being traded. | | EDGE_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. | | USER_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. | | EDGE_AMOUNT_USD | FLOAT | The size of the trade in USD. Base Delta multiplied by the price amount. | | USER_AMOUNT_USD | FLOAT | The size of the trade in USD. Base Delta multiplied by the price amount. | | EDGE_FEE_AMOUNT_UNADJ | NUMBER | The fees on the trade. | | USER_FEE_AMOUNT_UNADJ | NUMBER | The fees on the trade. | | EDGE_FEE_AMOUNT | FLOAT | The fees on the trade, decimal adjusted. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract. | | USER_FEE_AMOUNT | FLOAT | The fees on the trade, decimal adjusted. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract. | | EDGE_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. | | USER_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. | | EDGE_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. | | USER_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. | | EDGE_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. | | USER_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. | | EDGE_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. | | USER_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_EDGE_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. |