Transfers

The solana.assets.transfers table holds a record of spl-tokens and native SOL transfers.

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

Column	Description	Example
from_address	Address where the token is being transferred from.	CyZuD7RPDcrqCGbNvLCyqk6Py9cEZTKmNKujfPi3ynDd
to_address	Address where the token is being transferred to.	CyZuD7RPDcrqCGbNvLCyqk6Py9cEZTKmNKujfPi3ynDd
token_acc_from	Token account sender address.	FjLVB8vNk2vPQXUWNJk7P8JYhco9jjVwpbsC7K8dwHDb
token_acc_to	Token account recipient address.	56pzXb1q2t4ZwgHC77pTELid2NYw8upu57McFK5j8Mj3
mint	Mint address of the token transferred.	So11111111111111111111111111111111111111112
decimals	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.	9
symbols	Symbol of the token transferred	SOL
raw_amount	Raw of amount of token (unnormalized) transferred.	12,500
raw_amount_str	Raw of amount of token (unnormalized) transferred, in string format.	12500
amount	Amount of token transferred, normalized.	0.0000125
amount_str	Amount of token transferred, normalized in string format.	0.0000125
usd_amount	USD value of the token amount transferred.	0.000261375
usd_exchange_rate	Price of the token at the time of transfer.	20.91
block_slot	Block slot of the transfer.	190,430,409
block_height	Block height of the transfer	173,371,181
block_timestamp	Block timestamp of the transfer.	2023-04-25 15:55:07
block_hash	Block hash of the transfer.	8cAnWkjiy7VENBH3h1pN2rFQJLJsujB87bTcfYJNnvtD
txn_id	Transaction ID of the transfer.	4iMB9gP6nf5atgDpofK9hUkBiqiLBxqtocMc64vHBwZvR8iJiuyBdcvaHBwCxk5W1szK9jFFo3XwsSZ2APdPo6Um
txn_index	Transaction Index of the transfer.	1,011
instruction_index	Transfer instruction index.	2
inner_instruction_index	Transfer inner instruction index.	0
program_name	Program name of the transfer transaction. Includes system and spl-token	spl-token
type	Includes transfer, transferChecked, setAuthority, transferWithSeed	transfer
transfer_type	Token transfer type. Includes sol_transfer, spl_token_transfer, token_account_transfer	spl_token_transfer
unique_id	Unique id of the transfer.	txn_id-4iMB9gP6nf5atgDpofK9hUkBiqiLBxqtocMc64vHBwZvR8iJiuyBdcvaHBwCxk5W1szK9jFFo3XwsSZ2APdPo6Um_i_index-2_ii_index-0