ETH Transfers

Contains transfers of native gas token from traces and gas payment from initiating a transactions. We identify successful transfers by looking for trace calls that deduct native gas token for movement of native tokens from an address.

For transaction fees, we compute the priority and base fees (if applicable) and assign the transaction sender as the from_address and the recipient to the respective destination (miner, sequencer, burn address, etc).

Table Columns

Unique Key: unique_id

Column Name	Description
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. 0x0000000000000000000000000000000000000000 for Native tokens on EVM chains.
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 to retain precision.
amount	Amount of token moved, normalized.
amount_str	Amount of token moved, normalized in string to retain precision.
usd_amount	The USD amount of the tokens at the time of the transfer,
usd_exchange_rate	The exchange rate used to calculate the usd_amount.
call_type	Call type of the transaction. Non-call type will be indicated by NULL.
transfer_type	The type of transfers. Typically includes value_transfer, gas_burn, gas_payment_to_miner.
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.
transaction_index	The position of this transaction in the block. The first transaction has index 0.
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.