Name: Gamma Markets
Creator: Polymarket
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Gamma Markets

This dataset contains structured metadata from Polymarket’s Gamma API, enriching prediction markets with thematic,
temporal, and organizational context.

The dataset is composed of three interrelated tables:

series: Represents high-level themes or recurring structures such as "NFL 2024" or "US Elections".
events: Groups one or more markets under a specific occurrence within a series, such as a specific game or election.
markets: The individual prediction markets where trading occurs, linked to their parent event when applicable.

Together, these tables enable analysis at multiple levels — from individual market behavior to trends across events and
entire series. This hierarchy supports richer insights into market structure, coverage, and performance over time.

Tables

Events

@polymarket.gamma.events

9.76 MB
32852 rows
75 columns


CREATE TABLE events (
  "id" BIGINT,
  "ticker" VARCHAR,
  "slug" VARCHAR,
  "title" VARCHAR,
  "description" VARCHAR,
  "resolutionsource" VARCHAR,
  "startdate" TIMESTAMP,
  "creationdate" TIMESTAMP,
  "enddate" VARCHAR,
  "image" VARCHAR,
  "icon" VARCHAR,
  "active" BOOLEAN,
  "closed" BOOLEAN,
  "archived" VARCHAR,
  "new" VARCHAR,
  "featured" VARCHAR,
  "restricted" VARCHAR,
  "liquidity" DOUBLE,
  "volume" DOUBLE,
  "openinterest" DOUBLE,
  "sortby" VARCHAR,
  "category" VARCHAR,
  "published_at" TIMESTAMP,
  "createdat" TIMESTAMP,
  "updatedat" TIMESTAMP,
  "competitive" DOUBLE,
  "volume24hr" DOUBLE,
  "volume1wk" DOUBLE,
  "volume1mo" DOUBLE,
  "volume1yr" DOUBLE,
  "liquidityamm" DOUBLE,
  "liquidityclob" DOUBLE,
  "commentcount" DOUBLE,
  "cyom" BOOLEAN,
  "closedtime" TIMESTAMP,
  "showalloutcomes" BOOLEAN,
  "showmarketimages" BOOLEAN,
  "enablenegrisk" BOOLEAN,
  "seriesslug" VARCHAR,
  "negriskaugmented" BOOLEAN,
  "pendingdeployment" BOOLEAN,
  "deploying" BOOLEAN,
  "tags" VARCHAR,
  "subcategory" VARCHAR,
  "updatedby" DOUBLE,
  "commentsenabled" VARCHAR,
  "enableorderbook" VARCHAR,
  "featuredimage" VARCHAR,
  "disqusthread" VARCHAR,
  "automaticallyactive" VARCHAR,
  "negrisk" VARCHAR,
  "automaticallyresolved" VARCHAR,
  "createdby" DOUBLE,
  "negriskmarketid" VARCHAR,
  "gmpchartmode" VARCHAR,
  "starttime" TIMESTAMP,
  "eventdate" TIMESTAMP,
  "eventweek" DOUBLE,
  "score" VARCHAR,
  "elapsed" VARCHAR,
  "period" VARCHAR,
  "live" VARCHAR,
  "ended" VARCHAR,
  "finishedtimestamp" TIMESTAMP,
  "featuredorder" DOUBLE,
  "negriskfeebips" DOUBLE,
  "countryname" VARCHAR,
  "electiontype" VARCHAR,
  "color" VARCHAR,
  "tweetcount" DOUBLE,
  "deployingtimestamp" TIMESTAMP,
  "carouselmap" VARCHAR,
  "spreadsmainline" DOUBLE,
  "totalsmainline" DOUBLE,
  "gamestatus" VARCHAR
);

Markets

@polymarket.gamma.markets

45.88 MB
84497 rows
135 columns


