Skip to main content
The common.predictions.polymarket_us_markets table lists Polymarket US markets. Each row is one market.

​
Table Columns

Unique Key: market_unique_id
Column NameData TypeDescription
projectVARCHARProject name.
protocolVARCHARProtocol name.
market_unique_idVARCHARUnique market identifier (slug).
market_idVARCHARMarket ID.
questionVARCHARMarket question text.
descriptionVARCHARMarket description.
categoryVARCHARMarket category (sports, culture, etc).
market_typeVARCHARMarket type.
sports_market_typeVARCHARSports market type (MONEYLINE, SPREAD, TOTAL, PROP).
activeBOOLEANWhether the market is accepting orders.
closedBOOLEANWhether the market has closed.
archivedBOOLEANWhether the market is archived.
market_statusVARCHARCurrent market status.
outcome_1VARCHARFirst outcome description (long side).
outcome_2VARCHARSecond outcome description (short side).
outcome_1_priceFLOATPrice for outcome 1 (0 to 1 scale).
outcome_2_priceFLOATPrice for outcome 2 (0 to 1 scale).
settlement_priceFLOATBinary settlement value for the market (0 to 1 scale).
winnerVARCHARName of the winning outcome.
is_resolvedBOOLEANWhether the market has been resolved.
market_outcome_resolutionVARCHARResolution status.
start_dateTIMESTAMP_NTZMarket start timestamp.
end_dateTIMESTAMP_NTZMarket end timestamp.
game_start_timeTIMESTAMP_NTZGame/event start time for sports markets.
created_atTIMESTAMP_NTZMarket creation timestamp.
updated_atTIMESTAMP_NTZMarket last update timestamp.
fee_coefficientFLOATTrading fee coefficient.
tick_sizeFLOATMinimum order price tick size.
outcomes_rawVARCHARRaw outcomes JSON array.
extrasVARCHARVARIANT column with platform-specific metadata.

​
Sample Query

SELECT
    category,
    COUNT(*) AS total_markets,
    SUM(CASE WHEN is_resolved THEN 1 ELSE 0 END) AS resolved,
    SUM(CASE WHEN active AND NOT closed THEN 1 ELSE 0 END) AS open
FROM common.predictions.polymarket_us_markets
GROUP BY category
ORDER BY total_markets DESC