Token Transfers
Overview
Token Transfers
Overview
Our Arbitrum assets schema currently includes ETH and ERC20 Token Transfers.
Note that native ETH on Arbitrum uses the null address 0x0000000000000000000000000000000000000000 as token_address.
arbitrum.assets.eth_erc20_token_transfers combines both ETH and ERC20 transfers on Arbitrum.
Table Columns
| Column Name | Description | Example |
|---|---|---|
| transfer_type | Transfer Type (ERC20 or ETH). | ERC20 |
| from_address | Address where the token is being transferred from. | 0xd1a276c0f72734d34ae2c3c6c37a82c5f26f5655 |
| to_address | Address where the token is being transferred to. | 0x62383739d68dd0f844103db8dfb05a7eded5bbe6 |
| token_address | Token address of the asset transferred. | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 |
| token_name | Name of the asset transferred. | USD Coin (Arb1) |
| token_symbol | Token symbol of the asset transferred. | USDC |
| raw_amount | Amount of tokens moved (unnormalized). | 226,528,583 |
| raw_amount_str | Amount of tokens moved (unnormalized) in string | 226528583 |
| amount | Amount of token moved, normalized. | 226.528583 |
| amount_str | Amount of token moved, normalized in string. | 226.528583 |
| usd_amount | The amount of tokens moved, in $USD. | 226.5059301 |
| transaction_from_address | The address of the sending party of this transaction. | 0xd1a276c0f72734d34ae2c3c6c37a82c5f26f5655 |
| transaction_to_address | The address of the receiving party of this transaction (could be a contract address). | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 |
| transaction_hash | Transaction hash that this transfer belongs to. | 0xf9df1b43f6c27f9df04cf26edbaef07df2e11e240f06bfcb5eb6d2daf685a151 |
| erc20_log_index | ERC20 Transfer Log Index. | 2 |
| 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. | 2023-06-07 04:52:23 |
| block_number | The block number that the corresponding transaction of this transfer belongs to. | 98,603,175 |
| block_hash | The block hash that the corresponding transaction of this transfer belongs to. | 0x308cf678ff198191e7b0a18b737cacc431f2bb756f1ea5de609cfc246526d4d3 |
| unique_id | Unique id generated to each transfer. Includes transaction hash and log index. | txn-0xf9df1b43f6c27f9df04cf26edbaef07df2e11e240f06bfcb5eb6d2daf685a151_log_index-2 |