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 NameDescription
from_addressAddress where the token is being transferred from.
to_addressAddress where the token is being transferred to.
token_addressToken address of the asset transferred. 0x0000000000000000000000000000000000000000 for Native tokens on EVM chains.
token_nameName of the asset transferred.
token_symbolToken symbol of the asset transferred.
raw_amountAmount of tokens moved (unnormalized).
raw_amount_strAmount of tokens moved (unnormalized) in string to retain precision.
amountAmount of token moved, normalized.
amount_strAmount of token moved, normalized in string to retain precision.
usd_amountThe USD amount of the tokens at the time of the transfer,
usd_exchange_rateThe exchange rate used to calculate the usd_amount.
call_typeCall type of the transaction. Non-call type will be indicated by NULL.
transfer_typeThe type of transfers. Typically includes value_transfer, gas_burn, gas_payment_to_miner.
transaction_from_addressThe address of the sending party of this transaction.
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).
transaction_hashTransaction hash that this transfer belongs to.
transaction_indexThe position of this transaction in the block. The first transaction has index 0.
block_timestampThe time when the block that contains this transaction was included on the blockchain.
block_numberThe block number that the corresponding transaction of this transfer belongs to.
block_hashThe block hash that the corresponding transaction of this transfer belongs to.
unique_idUnique id generated to each transfer.