Address Token Balances

History of token balance change for each address - token_address pair. This table is updated whenever there is a balance change.

ETL data class

Column Name	Data Type	Note
address	str
block_number	int
token_address	str
token_type	str
token_id	int
token_balance	int
block_timestamp	timestamp

Examples

{
  "address": "0x66c0232d3c5f0c25914785606e73bd41b788b9ac",
  "block_number": 559924,
  "token_address": "0x0dc808adce2099a9f62aa87d9670745aba741746",
  "token_type": "ERC20",
  "token_id": -1,
  "token_balance": 32644185039418274000,
  "block_timestamp": "2023-11-12T13:06:39.000Z"
}

0x66c0232d3c5f0c25914785606e73bd41b788b9ac,559924,0x0dc808adce2099a9f62aa87d9670745aba741746,ERC20,-1,32644185039418274000,2023-11-12T13:06:39.000Z

Model in the Database

Column Name	Data Type	Note
address	bytea
block_number	bigint
token_address	bytea
token_type	varchar
token_id	numeric(78)
token_balance	numeric(100)
block_timestamp	timestamp

Examples

{
  "address": "E'\\\\x66c0232d3c5f0c25914785606e73bd41b788b9ac'",
  "block_number": 559924,
  "token_address": "E'\\\\x0dc808adce2099a9f62aa87d9670745aba741746'",
  "token_type": "ERC20",
  "token_id": -1,
  "token_balance": 32644185039418274000,
  "block_timestamp": "2023-11-12 13:06:39.000000"
}

\\x66c0232d3c5f0c25914785606e73bd41b788b9ac,559924,\\x0dc808adce2099a9f62aa87d9670745aba741746,ERC20,-1,32644185039418274000,2023-11-12 13:06:39.000000