Balances Latest - Allium Documentation Hub

Table Details

Property	Value
Table Name	`beacon.raw.balances_latest`
Table Status	Production-Ready
Unique Key	`validator_index`
Clustering Key(s)	`to_date("slot_timestamp")`

The beacon.raw.balances_latest table provides the latest validator balances of all validators on the Beacon Chain. Each row represents a validator’s current balance state, including effective balance and validator status information. This table is updated every epoch. Use the finalized and execution_optimistic columns to confirm whether a row reflects finalized state.

Use Cases: Real-Time Monitoring & Analysis

This table is essential for real-time validator monitoring and current state analysis: Real-Time Monitoring: Track current validator balances and status to monitor active validators, detect recent slashing events, and observe ongoing validator operations. Use this table for live dashboards and alerting systems. Current State Analysis: Query the latest state of validators to understand current network composition, active stake distribution, and validator health. Identify validators by their withdrawal addresses or public keys for operational monitoring. Queue & Status Tracking: Monitor validator activation and exit status through status, activation_epoch, and exit_epoch fields to understand current validator lifecycle positions.

Sample Queries

Query 1: Get Latest Balances for All Active Validators

select
    validator_index,
    balance,
    effective_balance,
    status,
    slot_timestamp
from beacon.raw.balances_latest
where status = 'active_ongoing'
order by validator_index

Query 2: Query Latest Balance for Specific Validators

select
    *
from beacon.raw.balances_latest
where validator_index in (1, 1000, 145, 1589823)

Table Columns

Column Name	Data Type	Description
slot_number	NUMBER(38,0)	Slot number of the state where the pending deposits to beacon chain is fetched.
slot_timestamp	TIMESTAMP_NTZ(9)	Slot timestamp of the state where the pending deposits to beacon chain is fetched.
validator_index	NUMBER(38,0)	916,865
raw_balance	VARCHAR(16777216)	Validator balance as an integer in gwei (1e9 gwei = 1 ETH).
balance	FLOAT	Balance of the validator.
effective_balance	FLOAT	Effective balance of the validator.
raw_effective_balance	VARCHAR(16777216)	Effective balance at stake in gwei.
status	VARCHAR(16777216)	Current status of the validator.
pubkey	VARCHAR(16777216)	0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f
withdrawal_credentials	VARCHAR(16777216)	0x010000000000000000000000e839a3e9efb32c6a56ab7128e51056585275506c
withdrawal_prefix	VARCHAR(16777216)	0x01
withdrawal_address	VARCHAR(16777216)	0xe839a3e9efb32c6a56ab7128e51056585275506c
slashed	BOOLEAN	Whether the validator has been slashed.
activation_eligibility_epoch	VARCHAR(16777216)	Epoch when the validator became eligible for activation.
activation_epoch	VARCHAR(16777216)	230889
exit_epoch	VARCHAR(16777216)	-1
withdrawable_epoch	VARCHAR(16777216)	Epoch when validator can withdraw.
execution_optimistic	BOOLEAN	If the slot/epoch is executed optimistically.
finalized	BOOLEAN	If the slot/epoch is finalized.
unique_id	VARCHAR(16777216)	date-2023-05-10_validator_index-459015
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.

EVM

​Table Details

​Use Cases: Real-Time Monitoring & Analysis

​Sample Queries

​Query 1: Get Latest Balances for All Active Validators

​Query 2: Query Latest Balance for Specific Validators

​Table Columns