Token Transfers
Our Optimism assets schema currently includes ETH and ERC20 Token Transfers.
Note that native ETH on Optimism uses the null address 0x0000000000000000000000000000000000000000 as token_address.
optimism.assets.eth_erc20_token_transfers combines both ETH and ERC20 transfers on Optimism.
Table Columns
| Column Name | Description | Example |
|---|---|---|
transfer_type | Transfer Type (ERC20 or ETH). | ERC20 |
from_address | Address where the token is being transferred from. | 0x85149247691df622eaf1a8bd0cafd40bc45154a9 |
to_address | Address where the token is being transferred to. | 0xba1bfd85432905ff4a2e7f516b56b7485dbdc5f6 |
token_address | Token address of the asset transferred. | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 |
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). | 4,742,127,586 |
raw_amount_str | Amount of tokens moved (unnormalized) in string | 4742127586 |
amount | Amount of token moved, normalized. | 4,742.13 |
amount_str | Amount of token moved, normalized in string. | 4742.127586 |
usd_amount | The amount of tokens moved, in $USD. | 4,746.40 |
transaction_from_address | The address of the sending party of this transaction. | 0x13fd973dcd35d851d2ea641386da69800b01eb16 |
transaction_to_address | The address of the receiving party of this transaction (could be a contract address). | 0xba1bfd85432905ff4a2e7f516b56b7485dbdc5f6 |
transaction_hash | Transaction hash that this transfer belongs to. | 0x3332835e57a8dc33ad963672ba24bcd66d162834bb50d253f9b5d051b04dcf84 |
erc20_log_index | ERC20 Transfer Log Index. | 0 |
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. | 2022-06-01 15:33:43 |
block_number | The block number that the corresponding transaction of this transfer belongs to. | 10,028,614 |
block_hash | The block hash that the corresponding transaction of this transfer belongs to. | 0x1c18770532796a997c28851070750910be1eb28d7e217f9a35e7aee1d3c15945 |
unique_id | Unique id generated to each transfer. Includes transaction hash and log index. | txn-0x3332835e57a8dc33ad963672ba24bcd66d162834bb50d253f9b5d051b04dcf84_log_index-0 |
Last updated