The beacon.validator.balances_latest table provides the latest snapshot of ETH balances for active validators on the 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 NameDescription
slot_numberSlot number of the balance snapshot.
slot_timestampSlot timestamp of balance snapshot.
validator_indexUnique index of the validator.
balanceBalance of the validator.
raw_balanceRaw balance of the validator.
effective_balanceThe 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_balanceThe 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.
statusCurrent status of the validator.
pubkeyThe validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive.
withdrawal_credentialsETH1 Withdrawal address specified in withdrawal credentials, applicable for validators with 0x01 withdrawal credentials only.
slashedWas validator slashed (not longer active).
activation_eligibility_epochWhen criteria for activation were met.
activation_epochEpoch when validator activated. FAR_FUTURE_EPOCH if not activated.
exit_epochEpoch when validator exited.
withdrawable_epochWhen validator can withdraw or transfer funds. FAR_FUTURE_EPOCH if not defined.
execution_optimisticExecution optimistic.
finalizedFinalized.
_created_atTimestamp of the entry creation.

The beacon.validator.balances_latest table provides the latest snapshot of ETH balances for active validators on the 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 NameDescription
slot_numberSlot number of the balance snapshot.
slot_timestampSlot timestamp of balance snapshot.
validator_indexUnique index of the validator.
balanceBalance of the validator.
raw_balanceRaw balance of the validator.
effective_balanceThe 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_balanceThe 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.
statusCurrent status of the validator.
pubkeyThe validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive.
withdrawal_credentialsETH1 Withdrawal address specified in withdrawal credentials, applicable for validators with 0x01 withdrawal credentials only.
slashedWas validator slashed (not longer active).
activation_eligibility_epochWhen criteria for activation were met.
activation_epochEpoch when validator activated. FAR_FUTURE_EPOCH if not activated.
exit_epochEpoch when validator exited.
withdrawable_epochWhen validator can withdraw or transfer funds. FAR_FUTURE_EPOCH if not defined.
execution_optimisticExecution optimistic.
finalizedFinalized.
_created_atTimestamp of the entry creation.