blast.blitz Table: dim_products Type: View
All available Blitz products, these are automatically added as they are released on chain.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | Also known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| TX_HASH | TEXT | Transaction 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. |
| PRODUCT_ID | TEXT | The unique id of each product. Evens are perp products and odds are spot products. |
| PRODUCT_TYPE | TEXT | The type of product, either spot or perpetual futures. |
| TICKER_ID | TEXT | Identifier of a ticker with delimiter to separate base/target. |
| SYMBOL | TEXT | The specific Blitz product symbol, if it is a futures product it will have a -PERP suffix. |
| NAME | TEXT | The name of the product |
| DIM_PRODUCTS_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. |