Skip to main content
The polymarket_polygon.market_trades table has one row per order-book fill on Polymarket, on Polygon. It covers every exchange version, shown in contract_version:
  • v1: the original CTF exchanges, paid in USDC.
  • v2: CTF Exchange V2, paid in pUSD, from April 2026.
  • v3: ExchangeV3, paid in pUSD. It settles the markets Polymarket calls Protocol V2.
Each fill keeps the market labels as they were when the fill was recorded. For the current labels, join market_details. Combo trades (multi-leg parlays) are in combo_trades. A fill can be a plain trade between a buyer and a seller. It can also be a mint or merge, where the exchange creates or redeems Yes/No pairs to fill an order. Every trade appears at least twice: once for each maker order and once for the taker. Filter WHERE is_taker_side to count each trade once. This matches the volume Polymarket publishes. Each row is unique on (block_month, trade_id).

Table Schema

Table sample

Query performance

market_trades is partitioned by block_month. Always filter on block_time or block_month, and for a single market also on market_id.

Example queries

Top markets by single-counted volume over the last 7 days:
Daily volume of every market in a recurring series, such as a daily crypto Up or Down series:

Previous version

Columns of the previous version, for queries that still use it. The migration guide maps each old column to its new name.