Token Transfers

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

Last updated