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

Last updated