Skip to main content
Schema: bitcoin.price Table: ez_asset_metadata Type: View

​
Description

This table contains curated and prioritized asset metadata for Bitcoin and other assets, providing a simplified view of asset information with one unique asset per blockchain. Each row represents a single asset with its associated metadata including name, symbol, token address, and blockchain information. This easy view aggregates data from multiple price providers and applies curation logic to ensure data quality and consistency, making it the preferred table for asset identification and metadata lookup in most analytical scenarios.

​
Key Use Cases

  • Simplified asset identification and metadata lookup
  • Cross-blockchain asset analysis and comparison
  • Token address mapping and asset verification
  • Asset discovery and categorization for analytics
  • Price data integration with blockchain transaction analysis
  • Multi-chain asset tracking and relationship mapping
  • Curated asset information for reporting and dashboards

​
Important Relationships

  • Curated view of price.dim_asset_metadata with provider prioritization
  • Referenced by price.ez_prices_hourly for asset-specific price analysis
  • Supports core.fact_transactions for asset-specific transaction analysis
  • Used by core.fact_clustered_transfers for asset-based transfer categorization
  • Enables integration with stats.ez_core_metrics_hourly for asset-specific metrics
  • Provides curated asset context for all price-related analytics

​
Commonly-used Fields

  • symbol: Essential for asset recognition and market analysis
  • token_address: Critical for blockchain-specific asset identification
  • blockchain: Important for multi-chain asset categorization
  • name: Essential for human-readable asset identification
  • asset_id: Key for unique asset identification and relationship mapping
  • Curated fields ensure data quality and consistency across analyses

​
Columns

Column NameData TypeDescription
TOKEN_ADDRESSTEXTThe specific address representing the asset on a specific platform. This will be NULL if referring to a native asset.
ASSET_IDTEXTThe unique identifier representing the asset.
SYMBOLTEXTThe symbol of asset.
NAMETEXTThe name of asset.
DECIMALSNUMBERThe number of decimals for the asset. May be NULL.
BLOCKCHAINTEXTThe Blockchain, Network, or Platform for this asset.
IS_NATIVEBOOLEANA flag indicating assets native to the respective blockchain.
IS_DEPRECATEDBOOLEANA flag indicating if the asset is deprecated or no longer supported by the provider.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp (TIMESTAMP_NTZ, UTC) when this record was initially created and inserted into the table.
Example: 2024-06-01 12:34:56.000 | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp (TIMESTAMP_NTZ, UTC) when this record was last modified by an internal process. Example: 2024-06-01 12:35:00.000 | | EZ_ASSET_METADATA_ID | TEXT | A unique identifier (STRING or NUMBER) for the record, used as a primary key for this table. Not a blockchain-native field. Example: 123456789 |