Skip to main content
Schema: blast.blitz Table: ez_market_stats Type: View Orderbook level market stats based on a combination of on-chain data and data from Blitz’s ticker V2 API which includes 24-hour pricing and volume information on each market pair available on Blitz.

​
Columns

Column NameData TypeDescription
HOURTIMESTAMP_NTZThe hour in which the stats table data was pull and inserted into the table.
TICKER_IDTEXTIdentifier of a ticker with delimiter to separate base/target.
PRODUCT_IDTEXTThe unique id of each product. Evens are perp products and odds are spot products.
SYMBOLTEXTThe specific Blitz product symbol, if it is a futures product it will have a -PERP suffix.
DISTINCT_SEQUENCER_BATCHESNUMBERThe amount of sequencer transactions that included this product in the last hour.
DISTINCT_TRADER_COUNTNUMBERThe distinct traders in the last hour, based on a distinct count of wallet addresses.
DISTINCT_SUBACCOUNT_COUNTNUMBERThe distinct traders in the last hour, based on a distinct count of subaccount.
TRADE_COUNTNUMBERThe total number of trades on Blitz in the last hour.
AMOUNT_USDFLOATThe size of the trade in USD. Base Delta multiplied by the price amount.
FEE_AMOUNTFLOATThe fees on the trade, decimal adjusted. All amounts and prices are adjusted 18 decimals points regardless of underlying asset contract.
BASE_DELTA_AMOUNTFLOATRepresents 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_AMOUNTFLOATThe 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.
BASE_VOLUME_24HFLOATThe 24 hour trading volume for the pair (unit in base).
QUOTE_VOLUME_24HFLOATThe 24 hour trading volume for the pair (unit in quote).
FUNDING_RATEFLOATCurrent 24hr funding rate. Can compute hourly funding rate dividing by 24.
A funding rate is a mechanism used to ensure that the price of a perp contract tracks the underlying asset’s price as closely as possible. Positive funding rates reflect the perpetual trading at a premium to the underlying asset’s price. | | INDEX_PRICE | FLOAT | Last calculated index price for underlying of contract. | | LAST_PRICE | FLOAT | Last transacted price of base currency based on given quote currency. | | MARK_PRICE | FLOAT | The calculated fair value of the contract, independent of the last traded price on the specific exchange. | | NEXT_FUNDING_RATE_TIMESTAMP | TIMESTAMP_NTZ | Timestamp of the next funding rate change, specific to hour the data was pulled from the API. | | OPEN_INTEREST | FLOAT | The open interest of the contract for the hour that the data was pulled. Open interest (OI) refers to the total number of outstanding derivative contracts (e.g., futures or options) that are currently held by market participants and have not yet been settled | | OPEN_INTEREST_USD | FLOAT | The open interest of the contract for the hour that the data was pulled, denominated in USD. Open interest (OI) refers to the total number of outstanding derivative contracts (e.g., futures or options) that are currently held by market participants and have not yet been settled | | PRICE_CHANGE_PERCENT_24H | FLOAT | | | PRODUCT_TYPE | TEXT | The type of product, either spot or perpetual futures. | | QUOTE_CURRENCY | TEXT | Symbol of the target asset. | | QUOTE_VOLUME | FLOAT | | | EZ_MARKET_STATS_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. |