Market Metadata

Description of Each Table/View and Explanation of All Fields

raw_market_meta

This table contains Polymarket market metadata in a denormalized form. It is intended for analytics, search, and building data marts: question text, description, market status, order book parameters, volumes, liquidity, sports attributes, images, and more.

Important: a single market entity may have multiple outcomes; therefore, the table stores records at the (market id, outcome) level.

• id (String) — market identifier (market id) in Polymarket.

• question (Nullable(String)) — market title/question displayed to users.

• condition_id (String) — identifier of the condition in the Conditional Tokens protocol to which the market is linked.

• slug (Nullable(String)) — human-readable identifier, typically used in URLs/routes.

• twitter_card_image (Nullable(String)) — link to a preview image (e.g., Twitter card), if provided.

• resolution_source (Nullable(String)) — source used to determine the outcome (link/description of the source).

• end_date (Nullable(DateTime64(3))) — market end date/time (event/market deadline), with milliseconds.

• start_date (Nullable(DateTime64(3))) — market start date/time (or event/period start), with milliseconds.

• category (Nullable(String)) — market category (e.g., Sports, Politics, etc.).

• amm_type (Nullable(String)) — AMM/liquidity mechanism type, if applicable for the market.

• sponsor_name (Nullable(String)) — market sponsor name (if any).

• sponsor_image (Nullable(String)) — link to the sponsor image/logo (if any).

• x_axis_value (Nullable(String)) — X-axis value/label (for markets with graphical scales/series).

• y_axis_value (Nullable(String)) — Y-axis value/label (for markets with graphical scales/series).

• denomination_token (Nullable(String)) — denomination/settlement token (e.g., USDC), if specified in metadata.

• fee (Nullable(String)) — configuration fee/fee parameter of the market (as provided in metadata; format may be string-based).

• lower_bound (Nullable(String)) — lower bound of the range (for range/numeric markets).

• upper_bound (Nullable(String)) — upper bound of the range (for range/numeric markets).

• description (Nullable(String)) — market rules text: how and under what conditions the market is resolved.

• outcome (Nullable(String)) — name of the specific outcome (e.g., Yes/No, Over/Under).

• outcome_price (Nullable(String)) — outcome price (as a string from metadata; often “0…1”).

• clob_token_id (String) — identifier of the outcome token in the CLOB (key for linking with trades).

• volume (Nullable(String)) — total market volume (as a string value from metadata).

• volume_num (Nullable(Float64)) — total market volume in numeric form (for analytics).

• active (Nullable(Bool)) — market is active and available for interaction (in platform logic).

• market_type (Nullable(String)) — market type (internal platform classification).

• format_type (Nullable(String)) — market format (e.g., single, totals, etc., depending on the platform).

• lower_bound_date (Nullable(String)) — lower bound of the range in date format (if the market is date/time-based).

• upper_bound_date (Nullable(String)) — upper bound of the range in date format (if the market is date/time-based).

• closed (Nullable(Bool)) — market is closed for trading (trading halted).

• market_maker_address (Nullable(String)) — address of the market maker/contract servicing the market (if applicable).

• created_by (Nullable(Int64)) — internal identifier of the creator (as represented in platform metadata).

• updated_by (Nullable(Int64)) — internal identifier of the updater (as represented in platform metadata).

• created_at (Nullable(DateTime64(3))) — market creation time (with milliseconds).

• updated_at (Nullable(DateTime64(3))) — time of the last market metadata update (with milliseconds).

• closed_time (Nullable(String)) — market close time (string representation, if provided).

• wide_format (Nullable(Bool)) — UI/data-mart flag: wide display format (if used).

• new (Nullable(Bool)) — UI/data-mart flag: market marked as “new”.

• mailchimp_tag (Nullable(String)) — marketing tag (used for mailings/segmentation, if applicable).

• featured (Nullable(Bool)) — UI/data-mart flag: “featured/recommended” market.

• archived (Nullable(Bool)) — market is archived (not active in the storefront, but retained).

• resolved_by (Nullable(String)) — who/what resolved the market (often an address or entity identifier).

• restricted (Nullable(Bool)) — market with access/availability restrictions.

