Balances Latest

Fetch the balances of validators on Beacon chain.

The beacon.validator.balances_latest table provides the latest snapshot of ETH balances for active validators on Beacon Chain.

Sample Queries

Fetching Distribution of Eth Balances Staked on Beacon Chain

select
    status,
    count(distinct validator_index) as validators,
    sum(balance) as eth_balances,
    sum(effective_balance) as effectively_staked_eth,
from beacon.validator.balances_latest
group by all
order by validators desc

Table Columns

Column Name	Description
slot_number	Slot number of the balance snapshot.
slot_timestamp	Slot timestamp of balance snapshot.
validator_index	Unique index of the validator.
balance	Balance of the validator.
raw_balance	Raw balance of the validator.
effective_balance	The balance at stake. Effective balance is a value for each validator that is derived from the validator's balance and prior effective balance. It is used to calculate the size of rewards and penalties given to that validator.
raw_effective_balance	The balance at stake in string to retain precision. Effective balance is a value for each validator that is derived from the validator's balance and prior effective balance. It is used to calculate the size of rewards and penalties given to that validator.
status	Current status of the validator.
pubkey	The validator's BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive.
withdrawal_credentials	ETH1 Withdrawal address specified in withdrawal credentials, applicable for validators with 0x01 withdrawal credentials only.
slashed	Was validator slashed (not longer active).
activation_eligibility_epoch	When criteria for activation were met.
activation_epoch	Epoch when validator activated. FAR_FUTURE_EPOCH if not activated.
exit_epoch	Epoch when validator exited.
withdrawable_epoch	When validator can withdraw or transfer funds. FAR_FUTURE_EPOCH if not defined.
execution_optimistic	Execution optimistic.
finalized	Finalized.
_created_at	Timestamp of the entry creation.