> ## 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 Latest 🌱

### Table Details

| Property          | Value                              |
| ----------------- | ---------------------------------- |
| Table Name        | `beacon_hoodi.raw.balances_latest` |
| Table Status      | Beta 🌱                            |
| Unique Key        | `unique_id`                        |
| Clustering Key(s) | `to_date("slot_timestamp")`        |

### 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.                                                                                                                                                                                                    |