ERC20 Token Holders

ERC20 Token Holders table records the balance of each token holder at a given block. Each row represents a holder's balance for a specific token, including the token address, wallet address, balance (balance_of), and the associated block details.

ETL data class

Column Name	Data Type	Note
token_address	str
wallet_address	str
balance_of	int
transaction_hash	str
block_timestamp	timestamp
block_number	int
block_hash	str

Examples

{
  "token_address": "0x80137510979822322193fc997d400d5a6c747bf7",
  "wallet_address": "0xcaab1bd9025a576cee4757506d81b32e4724f9ef",
  "balance_of": 9834981273804,
  "transaction_hash": null,
  "block_timestamp": "2023-11-16T01:06:59.000Z",
  "block_number": 590166,
  "block_hash": null
}

0x80137510979822322193fc997d400d5a6c747bf7,0xcaab1bd9025a576cee4757506d81b32e4724f9ef,9834981273804,,,2023-11-16T01:06:59.000Z,590166,

Model in the Database

Column Name	Data Type	Note
token_address	bytea
wallet_address	bytea
balance_of	numeric(100)
transaction_hash	bytea
block_timestamp	timestamp
block_number	bigint
block_hash	bytea

{
  "token_address": "\\x80137510979822322193fc997d400d5a6c747bf7",
  "wallet_address": "\\xcaab1bd9025a576cee4757506d81b32e4724f9ef",
  "balance_of": 9834981273804,
  "transaction_hash": null,
  "block_timestamp": "2023-11-16 01:06:59.000000",
  "block_number": 590166,
  "block_hash": null
}

\\x80137510979822322193fc997d400d5a6c747bf7,\\xcaab1bd9025a576cee4757506d81b32e4724f9ef,9834981273804,,,2023-11-16 01:06:59.000000,590166,