stellar.price Table: ez_asset_metadata Type: Base Table
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 |
|---|---|---|
| PROVIDER_ASSET_ID | TEXT | The unique identifier representing the asset. |
| ASSET_ISSUER | TEXT | The account address of the original asset issuer that created the asset. |
| ASSET_CODE | TEXT | The 4 or 12 character code representation of the asset on the network. |
| ASSET_ID | NUMBER | The Farm Hash encoding of Asset Code + Asset Issuer + Asset Type. This field is optimized for cross table joins since integer joins are less expensive than the original asset id components. |
| NAME | TEXT | The name of the asset. |
| SYMBOL | TEXT | The symbol of the asset. |
| DECIMALS | NUMBER | The number of decimals for the token contract on this EVM blockchain. |
| BLOCKCHAIN | TEXT | The Blockchain, Network, or Platform for this asset. |
| IS_NATIVE | BOOLEAN | A flag indicating assets native to this EVM blockchain. |
| IS_VERIFIED | BOOLEAN | A flag indicating if the asset has been verified by the Flipside team. |
| IS_DEPRECATED | BOOLEAN | A flag indicating if the asset is deprecated or no longer supported by the provider. |
| EZ_ASSET_METADATA_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |