| date | TIMESTAMP_NTZ(9) | End-of-day date (UTC) of the balance snapshot. |
| project | VARCHAR(16777216) | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| lending_id | VARCHAR(16777216) | Internal Allium identifier for a lending position or market instance. Used to join lending event tables with position or market metadata. |
| 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. |
| 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. |
| 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 | FLOAT | Sum of end-of-day token balances for this address_type. |
| balance_str | VARCHAR(16777216) | Normalized token balance stored as a string for full precision. Equivalent to balance but avoids floating-point truncation. |
| 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. |
| token_name | VARCHAR(16777216) | Full name of the token (e.g. “USD Coin”, “Wrapped Ether”). |
| symbol | VARCHAR(16777216) | Ticker symbol of this token or asset. Short alias for token_symbol used in tables that preserve the original blockchain field naming convention. |
| decimals | NUMBER(38,0) | Number of decimal places for this token. Short alias for token_decimals used in tables that preserve the original blockchain field naming convention. |
| _extras | VARIANT | Additional protocol-specific fields not part of the standard schema. |
| 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 |
| last_activity_block_hash | VARCHAR(16777216) | Hash of the block that last changed this balance. |
| 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. |
