Table Variants
| Table | Description |
|---|---|
| solana.assets.balances_daily | All balances, SOL and SPL tokens |
| solana.assets.sol_balances_daily | All SOL balances, including voting txns, nonvoting txns, staking/validator rewards |
| solana.assets.nonvoting_sol_balances_daily | All SOL balances, including nonvoting txns only |
| solana.assets.spl_token_balances_daily | All SPL token balances |
Table Columns
| Column Name | Description | Type | Example |
|---|---|---|---|
| date | Date of the daily balance snapshot | timestamp_ntz | 2024-07-01 00:00:00.000 |
| address | Address of the token holder | varchar | 4CKFRwj6YzVygMptmFtZgBNNn7zyCsVibM8Aq5pG252v |
| token_account | Token account associated with the token holder, only applicable for SPL balances | varchar | 8TfpcEJYwJrSx9XNHqLZCBhYuJkbcF3K1z5TySq52pjh |
| mint | Mint address of the token | varchar | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v |
| token_name | Name of the token | varchar | USD Coin |
| token_symbol | Symbol of the token | varchar | USDC |
| decimals | Number of decimal places the token can be divided into | number | 6 |
| raw_amount_str | Raw amount of the token as a string for precision | varchar | 62388106652 |
| raw_amount | Raw amount of the token | float | 62388106652 |
| amount_str | Amount of the token in string format for precision | varchar | 62388.10665 |
| amount | Amount of the token | float | 62388.10665 |
| usd_exchange_rate | USD exchange rate of the token | float | 1.27E-05 |
| usd_amount | USD value of the balance | float | 0.8110453865 |
| last_block_timestamp_activity | Timestamp of the last activity involving the token | timestamp_ntz | 2024-06-24 21:17:13 |
| last_block_slot_activity | Slot number of the last activity involving the token | number | 273800058 |
| last_block_hash_activity | Hash of the block containing the last activity involving the token | varchar | BgaWmyUz3Ns1LJpD9vxTMCg5S21jXSBLrQxbjpcVbziH |
| _created_at | Timestamp of when the entry was created | timestamp_ltz | 2024-06-26 08:43:39.613 +0000 |
| _updated_at | Timestamp of when the entry was last updated | timestamp_ltz | 2024-06-26 08:43:39.613 +0000 |