> ## 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   | `solana_devnet.assets.balances` |
| Table Status | Beta 🌱                         |
| Unique Key   | `block_timestamp`, `unique_id`  |

### Table Columns

| Column Name         | Data Type         | Description                                                             |
| ------------------- | ----------------- | ----------------------------------------------------------------------- |
| token\_type         | VARCHAR(9)        | Type of token (SOL or SPL-TOKEN)                                        |
| address             | VARCHAR(16777216) | Address of the token holder                                             |
| token\_account      | VARCHAR(16777216) | Token account associated with the token holder                          |
| decimals            | NUMBER(38,0)      | Number of decimal places                                                |
| mint                | VARCHAR(16777216) | Mint address of the token                                               |
| symbol              | VARCHAR(3)        | The token ticker symbol, when available.                                |
| program\_id         | VARCHAR(16777216) | Program id associated with the token                                    |
| raw\_balance\_str   | VARCHAR(16777216) | Raw balance of the token as a string for precision.                     |
| raw\_balance        | FLOAT             | Raw balance of the token                                                |
| balance\_str        | VARCHAR(16777216) | Balance of the token in string format for precision.                    |
| balance             | FLOAT             | Balance of the token.                                                   |
| usd\_balance        | VARCHAR(16777216) | USD balance at the block timestamp.                                     |
| usd\_exchange\_rate | VARCHAR(16777216) | USD value of the balance at the block timestamp.                        |
| signer              | VARCHAR(16777216) | Transaction Signer.                                                     |
| success             | BOOLEAN           | Boolean indicator whether this transaction suceeded.                    |
| is\_voting          | BOOLEAN           | Boolean indicator whether this is a voting transaction.                 |
| block\_slot         | NUMBER(38,0)      | Block slot of the transaction that resulted in the balance change.      |
| block\_height       | NUMBER(38,0)      | Block height of the transaction that resulted in the balance change.    |
| block\_hash         | VARCHAR(16777216) | Block hash of the transaction that resulted in the balance change.      |
| block\_timestamp    | TIMESTAMP\_NTZ(9) | Block timestamp of the transaction that resulted in the balance change. |
| txn\_id             | VARCHAR(16777216) | Transaction ID that resulted in the balance change.                     |
| txn\_index          | NUMBER(38,0)      | Transaction index of the transaction id.                                |
| unique\_id          | VARCHAR(16777216) | Unique id assigned to the balances entry.                               |
| \_updated\_at       | TIMESTAMP\_NTZ(9) | updated timestamp                                                       |

### Related Docs

* [Solana Assets Balances](/historical-data/supported-blockchains/solana/solana/assets/balances)