Fungible Transfers

Table Details

Property	Value
Table Name	`sui.assets.fungible_transfers`
Table Status	Production-Ready
Unique Key	`checkpoint_timestamp::date`, `checkpoint_digest`, `unique_id`
Clustering Key(s)	`checkpoint_timestamp::date, coin_type`
Search Optimization	`checkpoint_digest`, `coin_type`, `from_address`, `to_address`

Token transfers provide additional info over a plain credit/debit dataset, Allium has painstakingly reconstructed a token transfers dataset to enable more use cases such as tracking fund movements across Sui. We are continuously working to increase coverage for all Sui balance changes.

The fungible transfers table contains the details of all transfer events of fungible tokens on the Sui blockchain. Users of Sui fungible transfer data need to be aware that transfer data is reconstructed from events, transactions and balance changes recorded on the blockchain. Our team continuously works to expand and improve coverage through case-by-case analysis. We strive to ensure comprehensive matching of all balance changes. If you discover any gaps in coverage, please don’t hesitate to reach out to our team for support. It includes information such as the sender and receiver addresses, the amount of tokens transferred, the transaction block digest, and the checkpoint timestamp.

Transfer Types

Sui fungible transfers are categorized into types to help distinguish between regular value transfers, protocol-specific operations (like staking or DEX trades), and system-level transfers (like gas fees). Each transfer type provides insight into different aspects of on-chain activity.

Transfer Type	Description
gas_fee	Transaction gas fees in sui
claim	Tokens claimed from airdrops, rewards, or other distribution mechanisms (mainly wave wallet ocean game claims)
virtual_transfer	Token movements derived from DEX swaps and liquidity pool interactions, representing the flow of tokens between pools and traders
value_transfer	Standard token transfers between addresses
staking	Tokens transferred for staking purposes
unstaking	Tokens withdrawn from staking positions
commission	Fee payments or commission transfers
initial_mint	Initial Sui mint

Sample Query

Stablecoins value transfer (1 to 1 transfer) stats on Sui.

select
    date_trunc('week', checkpoint_timestamp) as date,
    coin_type,
    count(distinct from_address) as senders,
    count(distinct to_address) as recipients,
    sum(usd_amount) as transfer_volume
from sui.assets.fungible_transfers
where
    1 = 1
    and checkpoint_timestamp >= '2025-01-01'
    and coin_type in (
        '0x5d4b302506645c37ff133b98c4b50a5ae14841659738d6d733d59d0d217a93bf::coin::COIN',  -- usdc
        '0xc060006111016b8a020ad5b33834984a437aaa7d3c74c18e09a95d48aceab08c::coin::COIN'  -- usdt
    )
    and transfer_type = 'value_transfer'
group by 1, 2
order by 1 desc

Table Columns

Column Name	Data Type	Description
from_address	VARCHAR(16777216)	Address where the token is being transferred from
to_address	VARCHAR(16777216)	Address where the token is being transferred to
coin_type	VARCHAR(16777216)	The type of the coin being transferred
coin_name	VARCHAR(16777216)	Full name of this coin. Short alias for token_name in Aptos/Cosmos-style tables.
coin_symbol	VARCHAR(16777216)	Ticker symbol of this coin. Short alias for token_symbol in Aptos/Cosmos-style tables.
transfer_type	VARCHAR(16777216)	The type of transfer (see Transfer Types table above)
raw_amount_str	VARCHAR(16777216)	Amount of tokens moved (unnormalized) in string
raw_amount	FLOAT	Amount of tokens moved (unnormalized)
amount_str	VARCHAR(16777216)	Amount of token moved, normalized in string
amount	FLOAT	Amount of token moved, normalized
usd_amount	FLOAT	The amount of tokens moved, in $USD
usd_exchange_rate	FLOAT	The exchange rate used to calculate the usd_value
tx_sender	VARCHAR(16777216)	The address of the sending party of this transaction
tx_success	BOOLEAN	Boolean indicating if the transaction was successful
unique_id	VARCHAR(16777216)	Unique identifier for the transfer
transaction_block_digest	VARCHAR(16777216)	The digest of the transaction block containing this transfer
checkpoint_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the checkpoint when this transfer was processed
checkpoint_sequence	NUMBER(38,0)	Sequence number of the checkpoint
checkpoint_digest	VARCHAR(16777216)	Digest of the checkpoint
_created_at	TIMESTAMP_NTZ(9)	Timestamp when this record was created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when this record was last updated
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full data refresh.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

Table Details

Transfer Types

Sample Query

Table Columns

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Skeleton group placeholder 4

​Table Details

​Transfer Types

​Sample Query

​Table Columns

Table Details

Transfer Types

Sample Query

Table Columns