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.
Table Columns
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
Last updated