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

​
Description

This table contains comprehensive asset metadata for Bitcoin and other assets from multiple price providers, providing detailed information about asset identifiers, names, symbols, and blockchain associations. Each row represents a single asset with its associated metadata including provider-specific identifiers, token addresses, and blockchain information. This dimension table serves as the foundation for price data analysis, enabling asset identification and categorization across different price providers and blockchain networks.

​
Key Use Cases

  • Asset identification and metadata lookup across multiple price providers
  • Cross-provider price data analysis and comparison
  • Asset categorization and blockchain-specific analysis
  • Token address mapping and asset verification
  • Price provider data quality assessment and validation
  • Asset discovery and metadata enrichment for analytics
  • Multi-chain asset tracking and relationship mapping

​
Important Relationships

  • Primary dimension table for asset identification in the price ecosystem
  • Referenced by price.fact_prices_ohlc_hourly for asset-specific price data
  • Supports price.ez_asset_metadata for curated asset information
  • Used by price.ez_prices_hourly for simplified price analysis
  • Enables integration with core.fact_transactions for asset-specific transaction analysis
  • Provides asset context for stats.ez_core_metrics_hourly aggregated metrics

​
Commonly-used Fields

  • asset_id: Essential for unique asset identification across providers
  • symbol: Core field for asset recognition and market analysis
  • token_address: Critical for blockchain-specific asset identification
  • blockchain: Important for multi-chain asset categorization
  • provider: Key for data source attribution and quality assessment
  • name: Essential for human-readable asset identification

​
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.
BLOCKCHAINTEXTThe Blockchain, Network, or Platform for this asset.
BLOCKCHAIN_IDTEXTThe unique identifier of the Blockchain, Network, or Platform for this asset.
PROVIDERTEXTThe provider or source of the data.
INSERTED_TIMESTAMPTIMESTAMP_NTZ
MODIFIED_TIMESTAMPTIMESTAMP_NTZ
DIM_ASSET_METADATA_IDTEXTA unique identifier (STRING or NUMBER) for the record, used as a primary key for this table. Not a blockchain-native field.
Example: 123456789 |