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