| project | VARCHAR(134217728) | 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(134217728) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| pool | VARCHAR(44) | Address of the liquidity pool associated with this position or trade. |
| pool_token_0 | VARCHAR(44) | Mint address of the first token in this liquidity pool. |
| pool_token_1 | VARCHAR(44) | Mint address of the second token in this liquidity pool. |
| mint | VARCHAR(44) | 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. |
| symbol | VARCHAR(134217728) | 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. |
| raw_amount | VARCHAR(134217728) | Token amount in the smallest indivisible unit (not decimal-adjusted). Same concept as amount_raw — the column is named raw_amount in models that follow the raw_ prefix convention. |
| amount | FLOAT | Token amount normalized by the token’s decimal precision (amount_raw / 10^decimals). This is the human-readable value (e.g. 1.5 USDC rather than 1500000). |
| usd_amount | FLOAT | USD value of the token amount at the time of the event, computed using the hourly USD exchange rate. |
| delta_raw_amount | VARCHAR(134217728) | Net change in raw LP share quantity (not decimal-adjusted). |
| delta_amount | FLOAT | Net change in LP share quantity across all liquidity operations on this position. |
| usd_delta_amount | FLOAT | Net USD value change from a single liquidity operation. |
| post_tx_raw_balance | VARCHAR(134217728) | Raw token balance after the full transaction completed. |
| post_tx_balance | FLOAT | Token balance of the account after this transaction completed (decimal-adjusted). |
| usd_post_tx_balance | FLOAT | USD value of the token balance after this transaction. |
| 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. |
| pre_transfer_raw_balance | VARCHAR(134217728) | Raw token balance in the vault account before a transfer within a liquidity event. |
| post_transfer_raw_balance | VARCHAR(134217728) | Raw token balance in the vault account after a transfer within a liquidity event. |
| initiating_program_id_1 | VARCHAR(44) | Program ID of the first (outermost) program in the DEX call stack. |
| initiating_name_1 | VARCHAR(134217728) | Human-readable name of the first (outermost) program in the DEX call stack for this trade. |
| initiating_program_id_2 | VARCHAR(44) | Program ID of the second program in the DEX call stack. |
| initiating_name_2 | VARCHAR(134217728) | Human-readable name of the second program in the DEX call stack. |
| has_innermost | BOOLEAN | Whether the DEX call stack for this trade includes an innermost (deepest nested) program. |
| has_outermost | BOOLEAN | Whether the DEX call stack for this trade includes an outermost (top-level) program. |
| outermost_initiating_program_id | VARCHAR(44) | Program ID of the top-level (outermost) program in the DEX call stack. |
| outermost_initiating_name | VARCHAR(134217728) | Human-readable name of the top-level (outermost) program in the DEX call stack. |
| innermost_initiating_program_id | VARCHAR(44) | Program ID of the deepest (innermost) program in the DEX call stack. |
| innermost_initiating_name | VARCHAR(134217728) | Human-readable name of the deepest (innermost) program in the DEX call stack. |
| 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. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| unique_id | VARCHAR(134217728) | 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. |
