Skip to main content
Schema: near.core Table: dim_ft_contract_metadata Type: View

​
Description

This table contains comprehensive metadata for fungible token contracts on the NEAR Protocol blockchain, including token names, symbols, decimal precision, and cross-chain mapping information. The data covers both native NEAR tokens and cross-chain bridged assets, providing essential context for token identification, pricing, and value calculations. This dimension table supports all token-related analytics by providing standardized token information and enabling proper decimal adjustment for accurate value analysis.

​
Key Use Cases

  • Token identification and metadata enrichment for transfer analysis
  • Cross-chain token correlation and bridge activity analysis
  • Token pricing and market data integration
  • Decimal adjustment for accurate value calculations
  • Token supply and economics analysis
  • Multi-chain portfolio tracking and analysis
  • Token standard compliance and verification

​
Important Relationships

  • Enriches core.fact_token_transfers with token metadata and decimal information
  • Supports core.ez_token_transfers with enhanced token context
  • Enables defi.ez_dex_swaps with token pair identification and pricing
  • Powers defi.ez_bridge_activity with cross-chain token mapping
  • Supports price.ez_prices_hourly with token metadata for price analysis
  • Enables accurate USD value calculations across all token-related models

​
Commonly-used Fields

  • contract_address: Essential for joining with transfer and swap data
  • name and symbol: Critical for human-readable token identification
  • decimals: Important for accurate value calculations and decimal adjustment
  • source_chain: Essential for cross-chain analysis and bridge tracking
  • crosschain_token_contract: Important for multi-chain token correlation
  • asset_identifier: Useful for unique token identification across systems

​
Columns

Column NameData TypeDescription
ASSET_IDENTIFIERTEXTThe onchain representation of a token id, which may include source chain metadata if involved in a crosschain bridge event. Unique per token in the FT contract metadata table.
SOURCE_CHAINTEXTThe originating blockchain in a bridge transaction.
CROSSCHAIN_TOKEN_CONTRACTTEXTThe contract address of the token on the source chain, where applicable.
CONTRACT_ADDRESSTEXTThe address of the deployed contract for the token, nft, or other smart contract.
NAMETEXTThe name of the asset.
SYMBOLTEXTToken symbol (e.g., ‘wNEAR’, ‘SWEAT’). This field contains the abbreviated identifier for the token as commonly used in trading pairs, price feeds, and user interfaces. Token symbols are typically 2-6 characters long and provide a quick way to identify tokens without using their full contract addresses. Examples include ‘NEAR’ for the native token, ‘wNEAR’ for wrapped NEAR, and ‘USDC’ for USD Coin.
DECIMALSNUMBERNumber of decimal places for the token. This field specifies the precision of the token, indicating how many decimal places should be used when converting from raw on-chain amounts to human-readable values. For example, NEAR has 24 decimals, so 1 NEAR = 1e24 raw units. Most ERC-20 tokens use 18 decimals, while some tokens may use different precision based on their design requirements.
DIM_FT_CONTRACT_METADATA_IDTEXTA unique identifier for the record.
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.