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 NameDescription

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