Balances
Balances
solana.assets.balances
solana.assets.sol_balances , solana.assets.spl_balances,
Transaction-level balances from genesis.
solana.assets.balances_latest , solana.assets.spl_balance_latest, solana.assets.sol_balance_latest
Latest balances of all Solana addresses, updated on an hourly cadence.
Solana Balances
The solana.assets.balances table provides transaction-level SOL and SPL token balances of all Solana accounts. Each row corresponds to a change in the balance of SOL / SPL tokens caused by the transaction.
Both sol_balance and spl_balances are huge tables. It is advised that you query time ranges.
spl_balances ~ 15bil rows
sol_balances ~ 330bil rows
Column Name
token_type
Type of token (SOL or SPL-TOKEN)
SOL
address
Address of the token holder
4CKFRwj6YzVygMptmFtZgBNNn7zyCsVibM8Aq5pG252v
token_account
Token account associated with the token holder
decimals
Number of decimal places
9
mint
Mint address of the token
program_id
Program id associated with the token
raw_balance_str
Raw balance of the token as a string for precision.
842899177
raw_balance
Raw balance of the token
842899177
balance_str
Balance of the token in string format for precision.
0.842899177
balance
Balance of the token.
0.842899177
usd_balance
USD balance at the block timestamp.
124.327628608
usd_exchange_rate
USD value of the balance at the block timestamp.
147.5
signer
Transaction Signer.
4CKFRwj6YzVygMptmFtZgBNNn7zyCsVibM8Aq5pG252v
success
Boolean indicator whether this transaction suceeded.
TRUE
is_voting
Boolean indicator whether this is a voting transaction.
TRUE
block_slot
Block slot of the transaction that resulted in the balance change.
274980322
block_height
Block height of the transaction that resulted in the balance change.
254414017
block_hash
Block hash of the transaction that resulted in the balance change.
4S4V2zoGKpMLxDmwz5PKamiKcwAy2euwEbdsypkkjNLt
block_timestamp
Block timestamp of the transaction that resulted in the balance change.
2024-07-01 01:55:58.000
txn_id
Transaction ID that resulted in the balance change.
5oP9oJ2JLYDhTpLi4QyxbNYQooLzmSfTq4auY1Dmm8XkG1bf9R1jNNSmFVDqpB8ByQ1Ta3aqWA6A4kYTyuPeJTp1
txn_index
Transaction index of the transaction id.
685
unique_id
Unique id assigned to the balances entry.
txn_id-5oP9oJ2JLYDhTpLi4QyxbNYQooLzmSfTq4auY1Dmm8XkG1bf9R1jNNSmFVDqpB8ByQ1Ta3aqWA6A4kYTyuPeJTp1_address-4CKFRwj6YzVygMptmFtZgBNNn7zyCsVibM8Aq5pG252v
_updated_at
updated timestamp
2024-07-01 07:11:07.696
Solana Balances Latest
The solana.assets.balances_latest table provides a snapshot of SPL and SOL tokens' most recent balance information.
Table Columns
token_type
Type of token
SPL-TOKEN
address
Address of the token holder
AuZ9H13nRXQzQNEeR7ovmPxb1EbFpWiie2fx8rRa8zxC
token_account
Token account associated with the token holder
8TfpcEJYwJrSx9XNHqLZCBhYuJkbcF3K1z5TySq52pjh
decimals
Number of decimal places the token can be divided into
6
mint
Mint address of the token
3RYgndhvJtpRNAYhc1pmJ8NuEdgCp9H2DUurA1Vvpump
program_id
Program ID associated with the token
TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA
symbol
Symbol of the token
$ICE
raw_balance
Raw balance of the token
62388106652
raw_balance_str
Raw balance of the token as a string
62388106652
balance_str
Balance of the token in a string format
62388.10665
balance
Balance of the token
62388.10665
usd_balance_current
Current USD value of the balance
0.8110453865
usd_balance_at_block_timestamp
USD value of the balance at the block timestamp
5.614929599
usd_exchange_rate_current
Current USD exchange rate of the token
1.27E-05
usd_exchange_rate_at_block_timestamp
USD exchange rate of the token at the block timestamp
8.96E-05
last_activity_block_timestamp
Timestamp of the last activity involving the token
2024-06-24 21:17:13
last_activity_block_slot
Slot number of the last activity involving the token
273800058
last_activity_block_hash
Hash of the block containing the last activity involving the token
BgaWmyUz3Ns1LJpD9vxTMCg5S21jXSBLrQxbjpcVbziH
last_activity_txn_index
Transaction index of the last activity involving the token
244
last_activity_txn_id
Transaction ID of the last activity involving the token
3FutYunZXCK76pjpPQS2xMajs6sTmk5WkyAGVVGxK38LndMuX52U4FppoR8qUqhc4DzVwejpi8kJUrvhjpRwo3o8
_updated_at__usd_exchange_rate_current
Timestamp of when the current USD exchange rate was last updated
2024-06-26 08:00:00
_updated_at__unhydrated
Timestamp of when the data was last updated but not fully hydrated
2024-06-25 02:33:24
_created_at
Timestamp of when the entry was created
2024-06-26 08:43:39.613 +0000
_updated_at
Timestamp of when the entry was last updated
2024-06-26 08:43:39.613 +0000
_changed_since_full_refresh
Boolean indicating if the entry has changed since the last full refresh
TRUE
Last updated