ERC20 Transfers

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

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

Sample Query

Finding stablecoin movement volumes on Arbitrum. 

select
    date_trunc('month', block_timestamp) as date,
    token_symbol,
    sum(amount) as volume
from
    arbitrum.assets.erc20_token_transfers
where
    1 = 1
    and block_timestamp >= '2022-01-01'
    and token_address IN (
        '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8', -- Bridged USDC.e
        '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9', -- Bridged USDT
        '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1', -- DAI
        '0x4d15a3a2286d883af0aa1b3f21367843fac63e07' -- TUSD
    )
group by
    1,
    2

Table Columns

Last updated