Address Coin Balances

Address Coin Balances table records the history of native token balance changes for each address. This table is updated whenever there is a balance change.

ETL data class

Column Name	Data Type	Note
address	str
block_number	int
balance	int
block_timestamp	timestamp

Examples

{
  "address": "0x4200000000000000000000000000000000000011",
  "block_number": 664,
  "balance": 289870500000000,
  "block_timestamp": "2023-09-08T19:36:39.000Z"
}

0x4200000000000000000000000000000000000011,664,289870500000000,2023-09-08T19:36:39.000Z

Model in the Database

Column Name	Data Type	Note
address	bytea	primary key
block_number	bigint
balance	numeric(100)
block_timestamp	timestamp

Examples

{
  "address": "E'\\\\x4200000000000000000000000000000000000011'",
  "block_number": 664,
  "balance": 289870500000000,
  "block_timestamp": "2023-09-08 19:36:39.000000"
}

\\x4200000000000000000000000000000000000011,664,289870500000000,2023-09-08 19:36:39.000000