Ez Asset Metadata

price.ez_asset_metadata

Schema: aleo.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. 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.
DECIMALS	NUMBER	The number of decimals for the asset. May be NULL.
BLOCKCHAIN	TEXT	The Blockchain, Network, or Platform for this asset.
IS_NATIVE	BOOLEAN	A flag indicating assets native to the respective blockchain.
IS_DEPRECATED	BOOLEAN	A flag indicating if the asset is deprecated or no longer supported by the provider.
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.
EZ_ASSET_METADATA_ID	TEXT	The unique identifier for each row in the table.