Skip to main content

​
Overview

  • Dataset ID: 0201
  • Table: blockdb0201_erc20_tokens_v1
  • Description: Catalog of ERC-20 token contracts.
  • Primary Key: contract_address

​
Columns

ColumnTypeDescription
contract_addressBYTEAAddress of the ERC-20 token contract (20 bytes).
block_numberBIGINTBlock of the log we attribute as the genesis/recognition point.
block_timetimestamptzUTC timestamp when the block was mined
tx_indexINTEGERTransaction index within the block.
log_indexINTEGERLog index within the block.
nameTEXTName of the ERC-20 token.
symbolTEXTSymbol/ticker of the ERC-20 token.
decimalsSMALLINTNumber of decimal places used by the ERC-20 token.
_tracing_idBYTEATracing ID of this ERC-20 token record.
_genesis_tracing_idsBYTEA[]Tracing IDs of the genesis records leading to this ERC-20 token record.
_parent_tracing_idsBYTEA[]Tracing IDs of the parent records leading to this ERC-20 token record.
_created_atTIMESTAMPTZRecord creation timestamp.
_updated_atTIMESTAMPTZRecord last update timestamp.

​
Use Cases

  • Token registry to normalize joins for swaps, transfers, pools, and prices
  • Amount scaling via decimals for analytics, PnL, and model features
  • App backends: display names/symbols and validate token addresses