User Positions Daily 🌱

The polygon.predictions.user_positions_daily view provides daily snapshots of user holdings across all prediction markets. Each row represents a user’s position in a specific outcome token on a given day, enriched with comprehensive market metadata. Use this view for portfolio analysis, position tracking, exposure calculation, and understanding user investment patterns across different market categories.

Table Details

Property	Value
Table Name	`polygon.predictions.user_positions_daily`
Table Status	Beta 🌱

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Project name (ex. polymarket).
protocol	VARCHAR(16777216)	Protocol name (ex. polymarket).
day	DATE	Date of the position snapshot.
address	VARCHAR(42)	User wallet address holding the position.
token_address	VARCHAR(42)	Conditional Tokens contract address.
token_id	VARCHAR(16777216)	Token ID for the specific outcome token.
token_balance	FLOAT	Number of outcome tokens held (cumulative balance).
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)	Market identifier from onchain data.
market_name	VARCHAR(16777216)	Market name (uses question for single markets).
market_description	VARCHAR(16777216)	Market description from onchain events.
question_id	VARCHAR(16777216)	Unique question identifier.
question	VARCHAR(16777216)	Market question text.
question_description	VARCHAR(16777216)	Market description from API.
token_name	VARCHAR(16777216)	Combined outcome and question name.
token_outcome	VARCHAR(16777216)	Token outcome name (Yes/No).
is_winner	BOOLEAN	Whether this outcome won the market.
market_active	BOOLEAN	Whether market is currently active.
market_closed	BOOLEAN	Whether market is closed.
market_accepting_orders	BOOLEAN	Whether market is accepting new orders.
category	VARCHAR(16777216)	Main market category.
sub_category	VARCHAR(16777216)	Specific market subcategory.
tags	VARCHAR(16777216)	API category tags.
neg_risk	BOOLEAN	Whether this is a NegRisk market.
resolved_by	VARCHAR(16777216)	Entity responsible for resolution.
oracle	VARCHAR(42)	Oracle contract address for market resolution.
resolution_outcome	VARCHAR(16777216)	Market resolution outcome if resolved.
resolved_at	TIMESTAMP_NTZ(9)	Market resolution timestamp.
unique_id	VARCHAR(16777216)	Unique identifier combining day, address, and token_id (format ‘day-YYYY-MM-DD_address-_token_id-’).

Understanding Position Data

If a user had a position on a previous day but no activity on a given day, the position carries forward.
token_balance represents the cumulative balance of tokens held, not just the change.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Table Columns

Understanding Position Data

​Table Details

​Table Columns

​Understanding Position Data

Table Details

Table Columns

Understanding Position Data