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

​
Description

This table provides enhanced asset metadata for tokens on the Sui blockchain, combining information from multiple sources with verification status and provider attribution. It serves as a curated reference for token identification, including symbols, names, decimals, and verification flags.

​
Key Use Cases

  • Token discovery and cataloging with verification status
  • Metadata lookups for analytics and reporting
  • Cross-referencing token information across multiple data providers
  • Filtering for verified vs. unverified tokens
  • Building token directories and reference data

​
Important Relationships

  • Provides enriched metadata for tokens referenced in core.dim_tokens
  • Used by analytics tables for token symbol and verification lookups
  • Complements raw token metadata with verification and provider context

​
Commonly-used Fields

  • token_address: Primary token identifier (coin type)
  • symbol: User-friendly token symbol
  • name: Full token name
  • decimals: Essential for decimal normalization
  • is_verified: Flag indicating Flipside verification status
  • provider: Data source for the metadata

​
Columns

Column NameData TypeDescription
TOKEN_ADDRESSTEXTThe full Move type identifier for the token, serving as the primary key.
Data type: String Example:
  • 0x2::sui::SUI
  • 0x5d4b302506645c37ff133b98c4b50a5ae14841659738d6d733d59d0d217a93bf::coin::COIN
Business Context:
  • Primary identifier for token lookups and joins.
  • Essential for linking to token activity across all tables.
  • Enables token-specific filtering and analysis. | | SYMBOL | TEXT | The token symbol, providing a short, human-readable identifier.
Data type: String Example:
  • SUI
  • USDC
  • CETUS
Business Context:
  • Used for user-friendly displays, reports, and dashboards.
  • Enables token filtering and grouping in analytics.
  • Supports cross-token comparisons. | | NAME | TEXT | The full name of the token.
Data type: String Example:
  • Sui
  • USD Coin
  • Cetus Protocol
Business Context:
  • Provides complete token identification for reports.
  • Used in token directories and reference materials.
  • Supports token discovery and cataloging. | | DECIMALS | NUMBER | The number of decimal places for the token.
Data type: Integer Example:
  • 9 (SUI)
  • 6 (USDC)
  • 18 (common for many tokens)
Business Context:
  • Critical for converting raw amounts to decimal-adjusted values.
  • Essential for financial calculations and value comparisons.
  • Enables accurate token amount normalization. | | BLOCKCHAIN | TEXT | The blockchain identifier, always “sui” for this schema.
Data type: String Example:
  • sui
Business Context:
  • Ensures consistency in cross-chain datasets.
  • Used for filtering in multi-blockchain queries.
  • Supports cross-chain analytics integration. | | IS_VERIFIED | BOOLEAN | Flag indicating if the token has been verified by the Flipside team.
Data type: Boolean Example:
  • true (verified token)
  • false (unverified token)
Business Context:
  • Essential for filtering trusted vs. unverified tokens.
  • Critical for security analysis and scam prevention.
  • Enables quality filtering for analytics and user protection. | | PROVIDER | TEXT | The data source or provider for this metadata record.
Data type: String Example:
  • flipside
  • on_chain
  • external_api
Business Context:
  • Indicates the origin and reliability of metadata.
  • Used for data quality assessment and source tracking.
  • Enables provider-based filtering and comparison. | | EZ_ASSET_METADATA_ID | TEXT | Unique primary key identifier for each row.
Data type: String Example:
  • 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef
Business Context:
  • Essential for data integrity.
  • Critical for join operations.
  • Enables precise data retrieval. | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the row was inserted.
Data type: Timestamp Example:
  • 2024-01-15 14:30:25.123456
Business Context:
  • Essential for data lineage tracking.
  • Critical for data freshness monitoring.
  • Enables pipeline performance analysis. | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the row was last modified.
Data type: Timestamp Example:
  • 2024-01-15 14:30:25.123456
Business Context:
  • Essential for update tracking.
  • Critical for data quality monitoring.
  • Enables change detection. |