sui.core Table: ez_transfers Type: Base Table
Enhanced fact table providing user-friendly transfer analytics by joining core transfer data with
token metadata. Each row represents a single transfer event enriched with normalized amounts
(decimal-adjusted), token symbols, and human-readable identifiers. Serves as the primary table for
transfer analysis, portfolio tracking, and user-facing applications by converting raw blockchain
amounts into meaningful values. The amount_normalized field automatically applies decimal precision
adjustments based on token metadata, enabling direct comparison across different token types and
simplifying balance calculations. Includes all transfer metadata from the base fact table while
adding token symbols for easy identification and normalized amounts for accurate financial analysis.
Essential for dashboards, reporting tools, and analytics workflows that require human-readable token
information and precise decimal calculations.
Data Coverage: This table contains data from January 2025 - Present (170.8M rows). It
relies on the balance changes object returned from the RPC response, which is why historical
backfill is not available.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| CHECKPOINT_NUMBER | NUMBER | The sequential number of the checkpoint in which this record was finalized on the Sui blockchain. Checkpoints are consensus milestones that bundle and finalize multiple transactions, providing the primary unit of finality and recovery in Sui. Starts at 0 (genesis checkpoint) and increments by one for each new checkpoint. Used for time series analysis, transaction ordering, and measuring network throughput. Once a transaction is included in a checkpoint, it is permanently recorded and cannot be reverted. This dataset only includes checkpoints greater than or equal to 96605300. Example: 96605301. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The network-agreed timestamp (in milliseconds since Unix epoch) when the checkpoint containing this record was finalized by Sui consensus. Represents the authoritative time of transaction finality, as determined by validator signatures. Used for temporal analytics, trend analysis, and aligning on-chain activity with real-world time. Example: ‘2024-06-01 12:34:56.789’. |
| TX_DIGEST | TEXT | A 32-byte cryptographic hash (Base58-encoded) uniquely identifying the transaction’s contents and structure. Serves as the primary key for transaction lookup, integrity verification, and cross-model joins. Enables cryptographic proof of transaction inclusion and supports lineage tracing across all Sui analytics. Example: ‘6Qk8…9Xz’. |
| BALANCE_CHANGE_INDEX | NUMBER | Zero-based index ordering balance changes within a transaction. Tracks the sequence of balance modifications for accurate financial analysis and reconciliation. Example: 0. |
| TX_SUCCEEDED | BOOLEAN | Boolean flag indicating transaction execution outcome. true = success, false = error. Used for outcome analysis, error monitoring, and success rate tracking. Example: true. |
| TX_SENDER | TEXT | The 32-byte Sui address (hex with 0x prefix) that initiated and signed the transaction. Identifies the account responsible for the transaction and gas payment. Used for user activity tracking, wallet analytics, and authorization analysis. Example: ‘0xabc123…’. |
| SENDER | TEXT | Sui address (32-byte hex) representing the transaction or event sender. Used for authorization, security analysis, and user activity tracking. Example: ‘0xabc123…’. |
| RECEIVER | TEXT | Sui address (32-byte hex) representing the transaction or event receiver. Used for tracking destination addresses, transfer flows, and recipient analytics. In transfer contexts, this is the address receiving tokens or assets. Example: ‘0xdef456…’. |
| COIN_TYPE | TEXT | Fully qualified Move type identifier for coins/tokens. Format: {package}::{module}::{struct}. Example: 0x2::sui::SUI for native SUI token. Essential for DeFi analytics, token classification, and cross-asset analysis. |
| SYMBOL | TEXT | Short string symbol for the token (e.g., ‘SUI’, ‘USDC’). Used for user-friendly token identification, UI display, and analytics grouping. Example: ‘SUI’. |
| AMOUNT_RAW | NUMBER | Token quantity in the smallest unit (MIST for SUI). Integer value; 1 SUI = 1,000,000,000 MIST. Used for precise financial calculations, balance tracking, and token flow analysis. Example: 1000000000. |
| AMOUNT | FLOAT | Decimal-adjusted token amount calculated by dividing the raw amount by 10^decimals. Provides human-readable token quantities that can be directly compared across different token types. Essential for financial analysis, balance calculations, and user-facing applications where raw blockchain amounts need to be converted to meaningful values. Example: if amount is 1000000000 and decimals is 9, amount_normalized would be 1.0. |
| AMOUNT_USD | FLOAT | USD value of the amount at transaction time. |