> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Trades Enriched 🌱

> Polymarket trades with market, outcome and resolution context, from onchain data only.

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`](/historical-data/supported-blockchains/evm/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

```sql theme={null}
select *
from polygon.predictions_onchain.trades_enriched
where block_timestamp >= '2026-10-18' and block_timestamp < '2026-10-19'
limit 100
```