Token Transfers

The tokens.transfers table contains token transfer events across ERC20 tokens and native tokens for all EVM-compatible networks indexed on Dune. This dataset encompasses:

Transfer events for ERC20 tokens
ERC4626 fallback mint and burn transfers for supported vaults
WETH deposits and withdrawals
Native currency transfers
- Transaction value transfers
- Trace value transfers
- Gas used transfers

Some ERC20 tokens and native currencies have non-standard ways of being transferred and might not be included in the transfers table. You can check the logic for the transfers table here. The level of detail of the transfers table will vary by chain.

Utility

The transfers table provides a comprehensive view of token movement across networks, enabling you to:

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

Pricing Methodology

Important: The USD values in tokens.transfers are calculated using prices_external.hour, not the hybrid prices.hour table.

The amount_usd column in the transfers table uses Coinpaprika-sourced pricing data exclusively, which provides:

Stable, externally-validated pricing from centralized exchange aggregation
Protection against outliers that can occur in DEX-derived pricing algorithms
Consistent valuation across major tokens (~2,000 tokens with Coinpaprika coverage)

This approach prevents pricing anomalies from DEX trading activity that could negatively impact aggregations and analysis on the transfers table. Tokens without Coinpaprika coverage will not have USD values populated. For more details on Dune’s pricing methodology and the differences between pricing sources, see the Prices documentation.

Table Schema

Column	Type	Description
`unique_key`	`VARCHAR`	Surrogate key to identify unique row
`blockchain`	`VARCHAR`	Blockchain of the transfer
`block_month`	`DATE`	Block month (partition key)
`block_date`	`DATE`	Block date
`block_time`	`TIMESTAMP`	Block timestamp
`block_number`	`BIGINT`	Block number
`tx_hash`	`VARBINARY`	Transaction hash
`evt_index`	`BIGINT`	Log event index of the transfer
`trace_address`	`ARRAY(BIGINT)`	Trace address of the transfer
`token_standard`	`VARCHAR`	Token standard (ERC20, native)
`tx_from`	`VARBINARY`	Transaction sender
`tx_to`	`VARBINARY`	Transaction receiver
`tx_index`	`BIGINT`	Transaction index within the block
`from`	`VARBINARY`	Sender of the transfer
`to`	`VARBINARY`	Receiver of the transfer
`contract_address`	`VARBINARY`	Token contract address
`symbol`	`VARCHAR`	Token symbol
`amount_raw`	`UINT256`	Raw transfer amount before decimal adjustment
`amount`	`DOUBLE`	Transfer amount in display units
`price_usd`	`DOUBLE`	USD price used to calculate amount_usd (from Coinpaprika)
`amount_usd`	`DOUBLE`	USD value of the transfer

Network Coverage

Transfer data is available for the following EVM-compatible networks:

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,
    symbol,
    CASE 
        WHEN "from" = 0x5DD596C901987A2b28C38A9C1DfBf86fFFc15d77 THEN 'Outgoing'
        WHEN "to" = 0x5DD596C901987A2b28C38A9C1DfBf86fFFc15d77 THEN 'Incoming'
    END AS direction,
    amount,
    amount_usd
FROM tokens.transfers
WHERE ("from" = 0x5DD596C901987A2b28C38A9C1DfBf86fFFc15d77 OR "to" = 0x5DD596C901987A2b28C38A9C1DfBf86fFFc15d77)
    AND block_time > now() - interval '30' day
ORDER BY block_time DESC
LIMIT 100

Calculate daily transfer volume for a specific token This query calculates the daily transfer volume for a specific ERC20 token. Please be aware that token volumes are not necessarily indicative of anything. These metrics can be misleading if the token is not well-known or if there are a lot of small transfers. Token transfers can be mints, burns, transfers, flash loans and anything in between, trying to read into the data can lead to misleading results. Note: The amount_usd values are calculated using Coinpaprika pricing data (prices_external.hour) for stable, exchange-validated pricing.

SELECT
    block_date,
    COUNT(*) AS num_transfers,
    SUM(amount) AS total_amount,
    SUM(amount_usd) AS total_amount_usd
FROM tokens.transfers
WHERE contract_address = 0x1f9840a85d5af5bf1d1762f925bdaddc4201f984
    AND block_time > now() - interval '30' day
    and blockchain = 'ethereum'
GROUP BY 1
ORDER BY 1 DESC

Identify largest transfers in the last 24 hours This query finds the largest token transfers by USD value in the last 24 hours: Note: USD values are sourced from Coinpaprika pricing data for reliable valuation.

SELECT
    block_time,
    token_symbol,
    "from",
    "to",
    amount,
    amount_usd
FROM tokens.transfers
WHERE block_time > now() - interval '1' day
    AND amount_usd IS NOT NULL
ORDER BY amount_usd DESC
LIMIT 50

Find the circulating supply of a token over time This query calculates the circulating supply of a token over time by summing the amount of tokens in circulation at each time interval. Please be aware that this won’t work for all tokens with non-standard transfer or minting/burning mechanisms. tokens.transfers includes fallback ERC4626 share mint and burn rows for supported vaults, but other custom token mechanics may still require token-specific logic.

WITH tx AS (
    SELECT
        DATE_TRUNC('hour', evt_block_time) AS event_hour,
        value / 1e18 AS tokens_delta
    FROM erc20_ethereum.evt_transfer
    WHERE contract_address = 0x5bae9a5d67d1ca5b09b14c91935f635cfbf3b685
      AND "from" = 0x0000000000000000000000000000000000000000

    UNION ALL

    SELECT
        DATE_TRUNC('hour', evt_block_time) AS event_hour,
        -value / 1e18 AS tokens_delta
    FROM erc20_ethereum.evt_transfer
    WHERE contract_address = 0x5bae9a5d67d1ca5b09b14c91935f635cfbf3b685
      AND "to" = 0x0000000000000000000000000000000000000000
),
tx_hourly AS (
    SELECT
        event_hour,
        SUM(tokens_delta) AS net_tokens
    FROM tx
    GROUP BY event_hour
    ORDER BY event_hour DESC
)
SELECT
    event_hour,
    SUM(net_tokens) OVER (ORDER BY event_hour) AS circulating_supply
FROM tx_hourly
ORDER BY event_hour DESC;

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Utility

Pricing Methodology

Table Schema

Network Coverage

Sample Queries

​Utility

​Pricing Methodology

​Table Schema

​Network Coverage

​Sample Queries

Utility

Pricing Methodology

Table Schema

Network Coverage

Sample Queries