The beacon.validator.balances table provides a daily snapshot of ETH balances for active validators on Beacon Chain.

This snapshot is taken at the last slot of every day (UTC timing).

This means that validators with pending, withdrawal, exited status are not included in this snapshot. The types of validator status can be found here.

​
Sample Query

Querying balance of a validator by its unique index.

select 

slot_timestamp, validator_index, balance

from beacon.valdiator.balances 

where validator_index = 10

Note: if the validator has specified an ETH1 withdrawal address, reward payments of excess balance over 32 ETH will automatically and regularly be sent to the withdrawal address on ETH1.

​
Table Columns

Column NameDescriptionExample
slot_numberSlot number of balance snapshot.6,116,398
slot_timestampTimestamp of balance snapshot.2023-03-30 23:59:59
validator_indexUnique index of validator.538,903
balanceValidator balance.32.10887728
statusCurrent status of the validator.active_ongoing
activation_eligibility_epochWhen criteria for activation were met.184167
activation_epochEpoch when validator activated. FAR_FUTURE_EPOCH if not activated.185165
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.32
exit_epochExit epoch of the validator.18446744073709551615
pubkeyThe validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive.0xb4783219cddc42d5950bf394ade17c60fe5fa50c065b379ae79cd272340d0f4fe28c0bbfb294230a801f616f80c167e8
is_slashedWas validator slashed (not longer active).FALSE
withdrawable_epochWhen validator can withdraw or transfer funds. FAR_FUTURE_EPOCH if not defined.18446744073709551615
withdrawal_credentialsThe root of withdrawal credentials.0x010000000000000000000000b9d7934878b5fb9610b3fe8a5e441e8fad7e293f
withdrawal_prefixThe first byte of this credential is known as the withdrawal prefix. This value is currently either 0x00 or 0x01.0x01
withdrawal_addressETH1 Withdrawal address specified in withdrawal credentials, applicable for validators with 0x01 withdrawal credentials only.0xb9d7934878b5fb9610b3fe8a5e441e8fad7e293f
raw_balanceBalance in gwei.32108877278
raw_effective_balanceEffective balance in gwei.32000000000
unique_idUnique ID given to validator balance entry.slot_timestamp-2023-03-30 23:59:59.000_validator_index-538903