Skip to main content
← Back to schema changes overview Latest snapshot of each validator’s balances (one row per validator).
  • Effective date: April 7, 2026
  • End of life: May 7, 2026
  • Replacement: beacon.raw.balances_latest
  • Last published: April 7, 2026

​
Schema comparison

Column NameOld Schema (beacon.validator.balances_latest)New Schema (beacon.raw.balances_latest)Change TypeNotes
SLOT_NUMBERIntegerIntegerNo changeSlot number remains the same
SLOT_TIMESTAMPTimestampTimestampNo changeTimestamp format unchanged
VALIDATOR_INDEXIntegerIntegerNo changeValidator index unchanged
RAW_BALANCEInteger (Wei)Integer (Wei)ReorderedNow appears BEFORE BALANCE column
BALANCE ⚠️Integer (Wei) - stored as 32787459477Float (ETH) - stored as 32.78744189BREAKINGChanged from Wei integer to ETH float
EFFECTIVE_BALANCE ⚠️Integer (Wei) - stored as 32000000000Float (ETH) - stored as 32BREAKINGChanged from Wei integer to ETH float
RAW_EFFECTIVE_BALANCEInteger (Wei)Integer (Wei)No changeRaw value unchanged
STATUSStringStringNo changeStatus values unchanged
PUBKEYString (hex)String (hex)No changePublic key format unchanged
WITHDRAWAL_CREDENTIALSString (hex)String (hex)No changeCredentials unchanged
WITHDRAWAL_PREFIX❌ Not presentString (hex) - 0x02NEWExtracted from withdrawal credentials
WITHDRAWAL_ADDRESS❌ Not presentString (hex) - 0x0d369bb...NEWExtracted withdrawal address
SLASHEDBooleanBooleanNo changeSlashing status unchanged
ACTIVATION_ELIGIBILITY_EPOCHIntegerIntegerNo changeEpoch values unchanged
ACTIVATION_EPOCHIntegerIntegerNo changeEpoch values unchanged
EXIT_EPOCHIntegerIntegerNo changeEpoch values unchanged
WITHDRAWABLE_EPOCHIntegerIntegerNo changeEpoch values unchanged
EXECUTION_OPTIMISTICBoolean (FALSE)String (empty) or BooleanBREAKINGType changed, may be empty string
FINALIZEDBoolean (FALSE)Boolean (TRUE)BREAKINGType may differ, default changed
UNIQUE_ID❌ Not presentString - validator_index-0NEWNew unique identifier field
_CREATED_ATTimestampTimestampNo changeCreation timestamp unchanged
_UPDATED_AT❌ Not presentTimestampNEWNew update tracking field
INDEXInteger - 0❌ RemovedREMOVEDReplaced by UNIQUE_ID

​
Breaking changes summary

Critical breaking changes — address these in your queries:
  1. Column order changed: RAW_BALANCE now appears before BALANCE (affects SELECT * queries)
  2. Balance data types changed:
    • BALANCE: Integer (Wei) → Float (ETH)
      • Old: 32787459477 (Wei)
      • New: 32.78744189 (ETH)
    • EFFECTIVE_BALANCE: Integer (Wei) → Float (ETH)
      • Old: 32000000000 (Wei)
      • New: 32 (ETH)
  3. New columns: WITHDRAWAL_PREFIX, WITHDRAWAL_ADDRESS, UNIQUE_ID, _UPDATED_AT
  4. Removed column: INDEX (replaced by UNIQUE_ID)
  5. Type changes: EXECUTION_OPTIMISTIC may be empty string; FINALIZED behavior may differ