• market_group (Nullable(Int64)) — identifier of a market group/set (if the market belongs to a group).

• group_item_title (Nullable(String)) — display title of the item within the group.

• group_item_threshold (Nullable(String)) — grouping threshold/parameter (e.g., “2”, “top-N”, etc., in platform logic).

• question_id (Nullable(String)) — question identifier (often linked to an oracle/resolution).

• uma_end_date (Nullable(String)) — UMA/oracle process deadline (string, if applicable).

• enable_order_book (Nullable(Bool)) — whether the order book (CLOB) is enabled for the market.

• order_price_min_tick_size (Nullable(Float64)) — minimum price tick size in the order book.

• order_min_size (Nullable(Float64)) — minimum order size in the order book.

• uma_resolution_status (Nullable(String)) — resolution status (e.g., proposed/resolved, etc.).

• curation_order (Nullable(Int64)) — curation order/priority (storefront sorting/ranking).

• liquidity_num (Nullable(Float64)) — liquidity in numeric form (for analytics).

• end_date_iso (Nullable(String)) — end date in ISO/string format.

• start_date_iso (Nullable(String)) — start date in ISO/string format.

• uma_end_date_iso (Nullable(String)) — UMA deadline in ISO/string format.

• has_reviewed_dates (Nullable(Bool)) — flag indicating that dates have been reviewed/confirmed (platform logic).

• ready_for_cron (Nullable(Bool)) — internal flag indicating readiness for periodic processes/updates (as in metadata).

• comments_enabled (Nullable(Bool)) — whether comments are enabled for the market.

• volume_24hr (Nullable(Float64)) — trading volume over the last 24 hours.

• volume_1wk (Nullable(Float64)) — trading volume over the last week.

• volume_1mo (Nullable(Float64)) — trading volume over the last month.

• volume_1yr (Nullable(Float64)) — trading volume over the last year.

• game_start_time (Nullable(String)) — game/match start time (string representation, if the market is sports-related).

• seconds_delay (Nullable(Int64)) — delay (in seconds) applied by the platform for updates/display/execution (if provided).

• disqus_thread (Nullable(String)) — discussion thread identifier (if used).

• short_outcome (Nullable(String)) — short/abbreviated outcome name.

• team_a_id (Nullable(String)) — team A identifier (if the market is sports-related).

• team_b_id (Nullable(String)) — team B identifier (if the market is sports-related).

• uma_bond (Nullable(String)) — UMA bond amount (if applicable).

• uma_reward (Nullable(String)) — UMA reward amount (if applicable).

• fpmm_live (Nullable(Bool)) — flag indicating live state/activity of the AMM (if applicable).

• volume_24hr_amm (Nullable(Float64)) — 24-hour volume attributable to the AMM.

• volume_1wk_amm (Nullable(Float64)) — weekly volume attributable to the AMM.

• volume_1mo_amm (Nullable(Float64)) — monthly volume attributable to the AMM.

• volume_1yr_amm (Nullable(Float64)) — yearly volume attributable to the AMM.

• volume_24hr_clob (Nullable(Float64)) — 24-hour volume attributable to the CLOB.

• volume_1wk_clob (Nullable(Float64)) — weekly volume attributable to the CLOB.

• volume_1mo_clob (Nullable(Float64)) — monthly volume attributable to the CLOB.

• volume_1yr_clob (Nullable(Float64)) — yearly volume attributable to the CLOB.

• volume_amm (Nullable(Float64)) — total volume attributable to the AMM.

• volume_clob (Nullable(Float64)) — total volume attributable to the CLOB.

• liquidity (Nullable(String)) — liquidity (as a string value from metadata).

• liquidity_amm (Nullable(Float64)) — liquidity attributable to the AMM.

• liquidity_clob (Nullable(Float64)) — liquidity attributable to the CLOB.

• maker_base_fee (Nullable(Int64)) — maker base fee (in market configuration, if specified).

• taker_base_fee (Nullable(Int64)) — taker base fee (in market configuration, if specified).

• custom_liveness (Nullable(Int64)) — custom liveness parameter for the oracle process (if applicable).

• accepting_orders (Nullable(Bool)) — whether the market is currently accepting orders (platform logic).

