Trades

The polygon.predictions.trades table provides comprehensive trade data from prediction market platforms on Polygon. Currently featuring Polymarket data, this schema is designed to seamlessly integrate additional prediction market protocols as they become available. Use this table to analyze trading patterns, market volumes, participant behavior, and event outcomes across prediction markets on Polygon.

Table Columns

Data Precision Notes:

_raw fields contain unnormalized amounts for maximum precision
_str columns are numeric fields cast to varchar to retain precision
USD amounts reflect value at time of trade

Unique Key: unique_id

Column Name	Data Type	Description
event_name	VARCHAR	Name of the prediction market event.
project	VARCHAR	Name of the project (e.g., Polymarket).
protocol	VARCHAR	Protocol name (e.g., polymarket).
exchange_type	VARCHAR	Type of exchange (e.g., Polymarket Fixed Product Market Maker, Orderbook).
condition_id	VARCHAR	Unique identifier for the event condition.
market_address	VARCHAR	Address of the prediction market contract.
order_hash	VARCHAR	Unique hash of the order.
maker	VARCHAR	Address of the maker in the trade.
taker	VARCHAR	Address of the taker in the trade.
asset_id	VARCHAR	Identifier for the traded asset.
collateral_amount_raw	VARCHAR	Raw collateral amount (unnormalized).
token_amount_raw	VARCHAR	Raw share amount (unnormalized).
price_str	VARCHAR	Share price as a string.
price	FLOAT	Share price as a float.
maker_amount_raw	VARCHAR	Raw amount provided by the maker.
taker_amount_raw	VARCHAR	Raw amount provided by the taker.
fee_raw	VARCHAR	Raw fee amount.
collateral_token_address	VARCHAR	Address of the collateral token.
collateral_token_name	VARCHAR	Name of the collateral token.
collateral_token_symbol	VARCHAR	Symbol of the collateral token.
collateral_token_decimals	NUMBER	Decimals of the collateral token.
collateral_amount	VARCHAR	Collateral amount (normalized).
fee_amount	VARCHAR	Fee amount (normalized).
usd_exchange_rate	FLOAT	USD exchange rate of the collateral token at the time of trade.
usd_collateral_amount	FLOAT	Collateral amount in USD.
usd_fee_amount	FLOAT	Fee amount in USD.
transaction_index	NUMBER	Index of the transaction in the block.
transaction_hash	VARCHAR	Hash of the transaction.
log_index	NUMBER	Log index of the trade event.
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block containing the trade.
block_number	NUMBER	Block number of the trade.
block_hash	VARCHAR	Hash of the block containing the trade.
unique_id	VARCHAR	Unique identifier for the trade.
_created_at	TIMESTAMP_NTZ(9)	The timestamp of the creation of the trade.
_updated_at	TIMESTAMP_NTZ(9)	The timestamp of the last update of the trade.

Sample Queries

Recent Trades
Daily Volume

Get recent prediction market trades with essential details:

select
  event_name,
  project,
  price,
  usd_collateral_amount,
  maker,
  taker,
  block_timestamp
from polygon.predictions.trades
where block_timestamp >= current_timestamp - interval '3 days'
order by block_timestamp desc

Calculate daily trading volume and trading activity for the past month:

select
  date(block_timestamp) as day,
  count(*) as total_trades,
  sum(usd_collateral_amount) as daily_volume_usd
from polygon.predictions.trades
where block_timestamp >= current_timestamp - interval '30 days'
group by day
order by day desc

Protocol Coverage

Protocol	Status	Exchange Types Supported
Polymarket	✅ Active	Fixed Product Market Maker, Orderbook

More protocols will be added as they launch or integrate with Polygon.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Queries

Protocol Coverage

​Table Columns

​Sample Queries

​Protocol Coverage

Table Columns

Sample Queries

Protocol Coverage