monad.price Table: dim_asset_metadata Type: Dimension Table
What
This table provides comprehensive metadata for all assets (tokens and native assets) tracked in the price schema across EVM blockchains. It includes provider, asset identifiers, names, symbols, contract addresses, blockchain, and verification status.Key Use Cases
- Join price data to
Columns
| Column Name | Data Type | Description |
|---|---|---|
| ASSET_ID | TEXT | Unique identifier for the asset from the price provider. … |
| BLOCKCHAIN | TEXT | The blockchain network where the asset exists. Lowercase … |
| BLOCKCHAIN_ID | TEXT | The numeric or string identifier for the blockchain on wh… |
| DIM_ASSET_METADATA_ID | TEXT | Primary key - unique identifier for each row ensuring dat… |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. |