ERC20 Transfers

The ERC20 (BEP-20) tokens transfers table contains the details of all transfer events of ERC20 tokens on the BSC 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 BSC.

select
    date_trunc('month', block_timestamp) as date,
    token_symbol,
    sum(amount) as volume
from
    bsc.assets.erc20_token_transfers
where
    1 = 1
    and block_timestamp >= '2022-01-01'
    and token_address IN (
        '0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d', --  USDC
        '0x55d398326f99059ff775485246999027b3197955' --  BSC USD
    )
    group by 1,2

Table Columns

Last updated