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

Column NameDescriptionExample

from_address

Address where the token is being transferred from.

0x3d6fa1331e142504ba0b7965cd801c7f3b21b6c0

to_address

Address where the token is being transferred to.

0x3dfd23a6c5e8bbcfc9581d2e864a68feb6a076d3

token_address

Token address of the asset transferred.

0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48

token_name

Name of the asset transferred.

USD Coin

token_symbol

Token symbol of the asset transferred.

USDC

raw_amount

Amount of tokens moved (unnormalized).

100000000

raw_amount_str

Amount of tokens moved (unnormalized) in string

100000000

amount

Amount of token moved, normalized.

100

amount_str

Amount of token moved, normalized in string.

100

usd_amount

The amount of tokens moved, in $USD.

100.02

usd_exchange_rate

The exchange rate used to calculate the usd_value.

1.0002

transaction_from_address

The address of the sending party of this transaction.

0xd9fd8ae74d33dfc6883c01d2f5fb0dcb82384854

transaction_to_address

The address of the receiving party of this transaction (could be a contract address).

0x6ef7cc3891e4881bf6106f41e4732e4807868633

transaction_hash

Transaction hash that this transfer belongs to.

0x4d13ffc367a8d92a37ba210a49834e2e58f1135a44ff7c11d0dc7e19d5174156

log_index

The log index that corresponds to this transfer.

130

block_timestamp

The time when the block that contains this transaction was included on the blockchain.

2020-06-06 18:12:59.000

block_number

The block number that the corresponding transaction of this transfer belongs to.

10213689

block_hash

The block hash that the corresponding transaction of this transfer belongs to.

0x65c8c3bea7f3a45e8c1d84d454884d29afcf44967a6799d8044ea63487be92b1

unique_id

Unique id generated to each transfer. Includes transaction hash and log index.

txn-0x4d13ffc367a8d92a37ba210a49834e2e58f1135a44ff7c11d0dc7e19d5174156_log_index-130

Last updated