• notifications_enabled (Nullable(Bool)) — whether notifications are enabled for the market.

• score (Nullable(Int64)) — internal market score/rating (for ranking/storefront).

• image_optimized (Nullable(String)) — optimized image URL (if provided).

• icon_optimized (Nullable(String)) — optimized icon URL (if provided).

• event (Nullable(String)) — related event metadata (often a serialized object/string).

• tag (Nullable(String)) — tag or set of tags (as represented in metadata).

• category_meta (Nullable(String)) — extended category metadata (often serialized).

• creator (Nullable(String)) — creator information (as a metadata string field).

• ready (Nullable(Bool)) — market readiness flag (in platform terms).

• funded (Nullable(Bool)) — “market funded/initialized” flag (in platform terms).

• past_slugs (Nullable(String)) — previous slug values (history, often serialized).

• ready_timestamp (Nullable(DateTime64(3))) — time when the market became “ready” (if recorded).

• funded_timestamp (Nullable(DateTime64(3))) — time when the market became “funded” (if recorded).

• accepting_orders_timestamp (Nullable(DateTime64(3))) — time when the market started accepting orders (if recorded).

• competitive (Nullable(Float64)) — competitiveness/quality metric of the market (platform logic).

• rewards_min_size (Nullable(Float64)) — minimum size for participation in reward mechanisms (if applicable).

• rewards_max_spread (Nullable(Float64)) — maximum spread for reward mechanisms (if applicable).

• spread (Nullable(Float64)) — current spread (usually best_ask − best_bid in platform terms).

• automatically_resolved (Nullable(Bool)) — market is resolved automatically (if applicable).

• one_day_price_change (Nullable(Float64)) — price change over one day.

• one_hour_price_change (Nullable(Float64)) — price change over one hour.

• one_week_price_change (Nullable(Float64)) — price change over one week.

• one_month_price_change (Nullable(Float64)) — price change over one month.

• one_year_price_change (Nullable(Float64)) — price change over one year.

• last_trade_price (Nullable(Float64)) — price of the last trade.

• best_bid (Nullable(Float64)) — best bid price in the order book.

• best_ask (Nullable(Float64)) — best ask price in the order book.

• automatically_active (Nullable(Bool)) — market is activated automatically (if applicable).

• clear_book_on_start (Nullable(Bool)) — whether the order book is cleared at event start (if applicable).

• chart_color (Nullable(String)) — chart color (storefront/UI field).

• series_color (Nullable(String)) — series color (storefront/UI field).

• show_gmp_series (Nullable(Bool)) — UI flag to display the series (if applicable).

• show_gmp_outcome (Nullable(Bool)) — UI flag to display the outcome (if applicable).

• manual_activation (Nullable(Bool)) — whether manual activation is required (if applicable).

• neg_risk_other (Nullable(Bool)) — flag/indicator of “neg risk” logic (as in metadata; meaning depends on the platform).

• game_id (Nullable(String)) — game/match identifier (for sports markets).

• group_item_range (Nullable(String)) — range/interval of the group item (if applicable).

• sports_market_type (Nullable(String)) — sports market type (e.g., totals, team_totals, etc.).

• line (Nullable(Float64)) — line/threshold (e.g., 47.5 for totals).

• uma_resolution_statuses (Nullable(String)) — set of UMA resolution statuses (often a serialized array).

• pending_deployment (Nullable(Bool)) — market is pending publication/deployment (if applicable).

• deploying (Nullable(Bool)) — market is in the process of deployment (if applicable).

• deploying_timestamp (Nullable(DateTime64(3))) — time when deployment started/was recorded (if applicable).

• scheduled_deployment_timestamp (Nullable(DateTime64(3))) — scheduled deployment time (if applicable).

• rfq_enabled (Nullable(Bool)) — whether RFQ mode is enabled (if applicable).

• event_start_time (Nullable(DateTime64(3))) — event start time (important for markets tied to a specific event).

• image (Nullable(String)) — market image URL.

• icon (Nullable(String)) — market icon URL.

• raw_json (String) — original raw metadata JSON stored in full for audit/recovery.

• inserted_at (DateTime) — time when the record was inserted into ClickHouse (technical field).