The 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 Overview

The predictions trades table contains:
  • Event Information: Market names, conditions, and identifiers
  • Trade Details: Makers, takers, share prices, and share amounts

​
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 NameData TypeDescription
event_nameVARCHARName of the prediction market event.
projectVARCHARName of the project (e.g., Polymarket).
protocolVARCHARProtocol name (e.g., polymarket).
exchange_typeVARCHARType of exchange (e.g., Polymarket Fixed Product Market Maker, Orderbook).
condition_idVARCHARUnique identifier for the event condition.
market_addressVARCHARAddress of the prediction market contract.
order_hashVARCHARUnique hash of the order.
makerVARCHARAddress of the maker in the trade.
takerVARCHARAddress of the taker in the trade.
asset_idVARCHARIdentifier for the traded asset.
collateral_amount_rawVARCHARRaw collateral amount (unnormalized).
token_amount_rawVARCHARRaw share amount (unnormalized).
price_strVARCHARShare price as a string.
priceFLOATShare price as a float.
maker_amount_rawVARCHARRaw amount provided by the maker.
taker_amount_rawVARCHARRaw amount provided by the taker.
fee_rawVARCHARRaw fee amount.
collateral_token_addressVARCHARAddress of the collateral token.
collateral_token_nameVARCHARName of the collateral token.
collateral_token_symbolVARCHARSymbol of the collateral token.
collateral_token_decimalsNUMBERDecimals of the collateral token.
collateral_amountVARCHARCollateral amount (normalized).
fee_amountVARCHARFee amount (normalized).
usd_exchange_rateFLOATUSD exchange rate of the collateral token at the time of trade.
usd_collateral_amountFLOATCollateral amount in USD.
usd_fee_amountFLOATFee amount in USD.
transaction_indexNUMBERIndex of the transaction in the block.
transaction_hashVARCHARHash of the transaction.
log_indexNUMBERLog index of the trade event.
block_timestampTIMESTAMP_NTZ(9)Timestamp of the block containing the trade.
block_numberNUMBERBlock number of the trade.
block_hashVARCHARHash of the block containing the trade.
unique_idVARCHARUnique identifier for the trade.

​
Sample Queries

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

ProtocolStatusExchange Types Supported
Polymarket✅ ActiveFixed Product Market Maker, Orderbook
More protocols will be added as they launch or integrate with Polygon.