Solana Token Transfers

The tokens_solana.transfers table contains token transfer events for tokens on the Solana blockchain indexed by Dune. This dataset encompasses:

SPL token transfers
token2022 token transfers
native SOL transfers (excluding staking-related transfers)

The transfers table aims to capture standard Solana token transfers. Some tokens may use non-standard transfer methods that might not be included.

Utility

The Solana transfers table provides a comprehensive view of token movement on Solana, enabling you to:

Track token flows between addresses
Analyze transaction volumes and patterns
Identify significant token movements
Monitor exchange and DeFi protocol activity on Solana

The table contains columns for block information, transfer details, token addresses, account addresses, and transaction metadata.

Table Schema

Column	Type	Description
`block_time`	`TIMESTAMP`	Block timestamp
`action`	`VARCHAR`	Transfer action type (transfer, mintTo, burn, etc.)
`amount`	`UINT256`	Raw transfer amount
`from_token_account`	`VARCHAR`	Source token account address
`to_token_account`	`VARCHAR`	Destination token account address
`token_mint_address`	`VARCHAR`	Token mint address
`symbol`	`VARCHAR`	Token symbol
`amount_display`	`DOUBLE`	Transfer amount in display units
`amount_usd`	`DOUBLE`	USD value of the transfer
`from_owner`	`VARCHAR`	Owner of the source token account
`to_owner`	`VARCHAR`	Owner of the destination token account
`token_version`	`VARCHAR`	Token program version (spl_token, token2022)
`tx_id`	`VARCHAR`	Transaction ID
`tx_signer`	`VARCHAR`	Transaction signer
`outer_executing_account`	`VARCHAR`	Outer executing program account
`block_date`	`DATE`	Block date
`block_slot`	`BIGINT`	Block slot number
`tx_index`	`INTEGER`	Transaction index within the block
`outer_instruction_index`	`INTEGER`	Outer instruction index
`inner_instruction_index`	`INTEGER`	Inner instruction index
`unique_instruction_key`	`DECIMAL`	Unique instruction identifier

Sample Queries

Query recent token transfers for a specific address This query returns the most recent token transfers (both incoming and outgoing) for a specified address:

SELECT
    block_time,
    action,
    CASE 
        WHEN from_owner = '7F9KJm6rcW2PAgUkRmqXhzMmUpxWcQcLFjarE4bwniqZ' THEN 'Outgoing'
        WHEN to_owner = '7F9KJm6rcW2PAgUkRmqXhzMmUpxWcQcLFjarE4bwniqZ' THEN 'Incoming'
    END AS direction,
    amount,
    amount_usd,
    token_mint_address,
    token_version
FROM tokens_solana.transfers
WHERE (from_owner = '7F9KJm6rcW2PAgUkRmqXhzMmUpxWcQcLFjarE4bwniqZ' OR to_owner = '7F9KJm6rcW2PAgUkRmqXhzMmUpxWcQcLFjarE4bwniqZ')
    AND block_time > now() - interval '30' day
ORDER BY block_time DESC
LIMIT 100

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Solana Token Transfers

Utility

Table Schema

Sample Queries

​Utility

​Table Schema

​Sample Queries

Utility

Table Schema

Sample Queries