User Positions Daily 🌱 - Allium Documentation Hub

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)	Contract that issued the outcome token.
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.
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)	Category tags published by the venue.
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, token_address, and token_id (format ‘day-YYYY-MM-DD_address-_token_address-_token_id-’).

Understanding Position Data

A row exists for every day a user holds a position, including days with no activity.
token_balance represents the cumulative balance of tokens held, not just the change.
The same token_id on different token_address values is a different position.

​Table Details

​Table Columns

​Understanding Position Data

Table Details

Table Columns

Understanding Position Data