> ## 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 Lifetime 🌱

### Table Details

| Property     | Value                                   |
| ------------ | --------------------------------------- |
| Table Name   | `polygon.predictions.user_pnl_lifetime` |
| Table Status | Beta 🌱                                 |

### 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.                                                                 |
| 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, losers at $0).                                                                                                                   |
| 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.                              |