ERC20 Transfers

The ERC20 tokens transfers table contains the details of all transfer events of ERC20 tokens on the Avalanche network.

It includes information such as the sender and receiver addresses, the amount of tokens transferred, the transaction hash, and the block timestamp.

Query

Stablecoin transfers on Avalanche.

select
    date_trunc('month', block_timestamp) as date,
    token_symbol,
    sum(amount) as volume
from
    avalanche.assets.erc20_token_transfers
where
    1 = 1
    and block_timestamp >= '2022-01-01'
    and token_address IN (
        '0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664', -- Bridged USDC.e
        '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e', -- Circle USDC
        '0xc7198437980c041c805a1edcba50c1ce5db95118', -- Bridged USDT.e
        '0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7', -- Tether
        '0xd586e7f844cea2f87f50152665bcbc2c279d8d70', -- Bridged DAI.e
        '0x1c20e891bab6b1727d14da358fae2984ed9b59eb' -- TUSD
    )
    group by 1,2

Table Columns

Last updated