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

# Wallet PnL

> Realized, unrealized, and total profit and loss per Polymarket wallet

> [!NOTE]
>
> This is an **early access** dataset available through [SQL](https://docs.probalytics.io/docs/sql-guide/overview.md). To request access, email [support@probalytics.io](mailto:support@probalytics.io).

Profit and loss per wallet, built from [wallet positions](https://docs.probalytics.io/docs/datasets/polymarket-wallet-positions.md), in USDC (already divided by `1e6`).

| Field | Type | Values and meaning |
| - | - | - |
| `wallet` | `string` | Wallet address. |
| `realized_pnl` | `Float64` | Net cash minus fees, plus the payout value of shares in resolved conditions. |
| `unrealized_pnl` | `Float64` | Shares in unresolved conditions valued at each token's last on-chain trade price. |
| `total_pnl` | `Float64` | `realized_pnl + unrealized_pnl`. |
| `share_volume` | `Float64` | Shares traded. |
| `usdc_volume` | `Float64` | USDC traded. |
| `trades` | `UInt64` | Number of trades. |
| `net_cash_transfers` | `Float64` | Net collateral moved in by plain transfers. Excluded from PnL. |
| `open_positions` | `UInt64` | Tokens with a non-zero balance in unresolved conditions. |
| `oldest_open_price_time` | `DateTime \| null` | Oldest last-trade time among open positions. Shows how stale `unrealized_pnl` can be. |

```sql theme={null}
SELECT *
FROM polymarket_wallet_pnl
WHERE wallet = lower('0xYourWallet')
```

**Limitations**

* Resolution and last trade prices refresh about every minute, so the very latest blocks may be valued with slightly older prices.
* Combo positions have no on-chain resolution. They stay valued at the last trade price until redeemed.
* Tokens that never traded on-chain are valued at 0 until resolved.
* Shares held in a different wallet than the one that paid for them (for example, after a transfer) show as a loss in one wallet and a gain in the other.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.