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