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.sol_balances |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| token_type | VARCHAR(3) | The token category for the balance record, such as SOL or SPL-TOKEN. |
| address | VARCHAR(16777216) | The wallet or account address that owns the balance. |
| token_account | VARCHAR(16777216) | The token account associated with the balance, when applicable. |
| decimals | NUMBER(1,0) | The number of decimal places configured for the token mint. |
| mint | VARCHAR(43) | The token mint address. |
| program_id | VARCHAR(16777216) | The Solana program account invoked by the instruction or owning the token account. |
| raw_balance_str | VARCHAR(16777216) | The raw token balance before decimal adjustment, represented as a string. |
| raw_balance | FLOAT | The raw token balance before decimal adjustment. |
| balance_str | VARCHAR(16777216) | The token balance after decimal adjustment, represented as a string. |
| balance | FLOAT | The token balance after decimal adjustment. |
| usd_balance | VARCHAR(16777216) | The USD value of the token balance at the transaction time. |
| usd_exchange_rate | VARCHAR(16777216) | The USD exchange rate used to value the token balance. |
| signer | VARCHAR(16777216) | The transaction signer, commonly the fee payer or initiating account. |
| success | BOOLEAN | Whether the parent transaction executed successfully. |
| is_voting | BOOLEAN | Whether the transaction or balance change is associated with voting activity. |
| block_slot | NUMBER(38,0) | The Solana slot containing the block for this record. |
| block_height | NUMBER(38,0) | The block height for this record. |
| block_hash | VARCHAR(16777216) | The hash of the block containing this record. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block containing this record. |
| txn_id | VARCHAR(16777216) | The transaction signature, which uniquely identifies the transaction. |
| txn_index | NUMBER(38,0) | The zero-based position of the transaction within the block. |
| unique_id | VARCHAR(16777216) | A deterministic unique identifier for this row. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |