Markets - Allium Documentation Hub

The polygon.predictions.markets table provides metadata for prediction markets, combining API data, onchain events, and resolution outcomes at the token level. Each row represents a specific outcome token within a market. Use this table to discover markets, analyze resolution patterns, and understand market structure across different categories.

Table Columns

Unique Key: market_unique_id, token_id

Column Name	Data Type	Description
project	VARCHAR	Project name (ex. polymarket).
protocol	VARCHAR	Protocol name (ex. polymarket).
market_unique_id	VARCHAR	Unique key for grouping related markets.
condition_id	VARCHAR	Unique condition identifier.
market_id	VARCHAR	Market identifier.
market_request_id	VARCHAR	NegRisk market request ID.
market_name	VARCHAR	Market name from onchain data.
market_description_onchain	VARCHAR	Market description from onchain events.
question_id	VARCHAR	Unique question identifier.
question	VARCHAR	Market question text.
description	VARCHAR	Market description from API.
token_id	VARCHAR	Token ID for this outcome.
token_outcome	VARCHAR	Token outcome name.
token_name	VARCHAR	Combined outcome and question name.
token_price	FLOAT	Current token price.
is_winner	BOOLEAN	Whether this outcome won.
active	BOOLEAN	Whether market is active.
archived	BOOLEAN	Whether market is archived.
closed	BOOLEAN	Whether market is closed.
accepting_orders	BOOLEAN	Whether accepting new orders.
enable_order_book	BOOLEAN	Whether order book is enabled.
neg_risk	BOOLEAN	Whether this is a NegRisk market.
resolved_by	VARCHAR	Entity responsible for resolution.
category	VARCHAR	Main category.
sub_category	VARCHAR	Specific subcategory.
tags	VARCHAR	Original category tokens.
api_category	VARCHAR	Original category from API before categorization.
api_type	VARCHAR	API data source type.
start_date	TIMESTAMP_NTZ(9)	Market start time.
end_date	TIMESTAMP_NTZ(9)	Market end time.
game_start_time	TIMESTAMP_NTZ(9)	Event start time.
seconds_delay	NUMBER	Resolution delay in seconds.
fpmm	VARCHAR	FPMM contract address.
maker_fee	FLOAT	Maker fee.
taker_fee	FLOAT	Taker fee.
oracle	VARCHAR	Oracle contract address.
fee_bips	NUMBER	Fee in basis points.
prepared_at	TIMESTAMP_NTZ(9)	Market preparation timestamp.
outcome	VARCHAR	Resolution outcome.
resolved_at	TIMESTAMP_NTZ(9)	Resolution timestamp.
created_at	TIMESTAMP_NTZ(9)	API record creation time.
updated_at	TIMESTAMP_NTZ(9)	API record update time.

Sample Query

Market Category Diversity

Find market category diversity:

select
  category, 
  count(*) as category_count
from polygon.predictions.markets 
group by category
order by category_count desc

​Table Columns

​Sample Query

Table Columns

Sample Query