> For the complete documentation index, see [llms.txt](https://docs.thehemera.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.thehemera.com/hemera-indexer/data-class/generated-tables/address-coin-balances.md).

# 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

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

```csv
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

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

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