ERC20 Transfers

We only use CEX USD prices to estimate the usd_amount. This has the benefit of excluding scam tokens, but some defi tokens might not be covered.

The ERC20 tokens transfers table contains the details of all transfer events of ERC20 tokens on the Ethereum blockchain.

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

Sample Query

Stablecoins transfer stats on Ethereum.

select
    date_trunc('week', block_timestamp) as date,
    token_symbol,
    count(distinct from_address) as senders,
    count(distinct to_address) as recipients,
    sum(amount) as transfer_volume
from ethereum.assets.erc20_token_transfers
where
    1 = 1
    and block_timestamp > '2022-01-01'
    and token_address in (
        '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',  -- circle
        '0x6b175474e89094c44da98b954eedeac495271d0f',  -- dai
        '0xdac17f958d2ee523a2206206994597c13d831ec7'  -- tether
    )
group by 1, 2
order by 1 desc

Table Columns

Last updated