sui.defi Table: ez_bridge_activity Type: Base Table
Enhanced fact table providing comprehensive cross-chain bridge analytics by consolidating
bridge-related events from multiple protocols (Sui Bridge, Wormhole) into a unified dataset. Each
row represents a single cross-chain asset movement event enriched with protocol metadata, token
information, and USD pricing. Serves as the primary table for cross-chain DeFi analysis, bridge
protocol comparison, and capital flow tracking by normalizing bridge events across different
protocols into a consistent format. The table automatically applies decimal precision adjustments
and USD conversions, enabling direct comparison of bridge volumes and user activity across different
chains and token types. Includes complete transaction context, source/destination chain mapping, and
protocol identification to support comprehensive cross-chain analytics, security monitoring, and
risk assessment. Essential for DeFi dashboards, bridge protocol analysis, and multi-chain ecosystem
studies that require unified cross-chain data and standardized bridge event tracking.
Data Coverage: This table contains data from January 2025 - Present (142.5K 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’. |
| 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…’. |
| EVENT_INDEX | NUMBER | Zero-based index ordering events within a transaction. Ensures deterministic event ordering for sequence reconstruction and analytics. Example: 1. |
| BRIDGE_ADDRESS | TEXT | |
| PLATFORM | TEXT | |
| PROTOCOL | TEXT | |
| PROTOCOL_VERSION | TEXT | |
| DIRECTION | TEXT | |
| SOURCE_CHAIN | TEXT | |
| DESTINATION_CHAIN | TEXT | |
| SENDER | TEXT | |
| RECEIVER | TEXT | |
| COIN_TYPE | TEXT | |
| SYMBOL | TEXT | |
| AMOUNT_UNADJ | NUMBER | |
| AMOUNT | FLOAT | |
| AMOUNT_USD | FLOAT | |
| TOKEN_IS_VERIFIED | BOOLEAN | |
| EZ_BRIDGE_ACTIVITY_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |