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 Details

Property	Value
Table Name	`polygon.predictions.markets`
Table Status	Beta 🌱
Unique Key	`market_unique_id`, `token_id`
Clustering Key(s)	`category`
Search Optimization	`condition_id`, `question_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)	Market identifier.
market_request_id	VARCHAR(16777216)	NegRisk market request ID.
market_name	VARCHAR(16777216)	Market name from onchain data.
market_description_onchain	VARCHAR(16777216)	Market description from onchain events.
question_id	VARCHAR(16777216)	Unique question identifier.
question	VARCHAR(16777216)	Market question text.
description	VARCHAR(16777216)	Market description from API.
token_id	VARCHAR(16777216)	Token ID for this outcome.
token_outcome	VARCHAR(16777216)	Token outcome name.
token_name	VARCHAR(16777216)	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(16777216)	Entity responsible for resolution.
category	VARCHAR(16777216)	Main category.
sub_category	VARCHAR(16777216)	Specific subcategory.
tags	VARCHAR(16777216)	Original category tokens.
api_category	VARCHAR(16777216)	Original category from API before categorization.
api_type	VARCHAR(16777216)	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	FLOAT	Resolution delay in seconds.
fpmm	VARCHAR(16777216)	FPMM contract address.
maker_fee_legacy_v1	VARCHAR(16777216)	V1 maker base fee from the API. Renamed from `maker_fee` post V2 cutover; the V2 canonical is `maker_base_fee_bps` plus `fee_rate` / `fee_exponent`.
taker_fee_legacy_v1	VARCHAR(16777216)	V1 taker base fee from the API. Renamed from `taker_fee` post V2 cutover; the V2 canonical is `taker_base_fee_bps` plus `fee_rate` / `fee_exponent`.
oracle	VARCHAR(42)	Oracle contract address.
fee_bips	VARCHAR(16777216)	Fee in basis points.
prepared_at	TIMESTAMP_NTZ(9)	Market preparation timestamp.
fee_type	VARCHAR(16777216)	V2 fee scheme classifier (e.g. ‘cubic_v0’). Null for pre-V2 markets and non-CLOB rows.
fees_enabled	BOOLEAN	V2 kill-switch. True when fees are charged on this market.
rfq_enabled	BOOLEAN	Whether the market accepts RFQ orders.
fee_rebate_rate	FLOAT	V2 maker fee rebate rate (0.0-1.0). Applied when the maker rebate program is on.
fee_rate	FLOAT	V2 base fee rate parameter for the cubic fee curve.
fee_exponent	FLOAT	V2 cubic fee curve exponent.
fee_taker_only	BOOLEAN	V2 flag - true when only the taker is charged a fee.
maker_base_fee_bps	NUMBER(38,0)	V2 base maker fee in basis points (1 bps = 0.01%).
taker_base_fee_bps	NUMBER(38,0)	V2 base taker fee in basis points.
extras	VARIANT	Pristine passthrough of the source `_extra_fields` VARIANT. Contains Gemini-native nested payload (event.participants, event.termsLink, event.socialImageUrl, event.template, event.eventTags) that was not promoted to top-level source columns.
outcome	VARCHAR(16777216)	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