sei.price Table: dim_asset_metadata Type: Base Table
A comprehensive dimensional table holding asset metadata and other relevant details pertaining to
each id, from multiple providers. This data set includes raw, non-transformed data coming directly
from the provider APIs and rows are not intended to be unique. As a result, there may be data
quality issues persisting in the APIs that flow through to this dimensional model. If you are
interested in using a curated data set instead, please utilize ez_asset_metadata.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| TOKEN_ADDRESS | TEXT | The specific address representing the asset on a specific platform. This will be NULL if referring to a native asset. The case (upper / lower) may or may not be specified within the dim_asset_metadata table, as this column is raw and not transformed, coming directly from the provider APIs. However, in the ez_ views, it will be lowercase by default for all EVMs. |
| ASSET_ID | TEXT | The unique identifier representing the asset. |
| SYMBOL | TEXT | The symbol of asset. |
| NAME | TEXT | The name of asset. |
| BLOCKCHAIN | TEXT | The Blockchain, Network, or Platform for this asset. |
| BLOCKCHAIN_ID | TEXT | The unique identifier of the Blockchain, Network, or Platform for this asset. |
| PROVIDER | TEXT | The provider or source of the data. |
| 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. |
| DIM_ASSET_METADATA_ID | TEXT | The unique identifier for each row in the table. |