Query editor
-- Top Unresolved (Open) Markets by Volume-- Identifies the markets that have accumulated the most trading volume but have not yet been resolved.WITH resolved_condition_ids AS (-- Get a list of all condition IDs that have already been resolvedSELECT DISTINCTt2.condition_idFROMpolymarket_polygon.market_outcomes t1INNER JOINpolymarket_polygon.market_details t2 ON t1.question_id = t2.question_id)SELECTt2.question AS market_question, t2.event_market_name, SUM(t1.amount) AS total_market_volume_usd, MAX(t1.block_time) AS latest_trade_timeFROMpolymarket_polygon.market_trades t1INNER JOINpolymarket_polygon.market_details t2 ON t1.condition_id = t2.condition_idLEFT JOINresolved_condition_ids r ON t1.condition_id = r.condition_idWHEREr.condition_id IS NULL -- Filters out markets that are present in the resolved listGROUP BYt2.question, t2.event_market_nameORDER BYtotal_market_volume_usd DESCLIMIT 20 -- Top 20 unresolved markets