ERC20 Transfers

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.

Query

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

Table Columns

Column Name
Description
Example

from_address

Address where the token is being transferred from.

0xfc21d3a2465a220c5a5a35e99e423c612f76ae83

to_address

Address where the token is being transferred to.

0x1205f31718499dbf1fca446663b532ef87481fe1

token_address

Token address of the asset transferred.

0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e

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

261,294,144

raw_amount_str

Amount of tokens moved (unnormalized) in string

261294144

amount

Amount of token moved, normalized.

261.294144

amount_str

Amount of token moved, normalized in string.

261.294144

usd_amount

The amount of tokens moved, in $USD.

261.2680146

usd_exchange_rate

The exchange rate used to calculate the usd_value.

0.9999

transaction_from_address

The address of the sending party of this transaction.

0xfc21d3a2465a220c5a5a35e99e423c612f76ae83

transaction_to_address

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

0x45a01e4e04f14f7a4a6702c74187c5f6222033cd

transaction_hash

Transaction hash that this transfer belongs to.

0xce700b2d6a237aff56d2f75d06da7a40dcc31558f516976bb3feeecab0c72985

log_index

The log index that corresponds to this transfer.

16

block_timestamp

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

2023-06-07 05:19:43

block_number

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

31,011,871

block_hash

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

0xb583320cc68ffaa7245352dc31afb596667ee69213622ce2567490741acedb92

unique_id

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

txn-0xce700b2d6a237aff56d2f75d06da7a40dcc31558f516976bb3feeecab0c72985_log_index-16

Last updated