Table Details
| Property | Value |
|---|---|
| Table Name | beacon.validator.balances |
| Table Status | Production-Ready |
| Search Optimization | validator_index |
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. |
| status | VARCHAR(134217728) | Current status of the validator. |
| activation_eligibility_epoch | VARCHAR(134217728) | Epoch when the validator became eligible for activation. |
| activation_epoch | VARCHAR(134217728) | 230889 |
| effective_balance | FLOAT | Effective balance of the validator. |
| exit_epoch | VARCHAR(134217728) | -1 |
| pubkey | VARCHAR(134217728) | 0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f |
| is_slashed | BOOLEAN | FALSE |
| withdrawable_epoch | VARCHAR(134217728) | Epoch when validator can withdraw. |
| withdrawal_credentials | VARCHAR(134217728) | 0x010000000000000000000000e839a3e9efb32c6a56ab7128e51056585275506c |
| withdrawal_prefix | VARCHAR(134217728) | 0x01 |
| withdrawal_address | VARCHAR(134217728) | 0xe839a3e9efb32c6a56ab7128e51056585275506c |
| raw_balance | VARCHAR(134217728) | Validator balance as an integer in gwei (1e9 gwei = 1 ETH). |
| raw_effective_balance | VARCHAR(134217728) | Effective balance at stake in gwei. |
| unique_id | VARCHAR(134217728) | date-2023-05-10_validator_index-459015 |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |