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

### Table Details

| Property     | Value                                    |
| ------------ | ---------------------------------------- |
| Table Name   | `polygon.predictions.user_pnl_condition` |
| 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.                                                                                                                                                               |
| condition\_id             | VARCHAR(16777216) | Unique condition identifier for the market                                                                                                                                                                         |
| market\_unique\_id        | VARCHAR(16777216) | Unique key for grouping related markets                                                                                                                                                                            |
| market\_id                | VARCHAR(16777216) | Internal Allium identifier for a market. Consistent across chains and protocol versions for the same logical market.                                                                                               |
| market\_name              | VARCHAR(16777216) | Human-readable name of the market, pool, or venue (e.g. `ETH/USDC 0.3%` for a DEX pool, `USDC` for a lending market). Resolved from onchain registry data.                                                         |
| question                  | VARCHAR(16777216) | Market question text                                                                                                                                                                                               |
| category                  | VARCHAR(16777216) | Category or classification label for this record. The specific taxonomy depends on the model context (e.g. token category, transfer category, metric category).                                                    |
| sub\_category             | VARCHAR(16777216) | Specific subcategory                                                                                                                                                                                               |
| tags                      | VARCHAR(16777216) | Original category tokens from API                                                                                                                                                                                  |
| neg\_risk                 | BOOLEAN           | Whether this is a NegRisk market                                                                                                                                                                                   |
| resolution\_outcome       | VARCHAR(16777216) | Market resolution outcome if resolved                                                                                                                                                                              |
| resolved\_at              | TIMESTAMP\_NTZ(9) | Market resolution timestamp. Stored as `timestamp_ntz(9)` (UTC wall-clock, no timezone offset).                                                                                                                    |
| 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.                                                                                                                                         |
| residual\_value\_usd      | FLOAT             | USD value of unredeemed shares in resolved markets.                                                                                                                                                                |
| 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.           |
| total\_trade\_volume\_usd | FLOAT             | Total USD trade volume (buys + sells).                                                                                                                                                                             |
| buy\_count                | NUMBER(38,0)      | Number of buy fills.                                                                                                                                                                                               |
| sell\_count               | NUMBER(38,0)      | Number of sell fills.                                                                                                                                                                                              |
| event\_count              | NUMBER(38,0)      | Total number of position-changing events.                                                                                                                                                                          |
| first\_event\_at          | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the first position-changing event.                                                                                                                                                              |
| last\_event\_at           | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the most recent position-changing event.                                                                                                                                                        |
| 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.                              |