polymarket_polygon.market_details

The polymarket_polygon.market_details table contains enriched market metadata for Polymarket prediction markets, combining on-chain data with market metadata from the Polymarket API. Grain: one row per outcome token (token_id) — two rows per market. Combos (multi-leg parlays) have their own dimension table, combo_details, at the same grain.

Table Schema

Column	Type	Description
`unique_key`	`VARCHAR`	API record key: the neg-risk `event_market_id` for neg-risk markets, the `condition_id` for single markets
`condition_id`	`VARCHAR`	CTF condition ID of the market as a `0x...` varchar, shared by its two outcome tokens
`event_market_id`	`VARCHAR`	NegRiskAdapter market ID of the overarching multi-outcome event; NULL for single (non-neg-risk) markets
`event_market_name`	`VARCHAR`	Overarching event question for neg-risk markets (e.g. `Presidential Election 2024`); `single market` otherwise
`event_market_description`	`VARCHAR`	Overarching event description; NULL for single markets
`question_id`	`VARCHAR`	UMA/adapter question ID of the market as a `0x...` varchar
`question`	`VARCHAR`	Concrete outcome being bet on (e.g. `Will X happen by Y date?`)
`market_description`	`VARCHAR`	Market description text from the API
`token_id`	`UINT256`	CTF ERC-1155 outcome token ID — the table’s grain, two rows per market
`token_outcome`	`VARCHAR`	Label of this token’s side, e.g. `Yes`/`No` (some markets use other labels like `Up` or team names)
`token_outcome_name`	`VARCHAR`	The token’s side and question in one label, e.g. `Yes-Will X happen?`
`active`	`VARCHAR`	Whether the market is active
`archived`	`VARCHAR`	Whether the market is archived
`closed`	`VARCHAR`	Whether the market is closed
`accepting_orders`	`VARCHAR`	Whether the market is accepting orders
`enable_order_book`	`VARCHAR`	Whether the order book is enabled
`neg_risk`	`VARCHAR`	Whether it’s a negative risk market
`polymarket_link`	`VARCHAR`	Link to the Polymarket event page (may be broken for archived markets)
`market_start_time`	`VARCHAR`	Start time of the market
`market_end_time`	`VARCHAR`	End time of the market
`game_start_time`	`VARCHAR`	Scheduled start of the underlying game/event for sports markets
`seconds_delay`	`VARCHAR`	Order-matching delay in seconds (used on live/in-game markets)
`fpmm`	`VARCHAR`	Address of the market’s legacy FPMM (AMM) pool where one exists
`icon`	`VARCHAR`	Market icon URL
`image`	`VARCHAR`	Market image URL
`tags`	`VARCHAR`	Market category tags from the API
`oracle`	`VARBINARY`	Oracle address from the on-chain MarketPrepared event; NULL for single markets
`fee_bips`	`UINT256`	Fee bips from the on-chain MarketPrepared event; NULL for single markets
`outcome`	`VARCHAR`	Market resolution: `yes`, `no`, `50/50`, or `unresolved`
`resolved_on_timestamp`	`TIMESTAMP`	When the market was resolved; NULL while unresolved
`last_uploaded_at`	`TIMESTAMP`	API snapshot stamp for this record (single value across all rows per upload)
`content_hash`	`VARBINARY`	Hash over every content column, used to detect real per-token changes between snapshots
`last_changed_at`	`TIMESTAMP`	Per-token time the market record last actually changed; advances only when `content_hash` differs from the prior row

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

polymarket_polygon.market_details

Table Schema

Table sample

​Table Schema

​Table sample

Table Schema

Table sample