> 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-token-balances.md).

# 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

```json
{
  "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"
}

```

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

```json
{
  "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
```
