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.

​
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

​
Table Columns

ColumnDescriptionTypeExample
from_addressAddress where the token is being transferred from.varcharCyZuD7RPDcrqCGbNvLCyqk6Py9cEZTKmNKujfPi3ynDd
to_addressAddress where the token is being transferred to.varcharCyZuD7RPDcrqCGbNvLCyqk6Py9cEZTKmNKujfPi3ynDd
token_acc_fromToken account sender address.varcharFjLVB8vNk2vPQXUWNJk7P8JYhco9jjVwpbsC7K8dwHDb
token_acc_toToken account recipient address.varchar56pzXb1q2t4ZwgHC77pTELid2NYw8upu57McFK5j8Mj3
mintMint address of the token transferred.varcharSo11111111111111111111111111111111111111112
decimalsThe 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.number9
symbolsSymbol of the token transferredvarcharSOL
raw_amountRaw of amount of token (unnormalized) transferred. Note that any fee withheld is not deducted from this amount.float12,500
raw_amount_strRaw of amount of token (unnormalized) transferred, in string format.varchar12500
amountAmount of token transferred, normalized.float0.0000125
amount_strAmount of token transferred, normalized in string format.varchar0.0000125
usd_amountUSD value of the token amount transferred.float0.000261375
usd_exchange_ratePrice of the token at the time of transfer.varchar20.91
block_slotBlock slot of the transfer.varchar190,430,409
block_heightBlock height of the transfernumber173,371,181
block_timestampBlock timestamp of the transfer.timestamp_ntz2023-04-25 15:55:07
block_hashBlock hash of the transfer.varchar8cAnWkjiy7VENBH3h1pN2rFQJLJsujB87bTcfYJNnvtD
txn_idTransaction ID of the transfer.varchar4iMB9gP6nf5atgDpofK9hUkBiqiLBxqtocMc64vHBwZvR8iJiuyBdcvaHBwCxk5W1szK9jFFo3XwsSZ2APdPo6Um
txn_indexTransaction Index of the transfer.number1,011
instruction_indexTransfer instruction index.number2
inner_instruction_indexTransfer inner instruction index.number0
program_nameProgram name of the transfer transaction. Includes system and spl-tokenvarcharspl-token
typeIncludes transfer, transferChecked, setAuthority, transferWithSeedvarchartransfer
transfer_typeToken transfer type. Includes sol_transfer, spl_token_transfer, token_account_transfervarcharspl_token_transfer
unique_idUnique id of the transfer.varchartxn_id-4iMB9gP6nf5atgDpofK9hUkBiqiLBxqtocMc64vHBwZvR8iJiuyBdcvaHBwCxk5W1szK9jFFo3XwsSZ2APdPo6Um_i_index-2_ii_index-0