Polymarket Dune Analytics (2026): Dashboards, Queries and Data

What Polymarket data is on Dune?

Dune's prediction markets section covers Polymarket, Kalshi and Hyperliquid HIP-4. Dune maintains the Polymarket tables itself and refreshes them about every hour. It builds them from decoded events on Polymarket's exchange contracts on Polygon, joined to market metadata from the Polymarket API. Polymarket's own docs list Dune among their on-chain data resources.

Every table below sits in the polymarket_polygon schema:

Gated tables still show up in Dune's data explorer, but queries against them need the entitlement on your workspace. The same goes for Dune's cross-venue tables, prediction_markets.markets, prediction_markets.trades and prediction_markets.ohlcv_hourly, which put Polymarket and Kalshi on one schema with every price expressed as the probability of Yes.

What columns does polymarket_polygon.market_trades have?

Most Polymarket work on Dune starts here. Each row is one fill, covering the original exchanges with USDC collateral and the V2 exchange with pUSD collateral, whose rows begin in April 2026. The columns you will use most:

Two details catch people out. First, Dune keeps both fill events of each CLOB match, and the table also includes mint and merge matches, where the exchange creates or redeems outcome tokens to fill orders. Filtering on is_taker_side keeps the taker leg only, which Dune says gives "single-counted volume that matches Polymarket's published methodology". Second, condition_id is binary here but a 0x text string in market_details, so join the two on asset_id and token_id, which both hold the outcome token ID.

How do you query Polymarket daily volume on Dune?

The queries below follow Dune's documented tables and columns as of October 2026, in DuneSQL, Dune's fork of Trino. Paste them into Dune's query editor. This one returns daily volume for the last 30 days:

SELECT
  date_trunc('day', block_time) AS day,
  SUM(amount) AS volume_usd,
  COUNT(*) AS trades
FROM polymarket_polygon.market_trades
WHERE block_time >= NOW() - INTERVAL '30' DAY
  AND is_taker_side
GROUP BY 1
ORDER BY 1

What are the top Polymarket markets by volume on Dune?

Dune's own example ranks markets by volume over the last seven days:

SELECT
  event_market_name,
  question,
  SUM(amount) AS volume_usd,
  COUNT(*) AS trades
FROM polymarket_polygon.market_trades
WHERE block_time >= NOW() - INTERVAL '7' DAY
  AND is_taker_side
GROUP BY 1, 2
ORDER BY 3 DESC
LIMIT 20

How do you find a wallet's Polymarket trades on Dune?

Use the account wallet address from the Polymarket profile menu, rather than the key that signs for it. Our Polymarket proxy wallet guide explains the difference. In market_trades, maker is the address whose order was filled, and on the taker leg it is the trader who took liquidity, so one filter on maker returns each of a wallet's fills once:

SELECT
  block_time,
  question,
  token_outcome,
  maker_side AS side,
  price,
  shares,
  amount AS amount_usd,
  is_taker_side AS took_liquidity,
  tx_hash
FROM polymarket_polygon.market_trades
WHERE block_time >= NOW() - INTERVAL '30' DAY
  AND maker = {{wallet}}
ORDER BY block_time DESC

For one wallet's recent activity without SQL, Polymarket's own Data API is quicker, as covered in the Polymarket Data API guide.

Which Polymarket dashboards are on Dune?

You can browse without writing any SQL. Polymarket's docs point to four community dashboards on Dune, and all four loaded when we checked on 3 October 2026:

Dune also curates a Prediction Markets collection with live dashboards, top markets and example queries. Polymarket's docs add three starter queries, covering volume, the USDC locked in Polymarket's contracts, and estimated open interest. Forking one is faster than starting from a blank editor. Viewing is free, but running a query or refreshing a dashboard spends credits.

How do you export Polymarket data from Dune?

There are two routes, and both are paid in credits as of October 2026:

• CSV download from a query's results, on the Plus and Enterprise plans or during a trial with Plus features.
• The Dune API, which runs SQL through POST /api/v1/sql/execute on api.dune.com, with an API key in the X-Dune-Api-Key header. It returns an execution_id that you poll for status and results, and it needs a paid plan or an active trial.

Exports cost 10 credits per MB on the Analyst plan and 2 per MB on Plus. New accounts get 2,500 trial credits for up to 14 days with Plus features, and after that the account is view-only until it upgrades.

What are the limits of Polymarket data on Dune?

• It runs about an hour behind. Hourly refreshes suit research and dashboards, not a bot reacting to a live market.
• It holds fills, not order books. Polymarket creates orders offchain, matches them through an operator and settles them onchain, so matched trades reach the chain but the book of resting orders does not. Depth comes from the CLOB, as covered in the Polymarket order book API guide.
• Candles and positions are gated. The public market_prices_hourly gives one end-of-hour price per token, forward-filled through quiet hours, with no open, high, low or volume.
• Labels can mislead. Resolution is positional. In market_details, outcome reads yes when the token at index 0 won, whatever its label, so use settlement_value, which is 1.0 for a winning token, 0.0 for a losing one and 0.5 for a 50/50 result.

How do you get Polymarket candles without writing SQL?

When candles need to feed an app or a backtest rather than a dashboard, an API is the shorter path. The Predictefy API serves OHLCV candles for Polymarket outcomes from its history endpoints, in one normalized schema across 15+ venues, so the code that reads Polymarket history reads Kalshi's too. A historical query costs 5 credits, and the Builder plan adds history replay and 12 months of history.

For files and archives rather than queries, see where to download Polymarket historical data and our guide to prediction market datasets.

Frequently Asked Questions