Table Details
| Property | Value |
|---|---|
| Table Name | beacon.validator.balances_latest |
| Table Status | Production-Ready |
| Unique Key | token_address, address |
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 |
| balance | FLOAT | Balance of the validator. |
| effective_balance | FLOAT | Effective balance of the validator. |
| raw_balance | VARCHAR(16777216) | Validator balance as an integer in gwei (1e9 gwei = 1 ETH). |
| 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 |
| 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. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| index | NUMBER(38,0) | The unique index identifier for the perpetual market on Hyperliquid. |