Table Details
| Property | Value |
|---|---|
| Table Name | solana.dex.balances_eod |
| Table Status | Production-Ready |
| Unique Key | block_date, liquidity_pool_address, token_account, mint |
| Clustering Key(s) | block_date, liquidity_pool_address |
| Search Optimization | liquidity_pool_address, mint |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) derived from block_timestamp. Used as a partition key in incremental models. |
| 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. |
| liquidity_pool_address | VARCHAR(44) | Contract address of the liquidity pool where this trade was executed. Null when the routing path is not emitted by the event (common for aggregator trades). |
| token_account | VARCHAR(44) | 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(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. |
| 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. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| 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. |
| _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. |