Token Transfers
Last updated
Last updated
Our Base assets schema currently includes ETH, ERC20, ERC721, and ERC1155 Token Transfers.
Note that native ETH on Base uses the null address 0x0000000000000000000000000000000000000000
as token_address.
base.assets.eth_erc20_token_transfers
combines both ETH and ERC20 transfers on Base.
Column Name | Description |
---|---|
transfer_type
Transfer Type (ERC20 or ETH).
from_address
Address where the token is being transferred from.
to_address
Address where the token is being transferred to.
token_address
Token address of the asset transferred.
token_name
Name of the asset transferred.
token_symbol
Token symbol of the asset transferred.
raw_amount
Amount of tokens moved (unnormalized).
raw_amount_str
Amount of tokens moved (unnormalized) in string
amount
Amount of token moved, normalized.
amount_str
Amount of token moved, normalized in string.
usd_amount
The amount of tokens moved, in $USD.
transaction_from_address
The address of the sending party of this transaction.
transaction_to_address
The address of the receiving party of this transaction (could be a contract address).
transaction_hash
Transaction hash that this transfer belongs to.
erc20_log_index
ERC20 Transfer Log Index.
eth_call_type
ETH Traces Call Type.
eth_transfer_type
ETH Transfer Type for Transfers.
block_timestamp
The time when the block that contains this transaction was included on the blockchain.
block_number
The block number that the corresponding transaction of this transfer belongs to.
block_hash
The block hash that the corresponding transaction of this transfer belongs to.
unique_id
Unique id generated to each transfer. Includes transaction hash and log index.