Skip to main content
The common.predictions.polymarket_us_trades_enriched table contains the same trades as polymarket_us_trades with additional market columns (question, category, outcomes, status, resolution). Each row is one trade.

​
Table Columns

Unique Key: unique_key
Column NameData TypeDescription
projectVARCHARProject name.
protocolVARCHARProtocol name.
trade_dateDATEUTC calendar date of the trade.
session_dateDATEExchange session date for the trade.
trade_timestampTIMESTAMP_NTZUTC timestamp of the trade.
transaction_timeVARCHARTrade timestamp in US Eastern time with offset.
unique_keyVARCHARUnique trade identifier.
slugVARCHARMarket slug identifier.
outcome_1_priceFLOATImplied probability for outcome_1 (0 to 1 scale).
outcome_2_priceFLOATImplied probability for outcome_2 (0 to 1 scale).
last_quantityFLOATTrade quantity in contracts.
fee_usdFLOATTrading fee in USD.
market_idVARCHARMarket ID.
market_questionVARCHARMarket question text.
market_descriptionVARCHARMarket description.
market_categoryVARCHARMarket category.
market_typeVARCHARMarket type.
sports_market_typeVARCHARSports market type.
market_statusVARCHARCurrent market status.
outcome_1VARCHARFirst outcome description.
outcome_2VARCHARSecond outcome description.
settlement_priceFLOATSettlement price.
winnerVARCHARName of the winning outcome.
is_resolvedBOOLEANWhether the market has been resolved.
market_outcomeVARCHARResolution status.
market_start_dateTIMESTAMP_NTZMarket start timestamp.
market_end_dateTIMESTAMP_NTZMarket end timestamp.
market_game_start_timeTIMESTAMP_NTZGame/event start time.
_created_atTIMESTAMP_NTZRecord creation timestamp.
_updated_atTIMESTAMP_NTZRecord update timestamp.

​
Sample Query

SELECT
    market_category,
    COUNT(*) AS num_trades,
    SUM(last_quantity) AS total_volume,
    COUNT(DISTINCT slug) AS unique_markets
FROM common.predictions.polymarket_us_trades_enriched
WHERE trade_date >= DATEADD(day, -7, CURRENT_DATE())
GROUP BY market_category
ORDER BY total_volume DESC