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