| 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. |
| ORDERBOOK_SIDE | TEXT | Designates the bid or ask side of the orderbook price. |
| VOLUME | FLOAT | The quantity for each bid/ask order at the given price level. |
| PRICE | FLOAT | The price level for each bid/ask order. |
| ROUND_PRICE_0_01 | FLOAT | The price level for each bid/ask order, rounded to nearest cent. |
| ROUND_PRICE_0_1 | FLOAT | The price level for each bid/ask order, rounded to nearest ten cents. |
| ROUND_PRICE_1 | FLOAT | The price level for each bid/ask order, rounded to nearest dollar. |
| ROUND_PRICE_10 | FLOAT | The price level for each bid/ask order, rounded to nearest 10 dollars. |
| ROUND_PRICE_100 | FLOAT | The price level for each bid/ask order, rounded to nearest 100 dollars. |
| EZ_MARKET_DEPTH_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: |
