Trades Enriched 🌱 - Allium Documentation Hub

The polygon.predictions_onchain.trades_enriched table contains every Polymarket trade on Polygon with its market, outcome and resolution context. Each row represents one fill. This table contains no Polymarket API data. The equivalent table with Polymarket API metadata is polygon.predictions.trades_enriched.

Table Details

Property	Value
Table Name	`polygon.predictions_onchain.trades_enriched`
Table Status	Beta 🌱
Unique Key	`block_timestamp`, `transaction_hash`, `log_index`

Table Columns

Column Name	Data Type	Description
event_name	VARCHAR(16777216)	Type of trade event (OrderFilled, FPMMBuy, FPMMSell).
project	VARCHAR(16777216)	Project name (ex. polymarket).
protocol	VARCHAR(16777216)	Protocol name (ex. 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).
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. Null for FPMM.
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.
market_id	VARCHAR(16777216)	Neg-risk market identifier.
market_name	VARCHAR(16777216)	Neg-risk event name, ‘single market’ for markets outside a neg-risk event, or the combo name on v3 Combos rows.
market_description_onchain	VARCHAR(16777216)	Neg-risk event description published onchain.
question_id	VARCHAR(16777216)	Unique question identifier.
question	VARCHAR(16777216)	Market question text published onchain.
question_description	VARCHAR(16777216)	Market resolution description published onchain.
neg_risk	BOOLEAN	Whether this is a NegRisk market.
asset_id	VARCHAR(16777216)	Outcome token id, or the PositionManager id on v3 Combos rows.
token_outcome	VARCHAR(16777216)	Outcome name for the token, such as Yes, No, Up or Down.
token_outcome_name	VARCHAR(16777216)	Combined outcome and question name.
is_winning_outcome	BOOLEAN	Whether this outcome won the market.
market_address	VARCHAR(42)	Address of the market contract where the trade occurred.
order_hash	VARCHAR(16777216)	Hash of the order.
maker	VARCHAR(42)	Address of the maker (order creator) in the trade.
taker	VARCHAR(42)	Address of the taker (order fulfiller) in the trade.
collateral_amount_raw	VARCHAR(16777216)	Raw unnormalized collateral amount.
token_amount_raw	VARCHAR(16777216)	Raw unnormalized outcome token amount.
price_str	VARCHAR(16777216)	Trade price per share, as a string.
trade_price	FLOAT	Trade price per share.
maker_amount_raw	VARCHAR(16777216)	Raw unnormalized amount from maker side of the trade.
taker_amount_raw	VARCHAR(16777216)	Raw unnormalized amount from taker side of the trade.
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 unnormalized 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_amount	VARCHAR(16777216)	Collateral amount.
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.
fee_bips	VARCHAR(16777216)	Neg-risk market fee in basis points.
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)	Number of decimals for the collateral token.
usd_exchange_rate	FLOAT	USD exchange rate for the collateral token.
usd_collateral_amount	FLOAT	USD value of the collateral amount.
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	USD value of the fee paid in the trade.
oracle	VARCHAR(42)	Oracle contract address for market resolution.
resolution_outcome	VARCHAR(16777216)	Market resolution outcome: yes, no, 50/50, unknown, or unresolved.
transaction_index	NUMBER(38,0)	Index of the transaction in the block.
transaction_hash	VARCHAR(66)	Hash of the transaction containing the trade.
log_index	NUMBER(38,0)	Index of the log within the transaction.
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block containing the trade.
block_number	NUMBER(38,0)	Block number containing 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)	Record creation timestamp.
_updated_at	TIMESTAMP_NTZ(9)	Record update timestamp.
parlay_description	VARCHAR(16777216)	Readable parlay of the combo legs, e.g. `YES(Will Spain win?) AND NO(Will France win?)`.
combo_n_legs	NUMBER(38,0)	Number of legs in the combo.
combo_all_legs_resolved	BOOLEAN	True when every leg of the combo is identified.

Sample Query

select *
from polygon.predictions_onchain.trades_enriched
where block_timestamp >= '2026-10-18' and block_timestamp < '2026-10-19'
limit 100

EVM

​Table Details

​Table Columns

​Sample Query

Table Details

Table Columns

Sample Query