Dim Asset Metadata

price.dim_asset_metadata

Schema: stellar.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
PROVIDER_ASSET_ID	TEXT	The unique identifier representing the asset.
ASSET_ISSUER	TEXT
ASSET_CODE	TEXT
NAME	TEXT	The name of the asset.
SYMBOL	TEXT	The symbol of the 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.
DIM_ASSET_METADATA_ID	TEXT	Unique primary key for the dimension table, used as the main identifier for each record.
INSERTED_TIMESTAMP	TIMESTAMP_NTZ	Timestamp when this record was inserted.
MODIFIED_TIMESTAMP	TIMESTAMP_NTZ	Timestamp when this record was last modified.