Token Transfers
Last updated
Last updated
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.
| 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