| 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. |
| profile_url | VARCHAR(16777216) | Polymarket profile URL for the wallet, when registered. |
| 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). |
| 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. |
| maker_rebate_usd | FLOAT | Total maker rebates earned in USD. |
| residual_portfolio_value_usd | FLOAT | Open positions marked to the latest daily snapshot price (resolved winners at 1,losersat0). |
| total_trade_volume_usd | FLOAT | Total USD trade volume (buys + sells). |
| total_trades | NUMBER(38,0) | Total number of individual trades executed in this transaction. |
| distinct_conditions | NUMBER(38,0) | Number of distinct market conditions the user has traded. |
| resolved_conditions | NUMBER(38,0) | Number of the user’s traded conditions that have resolved. |
| resolved_winning_conditions | NUMBER(38,0) | Number of resolved conditions where the user held the winning outcome. |
| unresolved_conditions | NUMBER(38,0) | Number of the user’s traded conditions not yet resolved. |
| win_rate_pct | FLOAT | Percentage of resolved conditions where the user held the winning outcome. |
| distinct_categories | NUMBER(38,0) | Number of distinct market categories the user has traded. |
| 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. |
| wallet_created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the wallet’s first on-chain activity. |
| wallet_type | VARCHAR(16777216) | wallet type description |
| new_wallet_flag | VARCHAR(16777216) | Whether the wallet was newly created shortly before trading. |
| is_market_maker | BOOLEAN | Whether the wallet is flagged as a market maker. |
| is_bonder | BOOLEAN | Whether the wallet is flagged as a bonder (posts bonds in market resolution). |
| is_insider | BOOLEAN | Whether the wallet is flagged as a potential insider based on trading patterns. |
| trader_type | VARCHAR(16777216) | Classification of the trader (e.g. retail, market maker, bot). |
| bonder_avg_entry_price | FLOAT | Average entry price across positions for wallets flagged as bonders. |
| insider_winning_avg_entry | FLOAT | Average entry price on winning positions for wallets flagged as potential insiders. |
| median_days_before_resolution | FLOAT | Median number of days before market resolution that the user entered positions. |
| is_polymarket_registered_wallet | BOOLEAN | Whether the wallet is registered with a Polymarket profile. |
| 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. |
