Skip to main content

​
Overview

  • Dataset ID: 0304
  • Table: blockdb_evm.b0304_token_transfers_v1
  • Description: Token transfer events (native ETH, ERC-20, ERC-721, ERC-1155) produced by TokenTransfersEngine from transactions, internal transactions, and transfer logs.
  • Primary Key: id (BIGINT GENERATED ALWAYS AS IDENTITY)
  • Foreign Key: (block_number, tx_index) → blockdb_evm.b0102_transactions_v1
  • API: POST /evm/transfers/token-transfers

​
Methodology

The transfers are created for identified contract addresses that are ERC-20, ERC-721, ERC-1155 or native ETH. If the contract is not identified as one of these, the transfer is not created.

​
Columns

ColumnTypeDescription
idBIGINTSurrogate primary key (auto-generated).
block_numberBIGINTBlock where the transfer occurred.
block_timeTIMESTAMPTZUTC timestamp of the block.
tx_indexINTEGERTransaction index within the block.
log_indexINTEGERLog index within the transaction receipt; null for native or internal tx transfers.
trace_addressTEXTTrace address for internal tx transfers (e.g. “0”, “0.1”); null for other types.
from_addressBYTEASender address (20 bytes).
to_addressBYTEARecipient address (20 bytes).
token_addressBYTEAToken contract address (20 bytes); null for native ETH.
amount_rawNUMERIC(78,0)Raw amount in smallest unit (wei for native, raw uint256 for ERC-20/1155).
amount_adjTEXTDecimal-adjusted amount; null if decimals unknown or NFT.
token_idNUMERIC(78,0)Token ID for ERC-721 and ERC-1155; null for native/ERC-20.
transfer_typeTEXTTransfer type: native_tx, native_internal, erc20, erc721, erc1155.
_tracing_idBYTEABlockDB lineage identifier.
_parent_tracing_idsBYTEA[]BlockDB lineage identifiers of the parent records.
_created_atTIMESTAMPTZRecord creation timestamp.
_updated_atTIMESTAMPTZRecord last update timestamp.

​
Use Cases

  • Wallet balance and flow analytics
  • Token movement and holder tracking
  • Compliance and attribution (native + ERC-20/721/1155 in one table)
  • MEV and arbitrage flow reconstruction