| 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. |
| 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. |
| is_unlinked_proxy | BOOLEAN | True when no on-chain owner exists (MagicLink); the proxy stands in as its own owner. |
| n_proxies | NUMBER(38,0) | Distinct proxy wallets merged into this owner. |
| 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. |
| total_fills | NUMBER(38,0) | Lifetime maker-side OrderFilled fills across all markets. |
| markets | NUMBER(38,0) | Distinct markets (condition_ids) ever traded. |
| legs | NUMBER(38,0) | Number of distinct wallet x token positions (one row in the positions layer) the wallet has ever held via fills. |
| 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. |
| any_attribution_suspect | BOOLEAN | True if ANY of the owner’s proxies is attribution-suspect (conservative propagation). |
| 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. |
| _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. |
