Table description
Thebalances 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 |