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

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.