> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# User Pnl By Owner 🌱

### Table Details

| Property            | Value                                   |
| ------------------- | --------------------------------------- |
| Table Name          | `polygon.predictions.user_pnl_by_owner` |
| Table Status        | Beta 🌱                                 |
| Clustering Key(s)   | `owner_eoa`                             |
| Search Optimization | `owner_eoa`                             |

### Table Columns

| Column Name                     | Data Type         | Description                                                                                                                                                                                                                                                                                                                          |
| ------------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 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, losers at $0).                                                                                                                                                                                                                                     |
| 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.                                                                                                                                                                                                                                                                        |