> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Balances 🌱

### Table Details

| Property | Value |
| - | - |
| Table Name | `beacon_hoodi.raw.balances` |
| Table Status | Beta 🌱 |
| Unique Key | `slot_number`, `validator_index` |
| Clustering Key(s) | `to_date("slot_timestamp")` |
| Search Optimization | `validator_index` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| 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. |

### Related Docs

* [Beacon Raw Balances](/historical-data/supported-blockchains/evm/beacon/raw/balances)