Skip to main content
Schema: aurora.price Table: dim_asset_metadata Type: View 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 NameData TypeDescription
TOKEN_ADDRESSTEXTThe specific address representing the asset on a specific platform. This will be NULL if referring to a native asset.
ASSET_IDTEXTThe unique identifier representing the asset.
SYMBOLTEXTThe symbol of asset.
NAMETEXTThe name of asset.
BLOCKCHAINTEXTThe Blockchain, Network, or Platform for this asset.
BLOCKCHAIN_IDTEXTThe unique identifier of the Blockchain, Network, or Platform for this asset.
PROVIDERTEXTThe provider or source of the data.
INSERTED_TIMESTAMPTIMESTAMP_NTZ
MODIFIED_TIMESTAMPTIMESTAMP_NTZ
DIM_ASSET_METADATA_IDTEXTA uniquely generated identifier assigned by a surrogate key