Prediction Markets

Prediction markets turn event outcomes into tradable instruments. Dune provides curated prediction market data combining onchain activity from Polymarket (the largest onchain prediction market) — including Combos, Polymarket’s multi-leg parlays — with regulated event-contract reporting from Kalshi.

Maintained by: Dune (Polymarket = onchain models, Kalshi = partner data) · Refresh: ~24 hours · Chains: Polygon (Polymarket), Off-chain (Kalshi)

Explore on Dune

Browse the curated Prediction Markets collection on dune.com: live dashboards, top markets, and example queries.

Get This Data

Access prediction market data via API, Datashare, or the Dune App.

Available Protocols

Cross-venue

Unified markets, trades, and hourly OHLCV across Polymarket and Kalshi on one schema

Polymarket (Polygon)

Onchain markets, trades, combos (parlays), lifecycle actions, positions, and pricing

Kalshi

Regulated event contracts: market details, per-fill trades, hourly OHLCV, and legacy reports

All Tables

Complete inventory of all prediction market tables

When to Use These Tables

Use prediction market tables when you need to:

Track trading volumes, market activity, and implied probabilities on Polymarket
Analyze Polymarket Combos (multi-leg parlays): trades, legs, and settlement
Analyze event-contract pricing and settlement on Kalshi
Monitor user positions and portfolio composition across prediction markets
Research market resolution outcomes and pricing efficiency
Compare prediction market activity across venues

Query Performance

Polymarket trade and price tables are partitioned by block_month. Always filter on block_time ranges for market_trades, and use condition_id or question for market-specific queries.

-- ✅ Good: time-bounded with market filter
SELECT * FROM polymarket_polygon.market_trades
WHERE block_time >= NOW() - INTERVAL '7' DAY
  AND question LIKE '%election%'

Methodology

Polymarket tables are maintained by Dune. They combine decoded on-chain events from Polymarket’s exchange contracts on Polygon — the v1 CTF Exchange and NegRisk contracts, the v2 exchange stack, and the v3 Combos suite — with market metadata from the Polymarket API (stored in dune.polymarket_markets). Trading data includes three matching types: complementary (buyer matches seller), MINT (system mints new outcome tokens), and MERGE (system redeems YES+NO tokens for collateral); filter is_taker_side for single-counted volume. Combos (multi-leg parlays) live in the dedicated combo_* tables and also appear in polymarket_polygon.ohlcv_hourly and the cross-venue prediction_markets tables, flagged as parlays. Kalshi data is sourced from Kalshi’s public reporting. market_report contains market-level metadata; trade_report contains daily aggregated trade data (not individual fills — a single date and ticker can have multiple rows at different price points).

Example Queries

Top Polymarket markets by volume (last 7 days):

SELECT
  event_market_name,
  question,
  SUM(amount) AS total_volume_usd,
  COUNT(*) AS num_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

Price history for a specific Polymarket outcome:

SELECT
  p.hour,
  m.token_outcome,
  p.price
FROM polymarket_polygon.market_prices_hourly p
JOIN polymarket_polygon.market_details m
  ON p.token_id = m.token_id
WHERE m.question = 'Will Trump win the 2024 US Presidential Election?'
ORDER BY p.hour

dex.trades — DEX trading data (Polymarket uses Polygon DEX infrastructure)
prices.day / prices.hour — Token pricing feeds

Enterprise Data Solutions

Need custom prediction market datasets or dedicated support? Talk to our enterprise team.

Build Custom Models

Build private prediction market analytics pipelines with the dbt Connector.

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Prediction Markets

Explore on Dune

Get This Data

Available Protocols

Cross-venue

Polymarket (Polygon)

Kalshi

All Tables

When to Use These Tables

Query Performance

Methodology

Example Queries

Enterprise Data Solutions

Build Custom Models

Explore on Dune

Get This Data

​Available Protocols

Cross-venue

Polymarket (Polygon)

Kalshi

All Tables

​When to Use These Tables

​Query Performance

​Methodology

​Example Queries

​Related Tables

Enterprise Data Solutions

Build Custom Models

Available Protocols

When to Use These Tables

Query Performance

Methodology

Example Queries

Related Tables