| date | DATE | End-of-day date (UTC) of the balance snapshot. |
| 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. |
| mint | VARCHAR(16777216) | 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. |
| product_id | VARCHAR(16777216) | Internal Allium identifier for the stablecoin product. Groups together the canonical and bridged variants of the same stablecoin on the same chain. |
| currency | VARCHAR(16777216) | Fiat currency this stablecoin is pegged to, as an ISO 4217 code in lowercase (e.g. usd, eur, jpy). |
| token_name | VARCHAR(16777216) | Full name of the token (e.g. “USD Coin”, “Wrapped Ether”). |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. “USDC”, “WETH”). |
| 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. |
| 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. |
| multiplier | FLOAT | Scale factor applied to convert the raw token amount into the displayed token units. |
| usd_balance | FLOAT | USD value of the token balance, computed using the exchange rate at the time of the balance snapshot. |
| 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. |
| holder_rank | NUMBER(38,0) | Rank of this holder by balance, among all holders of the same token_address on the same date (1 = largest balance). |
| price_source | VARCHAR(16777216) | Source used to obtain the price for this asset (e.g. dex_twap, cex_vwap, coingecko, manual). |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block that last changed this balance. |
| last_activity_block_slot | NUMBER(38,0) | Solana slot number of the block containing the most recent activity for this account |
| 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. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
