market_id | VARCHAR | Condition id of the market as a ‘0x…’ string, shared by its two outcome tokens |
gamma_market_id | VARCHAR | Polymarket’s own market id, shared by the market’s two outcome tokens. Null where Polymarket does not list the market |
event_id | VARCHAR | Polymarket’s id of the event the market is listed under, shared by every market of that event. Null where Polymarket does not list the market |
neg_risk_market_id | VARCHAR | Id of the neg-risk (multi-outcome) market set the market belongs to, as a ‘0x…’ string; null outside one. Not a condition id |
parent_event_id | VARCHAR | Polymarket’s id of the event this market’s event is nested under, as sports side events are under their game; null for a top-level event |
series_id | VARCHAR | Polymarket’s id of the recurring series the market’s event belongs to; null outside a series |
series_title | VARCHAR | Name of the recurring series the market’s event belongs to; null outside a series |
event_title | VARCHAR | Title of the event the market is listed under |
event_slug | VARCHAR | URL slug of the event on polymarket.com |
event_description | VARCHAR | Description and resolution rules of the event |
question_id | VARCHAR | Oracle question id of the market as a ‘0x…’ string |
question | VARCHAR | Concrete question the market resolves |
market_description | VARCHAR | Market description and resolution rules |
outcome_id | UINT256 | Outcome token id; the table’s grain, two rows per market. Joins market_trades and positions on outcome_id |
outcome_name | VARCHAR | Label of this token’s side, e.g. ‘Yes’ or ‘No’ (some markets use other labels such as ‘Up’ or team names) |
outcome_index | INTEGER | Positional side of this token within its market: 0 for the first token, 1 for the second. Settlement resolves against this position, not the label: outcome ‘yes’ means index 0 won, ‘no’ means index 1 won |
yes_sub_title | VARCHAR | The market’s label within its event, such as a team, a candidate or a price range |
status | VARCHAR | Lifecycle of the market: active while it trades, closed once trading has ended or the market was delisted, settled once its outcome is decided |
archived | BOOLEAN | Whether the market is archived |
closed | BOOLEAN | Whether the market is closed |
accepting_orders | BOOLEAN | Whether the market is accepting orders |
is_mutually_exclusive_event | BOOLEAN | TRUE where the market is one outcome of a mutually exclusive event (Polymarket’s neg-risk markets): exactly one market of the event resolves Yes |
link | VARCHAR | Page of the market’s event on polymarket.com; null where Polymarket does not list the market |
market_start_time | TIMESTAMP | Time the market started accepting orders |
market_end_time | TIMESTAMP | Scheduled end time of the market as published by Polymarket; midnight UTC where Polymarket publishes only a date. Not the resolution time; use settlement_ts for that |
scheduled_start_time | TIMESTAMP | When the underlying event is scheduled to begin, such as a game’s kickoff or the start of an Up/Down window. Null where the market’s subject has no start time |
game_end_time | TIMESTAMP | Time the underlying game finished, for sports events; null until the event has closed |
seconds_delay | INTEGER | Order-matching delay in seconds, used on live in-game markets |
fpmm | VARCHAR | Address of the market’s legacy AMM pool, where one exists |
image | VARCHAR | Market image URL |
tags | ARRAY(VARCHAR) | Polymarket category tags as an array of strings; the input behind category |
category | VARCHAR | Unified category enum shared across venues: sports, crypto, politics, finance, technology, culture, weather, world, health, other. Derived from tags; untagged markets are other. |
frequency | VARCHAR | How often the market’s series recurs: five_min, fifteen_min, hourly, four_hour, daily, weekly, monthly or annual; null outside a recurring series |
sports_market_type | VARCHAR | Polymarket’s type for a sports market, such as moneyline, spreads or totals; null outside sports |
competition | VARCHAR | Competition Polymarket files a sports event under: usually the league, but the game for esports and the tour for tennis, where event_metadata carries the league |
home_team | VARCHAR | Home team of a two-team sports event, as Polymarket displays it; null otherwise |
away_team | VARCHAR | Away team of a two-team sports event, as Polymarket displays it; null otherwise |
teams | VARCHAR | JSON array of the teams or players of a sports event as Polymarket publishes them, with details such as their id, name, alias, abbreviation, league and, on two-sided events, ordering (home or away). alias, where present, is the name Polymarket displays. Null where the event lists none |
score | VARCHAR | Latest score Polymarket publishes for the game, final once the event has closed. The format varies by sport |
event_metadata | VARCHAR | JSON object of the event’s details as Polymarket publishes them, such as the league, stage and match format of a sports event, the fixture’s ids at sports data providers, and the start and final price of an Up/Down market. Keys vary by event type. Null where Polymarket publishes none |
market_metadata | VARCHAR | JSON object of the market’s sports details as Polymarket publishes them, such as the odds feed’s market name, the selection, the points line and the team or player id. A gammaTeamId key matches an id in teams. Null where Polymarket publishes none |
strike_type | VARCHAR | How the outcome index 0 side resolves against the strikes: greater (above floor_strike), greater_or_equal (at or above it), less (below cap_strike), less_or_equal (at or below it), or between (from floor_strike to cap_strike). On a price bracket a value exactly on the boundary belongs to the higher bracket, so its cap_strike is exclusive; whole-number brackets such as temperatures and post counts include both ends. On reach, dip and hit markets the price only needs to touch the strike during the market’s window. Null where the market has no numeric strike. |
floor_strike | DOUBLE | Lower strike: the line of an Over/Under market, the margin the first-listed side must win by on a spread or handicap, the start price of an Up/Down market, or the lower bound of a bracket or threshold. Null on less and less_or_equal strikes. |
cap_strike | DOUBLE | Upper strike: the upper bound of a bracket or the threshold of a less or less_or_equal strike. Null on greater and greater_or_equal strikes |
underlying | VARCHAR | Upper-case ticker of the asset whose price the market tracks; null where the market tracks no asset price or the asset is unknown |
expiration_value | DOUBLE | Final price an Up/Down market resolved against, as Polymarket publishes it; null elsewhere |
election_type | VARCHAR | Type of election of an election event, as Polymarket publishes it |
election_country | VARCHAR | Country or region of an election event, as Polymarket publishes it |
settlement_source | VARCHAR | Source the market or its event names for resolution, usually a URL |
fee_type | VARCHAR | Name of the fee schedule the market trades under |
fee_rate | DOUBLE | Taker fee rate of the market’s fee schedule; fee_exponent sets how the fee varies with price. Null where the market charges no fees |
fee_exponent | DOUBLE | Exponent of the price term in the market’s taker fee formula |
maker_rebate_rate | DOUBLE | Share of the market’s taker fees paid back to makers as rebates, between 0 and 1 |
is_fee_taker_only | BOOLEAN | TRUE where only takers pay the market’s fee; null where the market charges no fees |
maker_base_fee_bps | INTEGER | Maker fee rate in basis points from Polymarket’s older fee model. On markets with a fee schedule, fees follow fee_rate instead |
taker_base_fee_bps | INTEGER | Taker fee rate in basis points from Polymarket’s older fee model. On markets with a fee schedule, fees follow fee_rate instead |
uma_bond | DOUBLE | Bond in USD a proposer posts to propose the market’s resolution |
uma_reward | DOUBLE | Reward in USD paid to the proposer of an undisputed resolution |
liveness_seconds | INTEGER | Time in seconds a proposed resolution can be disputed. 0 means the oracle’s default of two hours |
is_other_outcome | BOOLEAN | TRUE on the catch-all ‘Other’ market of a multi-outcome event |
outcome | VARCHAR | Market resolution: ‘yes’, ‘no’, ‘50/50’, or ‘unresolved’. Positional, not label-based: ‘yes’ means outcome index 0 won, ‘no’ means index 1 won. For non-Yes/No labels (Up/Down, team names) use settlement_value_usd rather than matching the label |
settlement_value_usd | DOUBLE | Per-share payout of THIS row’s token at resolution: 1.0 (won), 0.0 (lost), 0.5 (50/50); null while unresolved. Correct for any label scheme. Same per-side semantics as combo_details.settlement_value_usd |
settlement_ts | TIMESTAMP | On-chain resolution time of the market, which is also when winning tokens become redeemable; null while unresolved |
_updated_at | TIMESTAMP | When this row was last written. Unchanged rows keep their stamp. |