Token Transfers

Our Scroll assets schema currently includes ETH, ERC20, ERC721 and ERC1155 Token Transfers.

Note that native ETH on Scroll uses the null address 0x0000000000000000000000000000000000000000 as token_address.

Scroll.assets.eth_erc20_token_transfers combines both ETH and ERC20 transfers on Scroll.

Table Columns

Column NameDescriptionExample

transfer_type

Transfer Type (ERC20 or Native Token).

ERC20

from_address

Address where the token is being transferred from.

0x6905c59be1a7ea32d1f257e302401ec9a1401c52

to_address

Address where the token is being transferred to.

0x05d6bd8694bf7718b00aa68703304ab74ffc584e

token_address

Token address of the asset transferred.

0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4

token_name

Name of the asset transferred.

USD Coin

token_symbol

Token symbol of the asset transferred.

USDC

raw_amount

Amount of tokens moved (unnormalized).

13318870.0

raw_amount_str

Amount of tokens moved (unnormalized) in string.

13318870

amount

Amount of token moved, normalized.

13.31887

amount_str

Amount of token moved, normalized in string.

13.31887

usd_amount

USD value of the amount of tokens transferred.

13.316206226

transaction_from_address

The address of the sending party of this transaction.

0x05d6bd8694bf7718b00aa68703304ab74ffc584e

transaction_to_address

The address of the receiving party of this transaction (could be a contract address).

0x18b71386418a9fca5ae7165e31c385a5130011b6

transaction_hash

Transaction hash that this transfer belongs to.

0xe7aac07a2db3df311c370906e924a97dc6960fcbfc207161d7e8d44b048d87cc

erc20_log_index

ERC20 Transfer Log Index.

3

eth_call_type

Native 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-11-23 22:28:12+00:00

block_number

The block number that the corresponding transaction of this transfer belongs to.

1031664

block_hash

The block hash that the corresponding transaction of this transfer belongs to.

0x8f0bff9c69aee96b0a57e9123bfcec3ea9f3a90fd80eb6ebcb008a67ad3415b0

unique_id

Unique id generated to each transfer. Includes transaction hash and log index.

txn-0xe7aac07a2db3df311c370906e924a97dc6960fcbfc207161d7e8d44b048d87cc_log_index-3

Last updated