# Polymarket | Bitquery Data Store

Polymarket fills, position splits, merges and payouts, and market results on Polygon since September 2025, with market titles, outcomes and USD values.

Dataset page: https://bitquery.io/datastore/datasets/polymarket
Network: Polymarket
Category: Trades, Events
Tables: 3
Columns: 120
Coverage: 2025-09-01 to 2026-09-24
Refresh: Daily
Rows: about 1.8B
Size: about 374 GB
Format: Apache Parquet, Snappy compression, one prefix per table
Licence: https://bitquery.io/datastore/legal/data-license

## What this is

We decode Polymarket from Polygon ourselves: the order fills on its exchanges, the splits, merges and payouts of positions, and the markets created and decided, each tied to the market's question and outcome names. About 1.80 billion fills and 1.11 billion settlement rows since 1 September 2025, valued in USD from the cash side.

Most buyers start with volume or profit for a market or a wallet. Take fills where Trade_IsTakerSide is false for volume, then join payouts on the condition id to see who was paid once the market was decided. The winner sits on the Resolved row in the markets table.

## What people use it for

- Wallet profit and loss from fills and payouts, per market or per address
- Price history per outcome at fill level
- Market life from creation to result and payout
- Fee income per market since fees began in January 2026

## Tables (3)

### prediction_trades: 49 columns

One row per order fill on Polymarket's exchanges, with both addresses, shares, price, fee, USD value and the market question and outcome.

S3 prefix: matic/polymarket/prediction_trades
File naming: <start_block>_<end_block>.parquet, 50 blocks per file
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/matic/polymarket/prediction_trades/94364050_94364099.parquet
Sample updated: Sep 25, 2026

| column | type | description |
| --- | --- | --- |
| Block_Number | UInt64 | Polygon block of the fill. |
| Block_Time | DateTime | Time of the fill's block, UTC. |
| Call_Signature_Name | String | Exchange function that made the fill: matchOrders. |
| Log_Signature_Name | String | Event name: OrderFilled. |
| Log_SmartContract | String | Exchange contract that emitted the event. |
| Trade_OutcomeTrade_Buyer | String | Address that got the outcome shares. When it is the exchange contract, the row is the taker's side of a match (see Trade_IsTakerSide). |
| Trade_OutcomeTrade_Seller | String | Address that gave up the outcome shares. |
| Trade_OutcomeTrade_Amount | Decimal | Shares filled, to 6 decimal places. |
| Trade_OutcomeTrade_CollateralAmount | Decimal | Cash paid or received for those shares: USDC.e before April 2026, pUSD after. |
| Trade_OutcomeTrade_CollateralAmountInUSD | Decimal | The cash amount times the hourly USDC.e price. |
| Trade_OutcomeTrade_OrderId | String | Order hash, stored as its hex text hex-encoded again, as in the earlier sample. |
| Trade_OutcomeTrade_Price | Decimal | Price per share in cash: CollateralAmount / Amount, between 0 and 1. |
| Trade_OutcomeTrade_PriceInUSD | Decimal | Price times the hourly USDC.e price. |
| Trade_OutcomeTrade_IsOutcomeBuy | Bool | True when the order bought outcome shares. |
| Trade_Prediction_CollateralToken_Name | String | Name of the cash token. |
| Trade_Prediction_CollateralToken_Symbol | String | Cash token symbol: USDC (the bridged USDC.e) or pUSD. |
| Trade_Prediction_CollateralToken_SmartContract | String | Cash token contract. |
| Trade_Prediction_CollateralToken_AssetId | String | Cash token asset id; 0 for an ERC-20 token. |
| Trade_Prediction_CollateralToken_ProtocolName | String | Cash token standard: erc20. |
| Trade_Prediction_ConditionId | String | Condition id of the market; join the other two tables on it. |
| Trade_Prediction_OutcomeToken_Name | String | Outcome token name; usually empty, as ERC-1155 positions carry none. |
| Trade_Prediction_OutcomeToken_Symbol | String | Outcome token symbol; usually empty. |
| Trade_Prediction_OutcomeToken_SmartContract | String | ERC-1155 contract that holds the positions. |
| Trade_Prediction_OutcomeToken_AssetId | String | ERC-1155 token id of the outcome position. |
| Trade_Prediction_Marketplace_SmartContract | String | Exchange contract: the main or NegRisk exchange, replaced by new contracts in April 2026. |
| Trade_Prediction_Marketplace_ProtocolVersion | String | Exchange version. |
| Trade_Prediction_Marketplace_ProtocolName | String | Protocol name: polymarket. |
| Trade_Prediction_Marketplace_ProtocolFamily | String | Protocol family: Gnosis_CTF. |
| Trade_Prediction_Question_Title | String | The market question as shown on the site. Filled from the markets table when the fill lacks it. |
| Trade_Prediction_Question_ResolutionSource | String | Source named to decide the market. |
| Trade_Prediction_Question_Image | String | Image URL shown with the market. |
| Trade_Prediction_Question_MarketId | String | Numeric market id on the site. |
| Trade_Prediction_Question_Id | String | Id of the question behind the condition. |
| Trade_Prediction_Question_CreatedAt | DateTime | When the market was created, UTC. |
| Trade_Prediction_Question_GroupId | String | Event id that groups related markets; 0x when the market stands alone. |
| Trade_Prediction_Outcome_Id | String | Outcome position id, the same as OutcomeToken_AssetId. |
| Trade_Prediction_Outcome_Index | Int32 | The outcome's index in its condition, from 0. |
| Trade_Prediction_Outcome_Label | String | Outcome name, such as Yes, No, Up or Down; taken from the market's outcome list when the fill has none. |
| Transaction_From | String | Address that sent the transaction. Fills arrive through matchOrders calls sent by Polymarket's relayers (about 2,000 addresses on a sampled day), so this is not the person on either side. |
| Transaction_Hash | String | Hash of the fill's transaction. |
| Block_Date | Date | UTC date of the fill. |
| Call_Index | UInt32 | Index of the call inside the transaction. With Transaction_Hash and Log_Index it gives a unique row key. |
| Log_Index | UInt32 | Index of the event inside its call; it restarts in each call. |
| TransactionStatus_Success | Bool | False when the transaction failed. |
| Trade_OutcomeTrade_Fee_Amount | Decimal | Fee charged on this fill, in the cash token; 0 on every fill before January 2026. |
| Trade_OutcomeTrade_Fee_Currency_Symbol | String | Fee token symbol; empty when there is no fee. |
| Trade_OutcomeTrade_Fee_Payer | String | Address that paid the fee. |
| Trade_OutcomeTrade_Fee_Recipient | String | Address that got the fee. |
| Trade_IsTakerSide | Bool | True when the exchange contract is the buyer or seller: the row restates the taker's side of a match whose maker rows are already there. Sum rows where it is false for market volume. |

