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 |