Trades

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 Name	Data Type	Description
project	VARCHAR	Project name.
protocol	VARCHAR	Protocol name.
trade_date	DATE	UTC calendar date of the trade.
session_date	DATE	Exchange session date for the trade.
trade_timestamp	TIMESTAMP_NTZ	UTC timestamp of the trade.
transaction_time	VARCHAR	Trade timestamp in US Eastern time with offset.
unique_key	VARCHAR	Unique trade identifier.
slug	VARCHAR	Market slug identifier.
outcome_1_price	FLOAT	Implied probability for outcome_1 (0 to 1 scale).
outcome_2_price	FLOAT	Implied probability for outcome_2 (0 to 1 scale).
last_quantity	FLOAT	Trade quantity in contracts.
fee_usd	FLOAT	Trading fee in USD.
_created_at	TIMESTAMP_NTZ	Record creation timestamp.
_updated_at	TIMESTAMP_NTZ	Record 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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query