User Positions
Chain
PolymarketDataset name
polymarket.user_positionsVersion
3.0.0Description
Keeps track of outcome token positions along with pnl specific data including average price and realized pnl.
Example data
| user_id | token_id | amount | avg_price | realized_pnl | total_bought | last_block | last_log_index | last_updated_at |
|---|---|---|---|---|---|---|---|---|
| 0x47e811074538fbe641e55c2ebc8d786c593cc681 | 114793892740393962626630492624877542882946300759236562661703170722171757805063 | 669600000 | 476328 | 0 | 669600000 | 88970448 | 186 | 1782160681456866 |
| 0xc7534c4fc0a7bde26c29930c71eae1a154bfb617 | 95654142045505054989095962037172915409663382256029788980152374471575735689315 | 0 | 982000 | -165000 | 11000000 | 88970448 | 177 | 1782160681456866 |
| 0xdc669ba0adb45448020025f756070492d1070533 | 56476400372082861979805071198322485906629258656732764555292877550253394965519 | 533207384 | 433059 | 33154994 | 711432363 | 88970449 | 615 | 1782160681265148 |
Schema
| Column | Type |
|---|---|
| user_id | string |
| token_id | string |
| amount | string |
| avg_price | string |
| realized_pnl | string |
| total_bought | string |
| last_block | long |
| last_log_index | int |
| last_updated_at | long |