### prediction_settlements: 42 columns

One row per split, merge or payout of positions on the Conditional Tokens contracts, with the holder, shares, cash and USD value.

S3 prefix: matic/polymarket/PredictionSettlements
File naming: <start_block>_<end_block>.parquet, 50 blocks per file
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/matic/polymarket/PredictionSettlements/94364050_94364099.parquet
Sample updated: Sep 25, 2026

| column | type | description |
| --- | --- | --- |
| Block_Number | UInt64 | Polygon block of the event. |
| Block_Time | DateTime | Time of the block, UTC. |
| Call_Signature_Name | String | Function called: splitPosition, mergePositions or redeemPositions. |
| Log_Signature_Name | String | Event name: PositionSplit, PositionsMerge or PayoutRedemption. |
| Log_SmartContract | String | Contract that emitted the event: Conditional Tokens or the NegRisk adapter. |
| Settlement_EventType | String | Split, Merge or Redemption. |
| Settlement_Holder | String | Address whose cash or positions moved. On about a fifth of splits (a sampled day) this is an exchange or the NegRisk adapter, not a person. |
| Settlement_OutcomeTokenIds | String | ERC-1155 position ids involved, as text in the form ['id1', 'id2']. |
| Settlement_Amounts_Amount | Decimal | Shares split, merged or redeemed, to 6 decimal places. |
| Settlement_Amounts_AmountInUSD | Decimal | USD value of those shares at the time, equal to CollateralAmountInUSD. The earlier sample files carried 0 here. |
| Settlement_Amounts_CollateralAmount | Decimal | Cash locked by a split, freed by a merge, or paid out by a redemption (0 for a losing position). |
| Settlement_Amounts_CollateralAmountInUSD | Decimal | The cash amount times the hourly USDC.e price; 0 for cash tokens outside Polymarket's own (under 0.1% of rows). |
| Settlement_Prediction_CollateralToken_AssetId | String | Asset id of the cash token; 0 for ERC-20. |
| Settlement_Prediction_CollateralToken_BalanceSlotIndex | String | Storage slot of the cash token's balances; empty when 0. |
| Settlement_Prediction_CollateralToken_Decimals | Int32 | Cash token decimals: 6 for Polymarket's cash tokens. |
| Settlement_Prediction_CollateralToken_SmartContract | String | Contract of the cash token. |
| Settlement_Prediction_CollateralToken_Symbol | String | Cash symbol: USDC (the bridged USDC.e), WCOL (the NegRisk adapter's wrapped USDC.e) or pUSD. |
| Settlement_Prediction_ConditionId | String | Condition id of the market, used to join fills and market events. |
| Settlement_Prediction_Marketplace_SmartContract | String | Conditional Tokens contract or the NegRisk adapter. |
| Settlement_Prediction_Marketplace_ProtocolName | String | Name of the protocol: polymarket. |
| Settlement_Prediction_Marketplace_ProtocolFamily | String | Family of the protocol: Gnosis_CTF. |
| Settlement_Prediction_Outcome_Label | String | Outcome name; empty on splits and merges, which cover every outcome of the market. |
| Settlement_Prediction_Outcome_Index | Int32 | Index of the outcome, from 0. |
| Settlement_Prediction_Outcome_Id | String | Outcome position id. |
| Settlement_Prediction_OutcomeToken_SmartContract | String | ERC-1155 contract of the position. |
| Settlement_Prediction_OutcomeToken_Symbol | String | Symbol of the position token; usually empty. |
| Settlement_Prediction_OutcomeToken_AssetId | String | ERC-1155 token id of the position. |
| Settlement_Prediction_OutcomeToken_BalanceSlotIndex | String | Storage slot of the position balances; empty when 0. |
| Settlement_Prediction_OutcomeToken_ProtocolName | String | Position token standard: erc1155. |
| Settlement_Prediction_OutcomeToken_Name | String | Name of the position token; usually empty. |
| Settlement_Prediction_Question_Title | String | Question of the market this position belongs to. |
| Settlement_Prediction_Question_CreatedAt | DateTime | Creation time of that market, UTC. |
| Settlement_Prediction_Question_GroupId | String | Id of the event the market sits in; 0x if none. |
| Settlement_Prediction_Question_Id | String | Id of the market's question. |
| Settlement_Prediction_Question_Image | String | Image URL of the market. |
| Settlement_Prediction_Question_MarketId | String | Market id as used on the site. |
| Settlement_Prediction_Question_ResolutionSource | String | Source the market is decided by. |
| Transaction_From | String | Sender of the transaction. |
| Transaction_Hash | String | Hash of the settlement's transaction. |
| Block_Date | Date | UTC date of the event. |
| Call_Index | UInt32 | Call position in the transaction; part of the row key with Transaction_Hash and Log_Index. |
| Log_Index | UInt32 | Event position within its call, counted from 0 in each call. |

### prediction_managements: 29 columns

One row per outcome of a new market and one per market decided, with the question, rules, outcomes, oracle and, on decided markets, the winner.

S3 prefix: matic/polymarket/prediction_managements
File naming: <start_block>_<end_block>.parquet, 50 blocks per file
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/matic/polymarket/prediction_managements/94364050_94364099.parquet
Sample updated: Sep 25, 2026

| column | type | description |
| --- | --- | --- |
| Block_Number | UInt64 | Polygon block of the market event. |
| Block_Time | DateTime | Block time in UTC. |
| Call_Signature_Name | String | Function that made the event. |
| Log_Signature_Name | String | Event name: TokenRegistered for a new market, ConditionResolution for a decided one. |
| Log_SmartContract | String | Contract that emitted the event. |
| Management_EventType | String | Created (one row per outcome token of a new market) or Resolved (one row per decided market). |
| Management_Description | String | The market's full rules text. |
| Management_Group_Id | String | Event id that groups related markets; 0x when none. |
| Management_Group_Title | String | Title of that event. |
| Management_Group_Description | String | Text that explains that event. |
| Management_Prediction_Question_Id | String | Question id, as in the other two tables. |
| Management_Prediction_Question_MarketId | String | The site's numeric id for the market. |
| Management_Prediction_Question_Title | String | Market question. |
| Management_Prediction_Question_CreatedAt | DateTime | Market creation time, UTC. |
| Management_Prediction_Question_ResolutionSource | String | Source named to decide it. |
| Management_Prediction_Condition_Id | String | Condition id of the market; fills and settlements join on it. |
| Management_Prediction_Condition_Oracle | String | Oracle contract that may decide the market. |
| Management_Prediction_Condition_Outcomes_Label | String | All outcome names in index order, as text in the form ['Up', 'Down']. |
| Management_Prediction_Outcome_Id | String | Outcome position id. On Resolved rows, the winning outcome. |
| Management_Prediction_Outcome_Index | Int32 | Outcome index, from 0. On Resolved rows, the winner. |
| Management_Prediction_Outcome_Label | String | Outcome name: the winner on Resolved rows, empty on Created rows. |
| Management_Prediction_CollateralToken_SmartContract | String | Cash token contract of the market. |
| Management_Prediction_CollateralToken_Symbol | String | Symbol of the market's cash token. |
| Management_Prediction_Marketplace_SmartContract | String | Exchange or adapter contract the market is listed on. |
| Transaction_From | String | Sender address of the transaction. |
| Transaction_Hash | String | Hash of the event's transaction. |
| Block_Date | Date | UTC date of the market event. |
| Call_Index | UInt32 | Call number within the transaction, part of the row key. |
| Log_Index | UInt32 | Event number within its call; it restarts per call. |

## Price

- Latest month (Aug 24, 2026 → Sep 24, 2026): $400 one-time, USD
- Last 6 months (Mar 24, 2026 → Sep 24, 2026): $2,000 one-time, USD
- Full history (Sep 1, 2025 → Sep 24, 2026): $4,000 one-time, USD

Every window includes all 3 tables and 120 columns. Only the time range changes.

## Questions buyers ask

Q: What is in the Polymarket dataset?
A: Three Parquet tables joined by one key, the market's condition id. The trades table has one row per order fill on Polymarket's exchanges, with both addresses, shares, price, fee and the market question. The settlements table has one row per split, merge or payout of positions, so you can see who cashed out and for how much. The markets table has a row for each outcome of a new market and one row per market decided, naming the winner.

Q: How big is it?
A: About 1.80 billion fills, 1.11 billion settlement rows and 5.4 million market events since 1 September 2025, roughly 374 GB as Parquet, going by the sample files. The last 6 months hold about 1.07 billion fills and the latest month about 120 million. Row counts come from the live tables; exact figures arrive with the delivery manifest.

Q: How far back does it go?
A: From 1 September 2025, the first day of steady coverage in our index, to yesterday. Polymarket has run since 2020; the months before September 2025 are not in our index.

Q: How do I get market volume without counting fills twice?
A: Use the rows where Trade_IsTakerSide is false. Each match also writes one row for the taker's side, with the exchange contract as buyer or seller, and those rows are 34 to 44% of each month. Summing every row nearly doubles volume. When both sides buy opposite outcomes, the exchange mints the shares and the two sides pay different prices, so maker and taker volume differ; maker rows are the rule our API uses.

Q: Which markets are covered?
A: Markets on the main exchange and on the NegRisk exchange for events with many outcomes, and on the new exchange contracts that took over from both in April 2026. About 2.3 million markets had fills in the period. Short Up or Down crypto markets are 61 to 85% of fills on the main exchange in each month.

Q: How do I find who won and who got paid?
A: Resolved rows in the markets table name the winner in the outcome columns. Payout rows in the settlements table show what each holder got; on a sampled day, 97.2% of paid redemptions were on the outcome the resolution named. Join on the condition id.

Q: How are fills valued in USD?
A: Cash amount times the hourly price of USDC.e from our own price series. Polymarket settles in USDC.e until April 2026 and in pUSD after, and the NegRisk adapter wraps USDC.e as WCOL; all three are priced as USDC.e. Price is cash per share, between 0 and 1. The few settlements in any other token carry a USD value of 0.

Q: How are these produced, and how were they checked?
A: Decoded from Polygon by our own indexer, which reads the exchange and Conditional Tokens events and ties each to its market's question and outcomes. Before release we ran the export queries over blocks 94,364,050 to 94,364,149: 6,976 fills, 4,110 settlement rows and 147 market events, each equal to the source table, with no repeated keys and every price between 0.001 and 0.999. A full day, 23 September 2026, matched the source row counts for all three tables.

Q: What should I watch out for?
A: Fees start in January 2026: every fill before then shows 0, and since then 35 to 84% of fills a month carry one, paid in the cash token. Transaction_From is a Polymarket relayer, not either person in the fill; use buyer and seller. On about a fifth of splits the holder is an exchange or the NegRisk adapter, not a person. Log_Index restarts inside each call, so key rows on hash, call index and log index. About 0.01% of fills have no market title.

Q: How do I load it?
A: One line in DuckDB: SELECT * FROM read_parquet('prediction_trades/*.parquet') LIMIT 10. Pandas works too: pandas.read_parquet(path). The sample files open without a login.

Q: How current is it, and how is it delivered?
A: Refreshed daily with T+1 latency, so a purchase made today includes everything to yesterday. Delivered as Parquet named by block range, 50 blocks per file, under a stable S3 layout with a JSON manifest listing every file and its sha256. Signed HTTPS links are emailed once the files are ready, or on request we deliver into your own S3, GCS or R2 bucket. Polygon DEX Trades also carries Polymarket fills since February 2026, as swaps without market titles or payouts.

## What this file is, and is not

This is a description of one dataset sold by Bitquery, written for assistants and for people. It lists every column but holds no data rows. The sample files linked under each table are real Parquet and are free to download. Figures here come from the product record and are exact unless marked otherwise; the delivery manifest is authoritative for a purchased file. If a question needs a row that is not in a sample, say so rather than guessing at it.