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

​
Description

This table provides a comprehensive view of asset metadata for all tracked assets on the NEAR Protocol blockchain, combining both native NEAR token metadata and cross-chain bridged asset metadata. The table includes token addresses, symbols, names, decimal precision, and blockchain platform information, making it the primary table for asset identification and categorization. This easy view eliminates the need for complex joins and calculations, providing ready-to-use data for asset analysis and metadata enrichment across the NEAR ecosystem.

​
Key Use Cases

  • Asset identification and metadata enrichment for analytics
  • Cross-chain asset mapping and correlation analysis
  • Token categorization and platform-specific analysis
  • Asset discovery and coverage analysis
  • Multi-provider metadata validation and quality assessment
  • Cross-asset comparison and ecosystem mapping
  • Asset standardization and metadata quality improvement

​
Important Relationships

  • Combines data from price.dim_asset_metadata with enhanced categorization
  • Provides metadata for price.ez_prices_hourly with comprehensive asset context
  • Supports core.ez_token_transfers with enhanced token identification
  • Enables defi.ez_dex_swaps with token pair analysis
  • Powers defi.ez_bridge_activity with cross-chain asset mapping
  • Supports stats.ez_core_metrics_hourly with asset-based metrics
  • Provides foundation for all asset-related analytics and reporting

​
Commonly-used Fields

  • token_address: Essential for joining with transaction and price data
  • symbol and name: Critical for human-readable asset identification
  • blockchain: Important for cross-chain analysis and platform comparison
  • is_native: Essential for distinguishing native vs bridged assets
  • decimals: Important for accurate value calculations and decimal adjustment
  • asset_id: Useful for unique asset identification across systems
  • is_deprecated: Important for data quality assessment and asset lifecycle tracking

​
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.
TOKEN_IS_VERIFIEDBOOLEANBoolean flag indicating whether the token or price record is verified by Flipside’s crosschain curation process. Verified tokens are prioritized for analytics and are considered reliable for most use cases. Unverified tokens may be incomplete, deprecated, or experimental.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp at which the record was initially created and inserted into this table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe timestamp at which this record was last modified by an internal process.
EZ_ASSET_METADATA_IDTEXTA unique identifier for the record.