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.
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