ERC20 Transfers

The ERC20 tokens transfers table contains the details of all transfer events of ERC20 tokens on the Optimism 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 Optimism.

select
    date_trunc('month', block_timestamp) as date,
    token_symbol,
    sum(amount) as volume
from
    optimism.assets.erc20_token_transfers
where
    1 = 1
    and block_timestamp >= '2022-01-01'
    and token_address IN (
        '0x7f5c764cbc14f9669b88837ca1490cca17c31607', --  USDC
        '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58', --  USDT
        '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' --  DAI
    )
    group by 1,2

Table Columns

Last updated