Skip to main content
The common.predictions.polymarket_us_trades table contains executed trades on Polymarket US. 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.
_created_atTIMESTAMP_NTZRecord creation timestamp.
_updated_atTIMESTAMP_NTZRecord update timestamp.

​
Sample Query

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