Token Transfers

Our Avalanche assets schema currently includes AVAX and ERC20 Token Transfers.

avalanche.assets.avax_erc20_token_transfers contains transfers for both assets type.

Note that native AVAX uses null address 0x0000000000000000000000000000000000000000 as token_address.

Table Columns

Column Name
Description
Example

transfer_type

Transfer Type (ERC20 or AVAX).

ERC20

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

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

erc20_log_index

ERC20 Transfer Log Index.

16

avax_call_type

AVAX Traces Call Type.

avax_transfer_type

AVAX Transfer Type for Transfers.

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