Token Transfers
Overview
Token Transfers
Overview
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. |