CREATE TABLE markets (
  "id" BIGINT,
  "question" VARCHAR,
  "conditionid" VARCHAR,
  "slug" VARCHAR,
  "resolutionsource" VARCHAR,
  "enddate" TIMESTAMP,
  "category" VARCHAR,
  "liquidity" DOUBLE,
  "startdate" TIMESTAMP,
  "fee" DOUBLE,
  "image" VARCHAR,
  "icon" VARCHAR,
  "description" VARCHAR,
  "outcomes" VARCHAR,
  "outcomeprices" VARCHAR,
  "volume" DOUBLE,
  "active" BOOLEAN,
  "markettype" VARCHAR,
  "closed" BOOLEAN,
  "marketmakeraddress" VARCHAR,
  "updatedby" DOUBLE,
  "createdat" TIMESTAMP,
  "updatedat" TIMESTAMP,
  "closedtime" TIMESTAMP,
  "wideformat" VARCHAR,
  "new" VARCHAR,
  "sentdiscord" VARCHAR,
  "featured" VARCHAR,
  "submitted_by" VARCHAR,
  "twittercardlocation" VARCHAR,
  "twittercardlastrefreshed" DOUBLE,
  "archived" BOOLEAN,
  "resolvedby" VARCHAR,
  "restricted" BOOLEAN,
  "volumenum" DOUBLE,
  "liquiditynum" DOUBLE,
  "enddateiso" TIMESTAMP,
  "startdateiso" TIMESTAMP,
  "hasrevieweddates" VARCHAR,
  "readyforcron" VARCHAR,
  "volume24hr" DOUBLE,
  "volume1wk" DOUBLE,
  "volume1mo" DOUBLE,
  "volume1yr" DOUBLE,
  "clobtokenids" VARCHAR,
  "fpmmlive" VARCHAR,
  "volume1wkamm" DOUBLE,
  "volume1moamm" DOUBLE,
  "volume1yramm" DOUBLE,
  "volume1wkclob" DOUBLE,
  "volume1moclob" DOUBLE,
  "volume1yrclob" DOUBLE,
  "creator" VARCHAR,
  "ready" BOOLEAN,
  "funded" BOOLEAN,
  "cyom" BOOLEAN,
  "competitive" DOUBLE,
  "pagerdutynotificationenabled" BOOLEAN,
  "approved" BOOLEAN,
  "rewardsminsize" BIGINT,
  "rewardsmaxspread" DOUBLE,
  "spread" DOUBLE,
  "onedaypricechange" DOUBLE,
  "onehourpricechange" DOUBLE,
  "oneweekpricechange" DOUBLE,
  "onemonthpricechange" DOUBLE,
  "oneyearpricechange" DOUBLE,
  "lasttradeprice" DOUBLE,
  "bestbid" DOUBLE,
  "bestask" DOUBLE,
  "clearbookonstart" BOOLEAN,
  "manualactivation" BOOLEAN,
  "negriskother" BOOLEAN,
  "umaresolutionstatuses" VARCHAR,
  "pendingdeployment" BOOLEAN,
  "deploying" BOOLEAN,
  "rfqenabled" BOOLEAN,
  "holdingrewardsenabled" BOOLEAN,
  "event_id" BIGINT,
  "event_slug" VARCHAR,
  "twittercardlastvalidated" DOUBLE,
  "mailchimptag" VARCHAR,
  "groupitemtitle" VARCHAR,
  "questionid" VARCHAR,
  "umaenddate" VARCHAR,
  "enableorderbook" VARCHAR,
  "umaresolutionstatus" VARCHAR,
  "umaenddateiso" TIMESTAMP,
  "secondsdelay" DOUBLE,
  "liquidityamm" DOUBLE,
  "groupitemthreshold" DOUBLE,
  "subcategory" VARCHAR,
  "categorymailchimptag" VARCHAR,
  "lowerbound" DOUBLE,
  "upperbound" DOUBLE,
  "formattype" VARCHAR,
  "orderpriceminticksize" DOUBLE,
  "orderminsize" DOUBLE,
  "volume24hrclob" DOUBLE,
  "volumeamm" DOUBLE
);

Series

@polymarket.gamma.series

42.67 KB
195 rows
31 columns


CREATE TABLE series (
  "id" BIGINT,
  "ticker" VARCHAR,
  "slug" VARCHAR,
  "title" VARCHAR,
  "seriestype" VARCHAR,
  "recurrence" VARCHAR,
  "image" VARCHAR,
  "icon" VARCHAR,
  "layout" VARCHAR,
  "active" VARCHAR,
  "closed" VARCHAR,
  "archived" VARCHAR,
  "new" VARCHAR,
  "featured" VARCHAR,
  "restricted" VARCHAR,
  "publishedat" TIMESTAMP,
  "createdby" DOUBLE,
  "updatedby" DOUBLE,
  "createdat" TIMESTAMP,
  "updatedat" TIMESTAMP,
  "commentsenabled" VARCHAR,
  "competitive" DOUBLE,
  "volume24hr" DOUBLE,
  "startdate" TIMESTAMP,
  "commentcount" BIGINT,
  "description" VARCHAR,
  "subtitle" VARCHAR,
  "volume" DOUBLE,
  "liquidity" DOUBLE,
  "pythtokenid" VARCHAR,
  "cgassetname" VARCHAR
);