Ez Asset Metadata

price.ez_asset_metadata

Schema: aurora.price Table: ez_asset_metadata Type: View

A convenience table holding prioritized asset metadata and other relevant details pertaining to each token_address and native asset. This data set is highly curated and contains metadata for one unique asset per blockchain.

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.
ASSET_ID	TEXT	The unique identifier representing the asset.
SYMBOL	TEXT	The symbol of asset.
NAME	TEXT	The name of asset.
DECIMALS	NUMBER	The number of decimals for the asset. May be NULL.
BLOCKCHAIN	TEXT	The Blockchain, Network, or Platform for this asset.
IS_DEPRECATED	BOOLEAN	A flag indicating if the asset is deprecated or no longer supported by the provider.
IS_NATIVE	BOOLEAN	A flag indicating assets native to the respective blockchain.
INSERTED_TIMESTAMP	TIMESTAMP_NTZ	The timestamp at which the record was initially created and inserted into this table.
MODIFIED_TIMESTAMP	TIMESTAMP_NTZ	The timestamp at which this record was last modified by an internal process.
EZ_ASSET_METADATA_ID	TEXT	A uniquely generated identifier assigned by a surrogate key