Assets
Balances
Assets
Balances
Balances
| Table | Description |
|---|---|
| Transaction-level balances from genesis. |
solana.assets.balances_latest , solana.assets.spl_token_balances_latest, solana.assets.sol_balances_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_balances and spl_token_balances are huge tables. It is advised that you query time ranges and specific addresses
-
spl_token_balances ~ 15bil rows
-
sol_balances ~ 330bil rows
Sample Usage
A common use case is to calculate daily balances of a solana address. Refer to this sample query.
Column Name
| Column | Description | Type | Example |
|---|---|---|---|
| token_type | Type of token (SOL or SPL-TOKEN) | varchar | SOL |
| address | Address of the token holder | varchar | 4CKFRwj6YzVygMptmFtZgBNNn7zyCsVibM8Aq5pG252v |
| token_account | Token account associated with the token holder | varchar | |
| decimals | Number of decimal places | number | 9 |
| mint | Mint address of the token | varchar | |
| program_id | Program id associated with the token | varchar | |
| raw_balance_str | Raw balance of the token as a string for precision. | varchar | 842899177 |
| raw_balance | Raw balance of the token | float | 842899177 |
| balance_str | Balance of the token in string format for precision. | varchar | 0.842899177 |
| balance | Balance of the token. | float | 0.842899177 |
| usd_balance | USD balance at the block timestamp. | float | 124.327628608 |
| usd_exchange_rate | USD value of the balance at the block timestamp. | float | 147.5 |
| signer | Transaction Signer. | varchar | 4CKFRwj6YzVygMptmFtZgBNNn7zyCsVibM8Aq5pG252v |
| success | Boolean indicator whether this transaction suceeded. | boolean | TRUE |
| is_voting | Boolean indicator whether this is a voting transaction. | boolean | TRUE |
| block_slot | Block slot of the transaction that resulted in the balance change. | number | 274980322 |
| block_height | Block height of the transaction that resulted in the balance change. | number | 254414017 |
| block_hash | Block hash of the transaction that resulted in the balance change. | varchar | 4S4V2zoGKpMLxDmwz5PKamiKcwAy2euwEbdsypkkjNLt |
| block_timestamp | Block timestamp of the transaction that resulted in the balance change. | timestamp_ntz | 2024-07-01 01:55:58.000 |
| txn_id | Transaction ID that resulted in the balance change. | varchar | 5oP9oJ2JLYDhTpLi4QyxbNYQooLzmSfTq4auY1Dmm8XkG1bf9R1jNNSmFVDqpB8ByQ1Ta3aqWA6A4kYTyuPeJTp1 |
| txn_index | Transaction index of the transaction id. | number | 685 |
| unique_id | Unique id assigned to the balances entry. | varchar | txn_id-5oP9oJ2JLYDhTpLi4QyxbNYQooLzmSfTq4auY1Dmm8XkG1bf9R1jNNSmFVDqpB8ByQ1Ta3aqWA6A4kYTyuPeJTp1_address-4CKFRwj6YzVygMptmFtZgBNNn7zyCsVibM8Aq5pG252v |
| _updated_at | updated timestamp | timestamp_ntz | 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
| Column Name | Description | Type | Example |
|---|---|---|---|
| token_type | Type of token | varchar | SPL-TOKEN |
| address | Address of the token holder | varchar | AuZ9H13nRXQzQNEeR7ovmPxb1EbFpWiie2fx8rRa8zxC |
| token_account | Token account associated with the token holder | varchar | 8TfpcEJYwJrSx9XNHqLZCBhYuJkbcF3K1z5TySq52pjh |
| decimals | Number of decimal places the token can be divided into | number | 6 |
| mint | Mint address of the token | varchar | 3RYgndhvJtpRNAYhc1pmJ8NuEdgCp9H2DUurA1Vvpump |
| program_id | Program ID associated with the token | varchar | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA |
| symbol | Symbol of the token | varchar | $ICE |
| raw_balance | Raw balance of the token | float | 62388106652 |
| raw_balance_str | Raw balance of the token as a string | varchar | 62388106652 |
| balance_str | Balance of the token in a string format | varchar | 62388.10665 |
| balance | Balance of the token | float | 62388.10665 |
| usd_balance_current | Current USD value of the balance | float | 0.8110453865 |
| usd_balance_at_block_timestamp | USD value of the balance at the block timestamp | float | 5.614929599 |
| usd_exchange_rate_current | Current USD exchange rate of the token | float | 1.27E-05 |
| usd_exchange_rate_at_block_timestamp | USD exchange rate of the token at the block timestamp | float | 8.96E-05 |
| last_activity_block_timestamp | Timestamp of the last activity involving the token | timestamp_ntz | 2024-06-24 21:17:13 |
| last_activity_block_slot | Slot number of the last activity involving the token | number | 273800058 |
| last_activity_block_hash | Hash of the block containing the last activity involving the token | varchar | BgaWmyUz3Ns1LJpD9vxTMCg5S21jXSBLrQxbjpcVbziH |
| last_activity_txn_index | Transaction index of the last activity involving the token | number | 244 |
| last_activity_txn_id | Transaction ID of the last activity involving the token | varchar | 3FutYunZXCK76pjpPQS2xMajs6sTmk5WkyAGVVGxK38LndMuX52U4FppoR8qUqhc4DzVwejpi8kJUrvhjpRwo3o8 |
| _updated_at__usd_exchange_rate_current | Timestamp of when the current USD exchange rate was last updated | timestamp_ntz | 2024-06-26 08:00:00 |
| _updated_at__unhydrated | Timestamp of when the data was last updated but not fully hydrated | timestamp_ntz | 2024-06-25 02:33:24 |
| _created_at | Timestamp of when the entry was created | timestamp_ntz | 2024-06-26 08:43:39.613 +0000 |
| _updated_at | Timestamp of when the entry was last updated | timestamp_ntz | 2024-06-26 08:43:39.613 +0000 |
| _changed_since_full_refresh | Boolean indicating if the entry has changed since the last full refresh | boolean | TRUE |