Trades

Comprehensive Prediction Market trade data on Polygon.

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 calculated using exchange rates at trade execution hour

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.

---

Sample Queries

Recent Trades

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

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.