Skip to main content
Schema: sui.core Table: ez_transfers Type: Base Table

​
Description

This table provides user-friendly transfer analytics enriched with token metadata and normalized decimal amounts for the Sui blockchain. It simplifies the analysis of token movements by providing decimal-adjusted amounts, token symbols, and USD values, making it ideal for portfolio tracking, balance analysis, and transfer monitoring.

​
Data Coverage

Recent Coverage: This table contains data from January 2025 through the present, with 170.8M rows. Historical data prior to January 2025 is not available.

​
Key Use Cases

  • Token transfer tracking and wallet activity monitoring
  • Portfolio analysis and balance change tracking
  • Transfer volume analytics and flow visualization
  • User behavior analysis and cohort tracking
  • Token flow analysis between addresses
  • Wallet wealth tracking and value movement monitoring

​
Important Relationships

  • Sources data from balance changes in transaction processing
  • Joins token metadata from core.dim_tokens for symbol/decimals
  • Links to core.fact_transaction_blocks via tx_digest
  • Links to core.fact_checkpoints via checkpoint_number
  • Complementary to defi.ez_dex_swaps for comprehensive token flow analysis

​
Commonly-used Fields

  • tx_digest: Links to parent transaction
  • sender: Address sending tokens
  • receiver: Address receiving tokens
  • coin_type: Token type identifier
  • symbol: User-friendly token symbol
  • amount: Decimal-adjusted transfer amount
  • amount_usd: USD value of the transfer
  • block_timestamp: Primary field for time-series analysis

​
Columns

Column NameData TypeDescription
CHECKPOINT_NUMBERNUMBERSequential checkpoint identifier where this transfer occurred.
Data type: Integer Example:
  • 12345678
  • 98765432
Business Context:
  • Primary identifier for linking to checkpoint-level analysis.
  • Essential for checkpoint-based filtering and aggregation.
  • Enables correlation to consensus milestones. | | BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the transfer was finalized on the Sui blockchain.
Data type: Timestamp Example:
  • 2025-01-15 14:30:25.123456
Business Context:
  • Primary field for time-series analysis and temporal filtering of transfer activity.
  • Essential for trend analysis, volume calculations, and historical comparisons.
  • Enables time-based grouping and aggregation for analytics and reporting. | | TX_DIGEST | TEXT | 32-byte cryptographic transaction hash (Base58) identifying the transaction containing this transfer.
Data type: String Example:
  • 8vKzD3qFqE9yH2wN1xR5tB7aL4mP6sC3jG9kF1nV8xT2
Business Context:
  • Primary identifier for linking transfers to transaction context.
  • Essential for transaction verification and correlation.
  • Enables joining with other transaction-related tables. | | BALANCE_CHANGE_INDEX | NUMBER | Index identifying this specific balance change within the transaction.
Data type: Integer Example:
  • 0
  • 1
  • 5
Business Context:
  • Essential for uniquely identifying transfers within transactions.
  • Critical for ordering multiple transfers in a single transaction.
  • Enables precise transfer sequencing. | | SENDER | TEXT | The Sui address sending the tokens (null for mints).
Data type: String Example:
  • 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef
  • null (for token mints)
Business Context:
  • Essential for tracking token outflows and sender activity.
  • Critical for user behavior analysis and wallet monitoring.
  • Enables address-based filtering and sender analytics. | | RECEIVER | TEXT | The Sui address receiving the tokens (null for burns).
Data type: String Example:
  • 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef
  • null (for token burns)
Business Context:
  • Essential for tracking token inflows and receiver activity.
  • Critical for portfolio analysis and wallet wealth tracking.
  • Enables address-based filtering and receiver analytics. | | COIN_TYPE | TEXT | The full Move type identifier for the token being transferred.
Data type: String Example:
  • 0x2::sui::SUI
  • 0x5d4b302506645c37ff133b98c4b50a5ae14841659738d6d733d59d0d217a93bf::coin::COIN
Business Context:
  • Essential for token-specific filtering and analysis.
  • Critical for linking to token metadata and pricing.
  • Enables token flow tracking and token-specific analytics. | | SYMBOL | TEXT | User-friendly token symbol from token metadata.
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 and portfolio analysis. | | AMOUNT_RAW | NUMBER | The non-decimal adjusted amount of tokens transferred.
Data type: Integer Example:
  • 1000000000 (for 1 SUI with 9 decimals)
  • 1500000 (for 1.5 USDC with 6 decimals)
Business Context:
  • Essential for reconstructing exact on-chain transfer values.
  • Used for technical audits and precise calculations.
  • Enables accurate value tracking and verification. | | AMOUNT | FLOAT | The decimal-adjusted amount of tokens transferred.
Data type: Decimal Example:
  • 1.0 (for 1 SUI)
  • 1.5 (for 1.5 USDC)
  • 100.5 (for 100.5 tokens)
Business Context:
  • Used for financial analysis, reporting, and user-friendly analytics.
  • Enables value-based calculations and cross-token comparisons.
  • Supports dashboards and business intelligence. | | AMOUNT_USD | FLOAT | The USD value of the transferred tokens at the time of transfer.
Data type: Decimal Example:
  • 1.50 (for $1.50 worth of tokens)
  • 100.00 (for $100 worth of tokens)
  • null (if price data unavailable)
Business Context:
  • Used for financial analysis and reporting in USD terms.
  • Enables value-based analytics and aggregation in USD.
  • Supports portfolio tracking and wealth analysis. | | TOKEN_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. | | EZ_TRANSFERS_ID | TEXT | The unique primary key identifier for each row in the table, ensuring data integrity and uniqueness.
Data type: String Example:
  • 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef
Business Context:
  • Essential for data integrity and unique row identification.
  • Critical for join operations and data relationship management.
  • Enables precise data retrieval and referential integrity maintenance. | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp when the row was inserted into the table.
Data type: Timestamp Example:
  • 2025-01-15 14:30:25.123456
Business Context:
  • Essential for data lineage tracking and processing monitoring.
  • Critical for understanding data freshness and ingestion delays.
  • Enables data quality analysis and pipeline performance monitoring. | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp when the row was last modified.
Data type: Timestamp Example:
  • 2025-01-15 14:30:25.123456
Business Context:
  • Essential for data freshness analysis and update tracking.
  • Critical for understanding data modification patterns.
  • Enables data quality monitoring and change detection. |