solana.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 |
|---|---|---|
| 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_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 timestamp when this transaction record was first inserted into the analytics database. Used for data freshness tracking and incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when this transaction record was last updated in the analytics database. Used for tracking updates and supporting incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process. |
| EZ_ASSET_METADATA_ID | TEXT | A unique, stable identifier for each record in this table. The primary key (PK) ensures that every row is uniquely identifiable and supports efficient joins, lookups, and data integrity across models. The PK may be a natural key (such as a blockchain transaction hash) or a surrogate key generated from one or more fields, depending on the table’s structure and requirements. |