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. |