| HOUR | TIMESTAMP_NTZ | The hour in which the stats table data was pull and inserted into the table. |
| TICKER_ID | TEXT | Identifier of a ticker with delimiter to separate base/target. |
| PRODUCT_ID | VARIANT | The unique id of each product. Evens are perp products and odds are spot products. |
| SYMBOL | TEXT | The specific Nado product symbol, if it is a futures product it will have a -PERP suffix. |
| DISTINCT_SEQUENCER_BATCHES | NUMBER | The amount of sequencer transactions that included this product in the last hour. |
| DISTINCT_TRADER_COUNT | NUMBER | The distinct traders in the last hour, based on a distinct count of wallet addresses. |
| DISTINCT_SUBACCOUNT_COUNT | NUMBER | The distinct traders in the last hour, based on a distinct count of subaccount. |
| TRADE_COUNT | NUMBER | The total number of trades on Nado in the last hour. |
| AMOUNT_USD | FLOAT | The size of the trade in USD. Base Delta multiplied by the price amount. |
| 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 | 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 USDT0. |
| 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, USDT0. |
| BASE_VOLUME_24H | FLOAT | The 24 hour trading volume for the pair (unit in base). |
| QUOTE_VOLUME_24H | FLOAT | The 24 hour trading volume for the pair (unit in quote). |
| FUNDING_RATE | FLOAT | Current 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 | PRICE_CHANGE_PERCENT_24H column |
| PRODUCT_TYPE | TEXT | The type of product, either spot or perpetual futures. |
| QUOTE_CURRENCY | TEXT | Symbol of the target asset. |
| QUOTE_VOLUME | FLOAT | QUOTE_VOLUME column |
| EZ_MARKET_STATS_ID | TEXT | Primary key - unique identifier for each row ensuring data integrity. Format: Usually VARCHAR containing composite key generated using MD5 hash of the relevant columns. Example: MD5(blocknumber, txhash, trace_index) Usage: Deduplication in incremental loads Join operations for data quality checks Troubleshooting specific records Important: Implementation varies by table - check table-specific documentation. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flipside database. Format: TIMESTAMP_NTZ Use Cases: Data freshness monitoring Incremental processing markers Debugging data pipeline issues SLA tracking Query Example: |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. Format: TIMESTAMP_NTZ Triggers for Updates: Data corrections Enrichment additions Reprocessing for accuracy Schema migrations Monitoring Usage: |
