| 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. |
| day | DATE | The date of the balance snapshot |
| user_address | VARCHAR(42) | The user: payer for deposits, payee for withdrawals. |
| token_id | VARCHAR(16777216) | Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Each unique token_id within a collection represents a distinct asset. |
| condition_id | VARCHAR(16777216) | Unique condition identifier for the market |
| market_unique_id | VARCHAR(16777216) | Unique key for grouping related markets |
| market_id | VARCHAR(16777216) | Internal Allium identifier for a market. Consistent across chains and protocol versions for the same logical market. |
| market_name | VARCHAR(16777216) | Human-readable name of the market, pool, or venue (e.g. ETH/USDC 0.3% for a DEX pool, USDC for a lending market). Resolved from onchain registry data. |
| question | VARCHAR(16777216) | Market question text |
| token_outcome | VARCHAR(16777216) | Token outcome name |
| is_winner | BOOLEAN | Whether this outcome won the market |
| category | VARCHAR(16777216) | Category or classification label for this record. The specific taxonomy depends on the model context (e.g. token category, transfer category, metric category). |
| sub_category | VARCHAR(16777216) | Specific subcategory |
| tags | VARCHAR(16777216) | Original category tokens from API |
| neg_risk | BOOLEAN | Whether this is a NegRisk market |
| resolution_outcome | VARCHAR(16777216) | Market resolution outcome if resolved |
| resolved_at | TIMESTAMP_NTZ(9) | Market resolution timestamp. Stored as timestamp_ntz(9) (UTC wall-clock, no timezone offset). |
| daily_buy_usd | FLOAT | USD spent buying outcome shares on this date. |
| daily_sell_usd | FLOAT | USD received from selling outcome shares on this date. |
| daily_split_usd | FLOAT | USD value of share splits on this date. |
| daily_merge_usd | FLOAT | USD value of share merges on this date. |
| daily_redeem_usd | FLOAT | USD value redeemed from resolved markets on this date. |
| daily_shares_in | FLOAT | Outcome shares received on this date. |
| daily_shares_out | FLOAT | Outcome shares sent on this date. |
| daily_event_count | NUMBER(38,0) | Number of position-changing events on this date. |
| cumulative_buy_usd | FLOAT | Running total USD spent on buys. |
| cumulative_sell_usd | FLOAT | Running total USD received from sells. |
| cumulative_split_usd | FLOAT | Running total USD value of share splits (collateral split into outcome shares). |
| cumulative_merge_usd | FLOAT | Running total USD value of share merges (combining outcome shares back to collateral). |
| cumulative_redeem_usd | FLOAT | Running total USD value redeemed from resolved markets. |
| cumulative_shares_in | FLOAT | Running total of outcome shares received. |
| cumulative_shares_out | FLOAT | Running total of outcome shares sent. |
| cumulative_shares_held | FLOAT | Running balance of outcome shares held. |
| cumulative_net_cash_flow_usd | FLOAT | Running net USD cash flow (outflows minus inflows) for the position. |
| cumulative_avg_buy_price | FLOAT | Running average buy price per share. |
| eod_shares_balance | FLOAT | End-of-day balance of outcome shares held. |
| eod_token_price | FLOAT | End-of-day price of the outcome token. |
| eod_position_value_usd | FLOAT | End-of-day USD value of the open position. |
| eod_total_pnl_usd | FLOAT | End-of-day total profit and loss in USD (realized + unrealized). |
| first_event_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the first position-changing event. |
| last_event_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent position-changing event. |
| 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. |
