| day | TIMESTAMP_NTZ(9) | The date of the balance snapshot |
| epoch | NUMBER(38,0) | Epoch number. On Sui, epochs are ~24 hour periods used for validator rotation and staking rewards. On Solana, epochs are voting periods. On Cosmos, epoch is a governance/staking cycle. |
| stake_account | VARCHAR(16777216) | Public key address of the Solana stake account |
| action | VARCHAR(16777216) | High-level action or operation type for this record. Values are model-specific (e.g. deposit, withdraw, stake, unstake in staking models). |
| delegated_stake | FLOAT | Amount of lamports delegated to a validator from this stake account |
| active_stake | FLOAT | The amount of active stake in the validator’s pool |
| inactive_stake | FLOAT | The amount of inactive stake in the validator’s pool |
| total_rewards | FLOAT | The total rewards earned by the validator on this date |
| delegated_vote_account | VARCHAR(16777216) | Vote account address of the validator this stake account is delegated to |
| last_activation_epoch | NUMBER(38,0) | Most recent epoch in which this stake account began activating |
| last_deactivation_epoch | NUMBER(38,0) | Most recent epoch in which this stake account began deactivating |
| activation_status | VARCHAR(16777216) | Current activation state of this stake account: activating, active, deactivating, or inactive |
| action_info | VARIANT | Structured metadata describing the type of staking action (delegation, activation, deactivation, withdrawal) |
| block_slot | NUMBER(38,0) | Solana slot number in which this transaction was confirmed. Slots are the fundamental unit of time on Solana (analogous to block numbers on EVM chains). Not every slot produces a block. |
| block_height | NUMBER(38,0) | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike block_slot, this only increments for slots that produced a block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_hash | VARCHAR(44) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| txn_id | VARCHAR(88) | Base58-encoded transaction signature on Solana. Analogous to transaction_hash on EVM chains. Uniquely identifies a transaction. |
| txn_index | NUMBER(38,0) | Zero-based position of this transaction within its slot. |
| instruction_index | NUMBER(38,0) | Zero-based position of this instruction within the transaction’s top-level instructions array. |
| inner_instruction_index | NUMBER(38,0) | Zero-based position of this inner instruction within its parent instruction’s inner instructions array. -1 for top-level instructions that are not inner instructions. |
| pseudo_global_order | NUMBER(38,0) | Internal ordering key combining block slot and transaction index to define a globally-consistent event ordering on Solana. Used for incremental processing and deduplication. |
| pre_tx_amount | VARCHAR(16777216) | Account balance in lamports before this specific transaction, used for balance change calculation |
| post_tx_amount | VARCHAR(16777216) | Account balance in lamports after this specific transaction, used for balance change calculation |
| 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. |
