| 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. |
| creation_type | VARCHAR(16777216) | Type of wallet creation (MagicLink or GnosisSafe) |
| owner_eoa | VARCHAR(42) | Controlling externally-owned account (EOA) of the Polymarket proxy, from the deterministic ProxyCreation event (1:1). Null for MagicLink wallets, which have no on-chain owner event. |
| owner_source | VARCHAR(16777216) | Method used to resolve the proxy wallet to its owner EOA. |
| first_funder_eoa | VARCHAR(42) | First EOA that funded this wallet. |
| funder_entity | VARCHAR(16777216) | Entity attribution of the wallet’s first funder. |
| funder_label | VARCHAR(16777216) | Label of the wallet’s first funder. |
| 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. |
| trade_buy_usd | FLOAT | USD paid buying outcome tokens (maker-side fills). |
| trade_sell_usd | FLOAT | USD received selling outcome tokens (maker-side fills). |
| redeem_payout_usd | FLOAT | Direct CTF/NegRisk redeem payouts plus wrapped (pUSD) auto-redeem payouts. |
| merge_inflow_usd | FLOAT | Collateral received from merging full outcome-token sets. |
| split_outflow_usd | FLOAT | Collateral spent splitting into full outcome-token sets. |
| residual_portfolio_value_usd | FLOAT | Open positions marked to the latest daily snapshot price (resolved winners at 1,losersat0). |
| turnover_usd | FLOAT | trade_buy_usd + trade_sell_usd. |
| imbalance_ratio | FLOAT | /trade_buy_usd - trade_sell_usd/ / (trade_buy_usd + trade_sell_usd). Values near 1 with large negative pnl are the maker-side attribution artifact flagged by attribution_quality. |
| total_fills | NUMBER(38,0) | Lifetime maker-side OrderFilled fills across all markets. |
| total_orders | NUMBER(38,0) | Distinct order hashes behind those fills. |
| legs | NUMBER(38,0) | Number of distinct wallet x token positions (one row in the positions layer) the wallet has ever held via fills. |
| markets | NUMBER(38,0) | Distinct markets (condition_ids) ever traded. |
| open_legs | NUMBER(38,0) | Positions currently open (unresolved, balance > 0). |
| unredeemed_legs | NUMBER(38,0) | Positions resolved but not yet redeemed (balance > 0). |
| attribution_quality | VARCHAR(16777216) | 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. |
| activity_tier | VARCHAR(16777216) | 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. |
| is_mm_or_bot | BOOLEAN | True = the wallet matches the market-maker / bot signature, in one predicate: total_fills > 500 OR (imbalance_ratio > 0.3 AND total_pnl_usd < -$500). total_pnl_usd is low confidence for these wallets - exclude them for retail-only or leaderboard-style analysis. Composed from attribution_quality and activity_tier. |
| two_sided_conditions | NUMBER(38,0) | Count of distinct conditions in which the wallet traded more than one outcome token (both trade legs). A market-maker signal: high counts indicate two-sided MM activity that maker-side attribution mis-prices. Surfaced for filtering; does not gate total_pnl_usd (is_mm_or_bot remains the reliability gate). |
| first_trade_at | TIMESTAMP_NTZ(9) | Timestamp of the wallet’s first fill. |
| last_trade_at | TIMESTAMP_NTZ(9) | Timestamp of the wallet’s last fill. |
| _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. |
