> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# polkadot.balances

> Description of Substrate balances tables on Dune.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table description

The `balances` table (e.g. `polkadot.balances`) stores a snapshot of all account balances at the end of each day: `free`, `reserved`, `misc_frozen`, and their USD value, if available.

## Table Schema

| Column            | Type        | Description                                                            |
| ----------------- | ----------- | ---------------------------------------------------------------------- |
| `year`            | `INTEGER`   | Calendar year of the snapshot (partition column)                       |
| `month`           | `INTEGER`   | Calendar month of the snapshot (partition column)                      |
| `day`             | `INTEGER`   | Calendar day of the snapshot (partition column)                        |
| `ts`              | `TIMESTAMP` | Timestamp of the end-of-day balance snapshot                           |
| `symbol`          | `VARCHAR`   | Token symbol (e.g. `DOT`, `KSM`)                                       |
| `address_ss58`    | `VARCHAR`   | SS58-encoded address of the account holder                             |
| `address_pubkey`  | `VARBINARY` | Public key of the account holder                                       |
| `id`              | `VARCHAR`   | Unique identifier for the asset                                        |
| `chain_name`      | `VARCHAR`   | Name of the Substrate chain (e.g. `polkadot`, `kusama`)                |
| `asset`           | `VARCHAR`   | Asset type or name                                                     |
| `para_id`         | `BIGINT`    | Parachain ID, if the balance is on a parachain                         |
| `free`            | `DOUBLE`    | Freely transferable balance (human-readable units)                     |
| `reserved`        | `DOUBLE`    | Reserved balance locked for on-chain activities (human-readable units) |
| `misc_frozen`     | `DOUBLE`    | Balance frozen for miscellaneous reasons (human-readable units)        |
| `frozen`          | `DOUBLE`    | Total frozen balance (human-readable units)                            |
| `nonce`           | `BIGINT`    | Account transaction nonce at the time of the snapshot                  |
| `free_raw`        | `VARCHAR`   | Raw free balance in smallest denomination (Planck)                     |
| `reserved_raw`    | `VARCHAR`   | Raw reserved balance in smallest denomination (Planck)                 |
| `misc_frozen_raw` | `VARCHAR`   | Raw misc frozen balance in smallest denomination (Planck)              |
| `frozen_raw`      | `VARCHAR`   | Raw frozen balance in smallest denomination (Planck)                   |
| `flags_raw`       | `VARCHAR`   | Raw account flags value                                                |
| `updated_at`      | `TIMESTAMP` | When this record was last updated in the database                      |
| `ingested_at`     | `TIMESTAMP` | When this record was first ingested into the database                  |

## Table Sample

<TableSample tableSchema="polkadot" tableName="balances" />