Transfers

The solana.assets.transfers table holds a record of spl-tokens (both legacy and token2022) and native SOL transfers. If you require tx-level detail for records in this table, see here for more info.

Table Details

Property	Value
Table Name	`solana.assets.transfers`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `txn_id`, `unique_id`

Sample Query

Finding the volume of USDC transferred on Solana Network.

select
    date(block_timestamp) as date,
    sum(amount) as USDC,
    count(distinct from_address) as senders
from solana.assets.transfers
where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC Mint
    group by 1
    order by 1 desc

Invisible SOL transfers

There can be movement of native SOL without an explicit transfer instruction. In those case, there is no definitive way to extract the point-to-point record of the transfer.
More details are explained here
If you intend to sum up transfers within a transaction for reconciliation, balance changes would be more suitable.

Token2022 support

Parsed token2022 instructions can be found in the raw tables solana.raw.instructions / solana.raw.inner_instructions
We parse token2022 spl transfers and include them as part of solana.assets.transfers
For other function-specific details of other token2022 functions, they can be parsed upon request

Transfer types

There are multiple ways to transfer assets in solana - the type of transfer can be identified from a combination of the program_name, type and transfer_type columns.

program_name	type	transfer_type	description
spl-token	burn	spl_token_transfer	SPL token burn
spl-token	burnChecked	spl_token_transfer	SPL token burn
spl-token	closeAccount	account_closure_sol_balance_transfer	Native SOL from rent returned as a result of account closure
spl-token	mintTo	spl_token_transfer	SPL token mint
spl-token	mintToChecked	spl_token_transfer	SPL token mint
spl-token	setAuthority	token_account_transfer	SPL token transfer by changing ownership of account to receiving party
spl-token	transfer	spl_token_transfer	SPL token transfer, direct from 1 token account to another
spl-token	transferChecked	spl_token_transfer	SPL token transfer, direct from 1 token account to another
spl-token	transferCheckedWithFee	spl_token_transfer	SPL token transfer, direct from 1 token account to another
system	createAccount	sol_transfer	Native SOL transferred when funding a new account
system	createAccountWithSeed	sol_transfer	Native SOL transferred when funding a new account
system	transfer	sol_transfer	Native SOL transfer, direct from 1 party to another
system	transferWithSeed	sol_transfer	Native SOL transfer, direct from 1 party to another

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.
token_acc_from	VARCHAR(16777216)	Token account sender address.
token_acc_to	VARCHAR(16777216)	Token account recipient address.
mint	VARCHAR(16777216)	Mint address of the token transferred.
decimals	NUMBER(38,0)	The number of decimal points the token amounts are represented in. This is used to calculate the normalized amount of a token by taking the raw amount divided by 10^decimal_points.
token_name	VARCHAR(16777216)	Full name of the token (e.g. “USD Coin”, “Wrapped Ether”).
symbol	VARCHAR(16777216)	Ticker symbol of this token or asset. Short alias for `token_symbol` used in tables that preserve the original blockchain field naming convention.
raw_amount	FLOAT	Raw of amount of token (unnormalized) transferred. Note that any fee withheld is not deducted from this amount.
raw_amount_str	VARCHAR(16777216)	Raw of amount of token (unnormalized) transferred, in string format.
amount	FLOAT	Amount of token transferred, normalized.
amount_str	VARCHAR(16777216)	Amount of token transferred, normalized in string format.
usd_amount	FLOAT	USD value of the token amount transferred.
usd_exchange_rate	VARCHAR(16777216)	Price of the token at the time of transfer.
is_dex_price	BOOLEAN	Whether the USD price used for this record was sourced from Solana DEX data rather than an external market feed (e.g. CoinGecko).
signer	VARCHAR(16777216)	Primary signing account (fee payer) of the transaction. This is the account that authorized the transaction and paid transaction fees.
block_slot	NUMBER(38,0)	Block slot of the transfer.
block_height	NUMBER(38,0)	Block height of the transfer
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the transfer.
block_hash	VARCHAR(16777216)	Block hash of the transfer.
txn_id	VARCHAR(16777216)	Transaction ID of the transfer.
txn_index	NUMBER(38,0)	Transaction Index of the transfer.
instruction_index	NUMBER(38,0)	Transfer instruction index.
inner_instruction_index	NUMBER(38,0)	Transfer inner instruction index.
program_name	VARCHAR(16777216)	Program name of the transfer transaction. Includes system and spl-token
program_id	VARCHAR(16777216)	Base58-encoded public key of the Solana program that processed this instruction (e.g. `TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA` for SPL Token).
type	VARCHAR(16777216)	Instruction type. Includes transfer, transferChecked, transferCheckedWithFee, transferWithSeed, createAccount, createAccountWithSeed, closeAccount, setAuthority, mintTo, mintToChecked, burn, burnChecked. See Transfer types for how it combines with `program_name` and `transfer_type`.
transfer_type	VARCHAR(16777216)	Token transfer type. Includes sol_transfer, spl_token_transfer, token_account_transfer, account_closure_sol_balance_transfer
outer_program_id	VARCHAR(16777216)	Program ID of the outermost instruction that invoked this inner instruction on Solana
unique_id	VARCHAR(16777216)	Unique id of the transfer.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Sample Query

Invisible SOL transfers

Token2022 support

Transfer types

Table Columns

​Table Details

​Sample Query

​Invisible SOL transfers

​Token2022 support

​Transfer types

​Table Columns

Table Details

Sample Query

Invisible SOL transfers

Token2022 support

Transfer types

Table Columns