> ## 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" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.