| 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. |
| user_address | VARCHAR(42) | The user: payer for deposits, payee for withdrawals. |
| 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 |
| 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). |
| trade_buy_usd | FLOAT | USD paid buying outcome tokens (maker-side fills). |
| trade_sell_usd | FLOAT | USD received selling outcome tokens (maker-side fills). |
| split_outflow_usd | FLOAT | Collateral spent splitting into full outcome-token sets. |
| merge_inflow_usd | FLOAT | Collateral received from merging full outcome-token sets. |
| redeem_payout_usd | FLOAT | Direct CTF/NegRisk redeem payouts plus wrapped (pUSD) auto-redeem payouts. |
| residual_value_usd | FLOAT | USD value of unredeemed shares in resolved markets. |
| total_pnl_usd | FLOAT | Lifetime profit/loss in USD by the unified share-flow method: SUM(position pnl) + merge inflow - split outflow + wrapped auto-redeem payouts. Open positions are included at their latest snapshot mark. |
| total_trade_volume_usd | FLOAT | Total USD trade volume (buys + sells). |
| buy_count | NUMBER(38,0) | Number of buy fills. |
| sell_count | NUMBER(38,0) | Number of sell fills. |
| event_count | NUMBER(38,0) | Total number of position-changing events. |
| 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. |
