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_volumefrom sui.assets.fungible_transferswhere 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, 2order 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.
Was this page helpful?
Assistant
Responses are generated using AI and may contain mistakes.