| slot_number | NUMBER(38,0) | Beacon Chain slot number. |
| slot_timestamp | TIMESTAMP_NTZ(9) | Beacon Chain slot timestamp of slot. |
| validator_index | NUMBER(38,0) | Unique index of the validator. |
| raw_balance | VARCHAR(16777216) | Raw balance of the validator in string format to retain precision. |
| balance | FLOAT | Balance of the validator. |
| effective_balance | FLOAT | The 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_balance | VARCHAR(16777216) | The 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. |
| status | VARCHAR(16777216) | Current status of the validator. |
| pubkey | VARCHAR(16777216) | The validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive. |
| withdrawal_credentials | VARCHAR(16777216) | Withdrawal credentials is a 32-byte field associated with every validator, initially set during deposit, for verifying the destination of valid withdrawals. |
| withdrawal_prefix | VARCHAR(16777216) | The first byte of this credential is known as the withdrawal prefix. This value is currently either 0x00 or 0x01. |
| withdrawal_address | VARCHAR(16777216) | ETH1 Withdrawal address specified in withdrawal credentials, applicable for validators with 0x01 withdrawal credentials only. |
| slashed | BOOLEAN | Whether the validator was slashed (no longer active). |
| activation_eligibility_epoch | VARCHAR(16777216) | When criteria for activation were met. FAR_FUTURE_EPOCH if not eligible. |
| activation_epoch | VARCHAR(16777216) | Epoch when validator activated. FAR_FUTURE_EPOCH if not activated. |
| exit_epoch | VARCHAR(16777216) | Epoch when validator exited. FAR_FUTURE_EPOCH if not exited. |
| withdrawable_epoch | VARCHAR(16777216) | When validator can withdraw or transfer funds. FAR_FUTURE_EPOCH if not defined. |
| execution_optimistic | BOOLEAN | It’s true if the response references an unverified execution payload. The optimistic information may be invalidated at a later time. If the field is not present, assume the false value |
| finalized | BOOLEAN | Indicates whether the response data is finalized. |
| unique_id | VARCHAR(16777216) | Unique ID for the balance entry. |
| _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. |
