Resolutions 🌱 - Allium Documentation Hub

The polygon.predictions_onchain.resolutions table lists every resolved Polymarket market with its reported payouts and winning outcome. Each row represents one resolved market. This table contains no Polymarket API data.

Table Details

Property	Value
Table Name	`polygon.predictions_onchain.resolutions`
Table Status	Beta 🌱
Unique Key	`condition_id`

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Project name (ex. polymarket).
protocol	VARCHAR(16777216)	Protocol name (ex. polymarket).
market_unique_id	VARCHAR(16777216)	Unique key for grouping related markets.
condition_id	VARCHAR(16777216)	Unique condition identifier.
market_id	VARCHAR(16777216)	Neg-risk market identifier.
question_id	VARCHAR(16777216)	Unique question identifier.
question	VARCHAR(16777216)	Market question text published onchain.
neg_risk	BOOLEAN	Whether this is a NegRisk market.
oracle	VARCHAR(42)	Address that reported the resolution.
outcome_slot_count	NUMBER(38,0)	Number of possible outcomes for the market.
payout_numerators	VARCHAR(16777216)	Payouts reported for the first two outcomes, comma separated.
outcome	VARCHAR(16777216)	Resolution outcome: yes, no, 50/50, or unknown.
winning_outcome_index	NUMBER(38,0)	Outcome index (0-based) that won.
winning_outcome	VARCHAR(16777216)	Name of the winning outcome.
resolved_at	TIMESTAMP_NTZ(9)	Resolution timestamp.
block_number	NUMBER(38,0)	Block number of the resolution.
transaction_hash	VARCHAR(66)	Hash of the resolution transaction.

Sample Query

select *
from polygon.predictions_onchain.resolutions
where resolved_at >= '2026-10-18' and resolved_at < '2026-10-19'
limit 100

EVM

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query