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

# Nonvoting Sol Balances

### Table Details

| Property | Value |
| - | - |
| Table Name | `solana.raw.nonvoting_sol_balances` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp`, `txn_id`, `unique_id` |
| Clustering Key(s) | `to_date("block_timestamp"), "success", "address_short"` |
| Search Optimization | `txn_id`, `signer`, `success`, `address_short` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| address | VARCHAR(134217728) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| raw\_amount | VARCHAR(134217728) | Token amount in the smallest indivisible unit (not decimal-adjusted). Same concept as `amount_raw` — the column is named `raw_amount` in models that follow the `raw_` prefix convention. |
| pre\_raw\_amount | VARCHAR(134217728) | Raw token balance before a transfer, in native units without decimal adjustment. |
| signer | VARCHAR(16777216) | Primary signing account (fee payer) of the transaction. This is the account that authorized the transaction and paid transaction fees. |
| success | BOOLEAN | Boolean flag indicating whether the transaction executed successfully. True = succeeded, false = failed or reverted. |
| is\_voting | BOOLEAN | True if this transaction is a validator vote transaction |
| block\_slot | NUMBER(38,0) | Solana slot number in which this transaction was confirmed. Slots are the fundamental unit of time on Solana (analogous to block numbers on EVM chains). Not every slot produces a block. |
| block\_height | NUMBER(38,0) | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike `block_slot`, this only increments for slots that produced a block. |
| block\_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| txn\_id | VARCHAR(16777216) | Base58-encoded transaction signature on Solana. Analogous to `transaction_hash` on EVM chains. Uniquely identifies a transaction. |
| txn\_index | NUMBER(38,0) | Zero-based position of this transaction within its slot. |
| unique\_id | VARCHAR(134217728) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database. |
| address\_short | VARCHAR(16777216) | Abbreviated address (first 8 characters) for display purposes. |