Trades 🌱 - Allium Documentation Hub

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 Details

Property	Value
Table Name	`polygon.predictions.trades`
Table Status	Beta 🌱
Unique Key	`block_timestamp`, `transaction_hash`, `log_index`
Clustering Key(s)	`block_timestamp::date`
Search Optimization	`transaction_hash`

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

Column Name	Data Type	Description
event_name	VARCHAR(16777216)	Name of the prediction market event.
project	VARCHAR(16777216)	Name of the project (e.g., Polymarket).
protocol	VARCHAR(16777216)	Protocol name (e.g., polymarket).
exchange_type	VARCHAR(16777216)	Exchange type: CTFExchange, NegRiskCTFExchange, CTFExchangeV2, NegRiskCTFExchangeV2, ComboExchange, or FPMM.
contract_version	VARCHAR(16777216)	Exchange contract version: `v1`, `v2`, or `v3` (Combos).
market_address	VARCHAR(42)	Address of the prediction market contract.
order_hash	VARCHAR(16777216)	Unique hash of the order.
maker	VARCHAR(42)	Address of the maker in the trade.
taker	VARCHAR(42)	Address of the taker in the trade.
side	NUMBER(38,0)	Maker order side. 0 = BUY (bid), 1 = SELL (ask).
side_name	VARCHAR(16777216)	BUY if the maker posted a bid, SELL if the maker posted an ask.
builder	VARCHAR(16777216)	Order attribution field (bytes32).
metadata	VARCHAR(16777216)	Per-order data field (bytes32).
condition_id	VARCHAR(16777216)	Market condition id, or the combo id on v3 Combos rows.
asset_id	VARCHAR(16777216)	Outcome token id, or the PositionManager id on v3 Combos rows.
collateral_amount_raw	VARCHAR(16777216)	Raw collateral amount (unnormalized).
token_amount_raw	VARCHAR(16777216)	Raw share amount (unnormalized).
price_str	VARCHAR(16777216)	Share price as a string.
price	FLOAT	Share price as a float.
maker_amount_raw	VARCHAR(16777216)	Raw amount provided by the maker.
taker_amount_raw	VARCHAR(16777216)	Raw amount provided by the taker.
fee_charged_raw	VARCHAR(16777216)	Gross fee for the fill in raw collateral units.
fee_rebate_raw	VARCHAR(16777216)	Maker rebate for the fill in raw collateral units.
fee_raw	VARCHAR(16777216)	Raw fee amount.
fee_charged_event_count	NUMBER(38,0)	Number of FeeCharged events in the transaction.
fee_rebate_event_count	NUMBER(38,0)	Number of FeeRefunded events in the transaction.
collateral_token_address	VARCHAR(42)	Address of the collateral token.
collateral_token_name	VARCHAR(16777216)	Name of the collateral token.
collateral_token_symbol	VARCHAR(16777216)	Symbol of the collateral token.
collateral_token_decimals	NUMBER(38,0)	Decimals of the collateral token.
collateral_amount	VARCHAR(16777216)	Collateral amount (normalized).
fee_charged_amount	VARCHAR(16777216)	Per-row gross fee in collateral token units.
fee_rebate_amount	VARCHAR(16777216)	Per-row maker rebate in collateral token units.
fee_amount	VARCHAR(16777216)	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_charged_amount	FLOAT	USD value of the per-row gross fee.
usd_fee_rebate_amount	FLOAT	USD value of the per-row maker rebate.
usd_fee_amount	FLOAT	Fee amount in USD.
transaction_index	NUMBER(38,0)	Index of the transaction in the block.
transaction_hash	VARCHAR(66)	Hash of the transaction.
log_index	NUMBER(38,0)	Log index of the trade event.
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block containing the trade.
block_number	NUMBER(38,0)	Block number of the trade.
block_hash	VARCHAR(66)	Hash of the block containing the trade.
unique_id	VARCHAR(16777216)	Concatenated 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
Combos v3

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

Combos fills (contract_version = 'v3'):

select
  contract_version,
  exchange_type,
  condition_id,
  asset_id,
  price,
  usd_collateral_amount,
  block_timestamp
from polygon.predictions.trades
where contract_version = 'v3'
  and block_timestamp >= current_timestamp - interval '7 days'
order by block_timestamp desc

Protocol Coverage

Protocol	Status	Exchange Types Supported
Polymarket	Active	Fixed Product Market Maker, CLOB, ComboExchange

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

EVM

​Table Details

​Table Columns

​Sample Queries

​Protocol Coverage

Table Details

Table Columns

Sample Queries

Protocol Coverage