| 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. |
| 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 |
| token_outcome | VARCHAR(16777216) | Token outcome name |
| 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 |
| position_status | VARCHAR(16777216) | Lifecycle status - open (unresolved balance), resolved_unredeemed (resolved balance awaiting redeem), closed (no balance). |
| bought_usd | FLOAT | Total USD spent buying outcome shares. |
| sold_usd | FLOAT | Total USD received from selling outcome shares. |
| bought_units | FLOAT | Total outcome shares bought. |
| sold_units | FLOAT | Total outcome shares sold. |
| open_units | FLOAT | Outcome shares currently held (open position size). |
| open_value_usd | FLOAT | USD value of the open position at current prices. |
| redeem_payout_usd | FLOAT | Direct CTF/NegRisk redeem payouts plus wrapped (pUSD) auto-redeem payouts. |
| position_pnl_usd | FLOAT | Position pnl with open legs re-marked at the latest hourly price; all other rows identical to the base table. |
| n_fills | NUMBER(38,0) | Number of order fills. |
| n_orders | NUMBER(38,0) | Number of distinct orders. |
| first_fill_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the first fill. |
| last_fill_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent fill. |
| wallet_attribution_quality | VARCHAR(16777216) | Owning wallet’s CURRENT attribution_quality (see flag timing caveat in the model header). Whether the pnl NUMBER is trustworthy. ‘suspect’ = the buy-skew + phantom-loss signature of maker-side-only fill attribution (imbalance_ratio > 0.3 AND total_pnl_usd < -$500): a two-sided market maker whose offsetting fills executed as taker has its sell leg uncredited, so the loss is an artifact of measurement, not trading. The pnl stays populated; downstream consumers may null or exclude it. |
| wallet_activity_tier | VARCHAR(16777216) | Owning wallet’s CURRENT activity_tier (see flag timing caveat in the model header). Wallet activity segmentation: casual (500). Segmentation only, never an exclusion: roughly a third of lifetime-profitable wallets exceed 500 fills, so high fill count indicates activity, not measurement error. |
| wallet_is_mm_or_bot | BOOLEAN | Whether the wallet is classified as a market maker or bot. |
| wallet_total_pnl_usd | FLOAT | Total profit and loss in USD across all the wallet’s positions. |
| _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. |
