Skip to main content

​
Table description

Tracks account balance snapshots on the Peaq network, capturing the state of user assets at specific timestamps. This table is partitioned by year, month, and day for efficient querying. Each record includes balance information in both processed (double) and raw (string) formats, allowing for precise balance tracking. The table tracks multiple balance types including free balances, reserved balances, and various frozen balance states (misc_frozen and frozen). Accounts are identified using SS58 addresses (address_ss58) and public keys (address_pubkey), supporting both human-readable and binary address formats. The table also includes chain and asset metadata such as symbol, chain_name, asset, and para_id for multi-chain support.

​
Column Descriptions

ColumnDescriptionType
yearThe year when the balance snapshot was taken, used for partitioning.int
monthThe month when the balance snapshot was taken, used for partitioning.int
dayThe day when the balance snapshot was taken, used for partitioning.int
tsThe timestamp when the balance snapshot was taken.timestamp
symbolThe symbol of the asset (e.g., “PEAQ”).string
address_ss58The SS58-encoded address of the account in human-readable format.string
address_pubkeyThe public key of the account in binary format.binary
idThe unique identifier for the balance record.string
chain_nameThe name of the chain where the balance exists.string
assetThe asset identifier or symbol.string
para_idThe parachain ID associated with the balance, if applicable.long
freeThe free balance available to the account, in processed format.double
reservedThe reserved balance that is locked but still owned by the account.double
misc_frozenThe miscellaneous frozen balance that cannot be used for certain operations.double
frozenThe total frozen balance that cannot be used.double
nonceThe account nonce, representing the number of transactions from this account.long
free_rawThe free balance in raw string format, preserving full precision.string
reserved_rawThe reserved balance in raw string format, preserving full precision.string
misc_frozen_rawThe miscellaneous frozen balance in raw string format, preserving full precision.string
frozen_rawThe frozen balance in raw string format, preserving full precision.string
flags_rawThe raw flags associated with the account balance state.string
_updated_atThe time when the balance record was last updated.timestamp
_ingested_atThe time when the balance data was ingested into the system.timestamp

​
Table Sample