Sol Balances - Allium Documentation Hub

The SOL balances table records the full history of SOL balances of all Solana addresses at every transaction. A row is added only when a balance change occurs due to a transaction performed by the user or to the user.

Table Details

Property	Value
Table Name	`solana.assets.sol_balances`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `txn_id`, `unique_id`

Table Columns

Column Name	Data Type	Description
token_type	VARCHAR(3)	Token standard for the asset. One of: `erc20` (fungible), `erc721` (non-fungible), `erc1155` (semi-fungible), or the native currency symbol (e.g. `eth`, `matic`, `bnb`).
address	VARCHAR(16777216)	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.
token_account	VARCHAR(16777216)	SPL token account address that holds the token balance. On Solana, token balances are tracked in separate token accounts associated with a wallet (owner) address and a mint.
decimals	NUMBER(1,0)	Number of decimal places for this token. Short alias for `token_decimals` used in tables that preserve the original blockchain field naming convention.
mint	VARCHAR(43)	Base58-encoded mint address of the SPL token. Analogous to `token_address` on EVM chains. Each mint uniquely identifies a fungible or non-fungible token on Solana.
program_id	VARCHAR(16777216)	Base58-encoded public key of the Solana program that processed this instruction (e.g. `TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA` for SPL Token).
raw_balance_str	VARCHAR(16777216)	Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances.
raw_balance	FLOAT	Token balance in the token’s smallest unit (not decimal-adjusted). Use `balance` for the human-readable normalized value.
balance_str	VARCHAR(16777216)	Normalized token balance stored as a string for full precision. Equivalent to `balance` but avoids floating-point truncation.
balance	FLOAT	Sum of end-of-day token balances for this address_type.
usd_balance	FLOAT	USD value of the token balance, computed using the exchange rate at the time of the balance snapshot.
_pre_raw_balance_str	VARCHAR(16777216)	Pre-transaction raw balance as a string to preserve full precision.
_pre_raw_balance	FLOAT	Token balance of the account before this transaction in raw units (not decimal-adjusted).
_pre_balance_str	VARCHAR(16777216)	Pre-transaction balance as a string to preserve full precision.
_pre_balance	FLOAT	Token balance of the account before this transaction executed (decimal-adjusted).
_pre_usd_balance	FLOAT	USD value of the token account balance before this transaction, using the historical hourly price.
usd_exchange_rate	FLOAT	USD price per unit of the token at the time of the event, used to compute `usd_amount`. Sourced from Allium’s hourly price feed.
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(16777216)	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.