Query editor
WITH details_dedup AS (-- One row per condition_id from market_details (avoid duplicates per outcome/token)SELECTcondition_id,max_by(NULLIF(question, ''), last_uploaded_at) AS question_name,max_by(NULLIF(event_market_name, ''), last_uploaded_at) AS event_name,max_by(NULLIF(polymarket_link, ''), last_uploaded_at) AS market_link,max_by(tags, last_uploaded_at) AS tags,-- Resolved timestamp (best available field for "resolved markets")max_by(resolved_on_timestamp, last_uploaded_at) AS resolved_tsFROM polymarket_polygon.market_detailsWHERE condition_id IS NOT NULLGROUP BY 1),sector_map AS (SELECTcondition_id,COALESCE(question_name,event_name,market_link,CAST(condition_id AS varchar)) AS market_name,CASEWHEN tags IS NULL OR tags = '' THEN 'Other'WHEN LOWER(tags) LIKE '%politics%' THEN 'Politics'WHEN LOWER(tags) LIKE '%trump%' THEN 'Politics'WHEN LOWER(tags) LIKE '%election%' THEN 'Politics'WHEN LOWER(tags) LIKE '%sports%' THEN 'Sports'WHEN LOWER(tags) LIKE '%nhl%' THEN 'Sports'WHEN LOWER(tags) LIKE '%boxing%' THEN 'Sports'WHEN LOWER(tags) LIKE '%football%' THEN 'Sports'WHEN LOWER(tags) LIKE '%soccer%' THEN 'Sports'WHEN LOWER(tags) LIKE '%economy%' THEN 'Economy'WHEN LOWER(tags) LIKE '%crypto%' THEN 'Crypto'WHEN LOWER(tags) LIKE '%entertainment%' THEN 'Entertainment'WHEN LOWER(tags) LIKE '%celebrities%' THEN 'Entertainment'WHEN LOWER(tags) LIKE '%movies%' THEN 'Entertainment'ELSE INITCAP(TRIM(element_at(split(tags, ','), 1)))END AS sector,resolved_tsFROM details_dedup),market_trading AS (-- One row per market with trading statsSELECTcondition_id,MIN(block_time) AS first_trade_ts,MAX(block_time) AS last_trade_ts,SUM(amount) AS total_volume_usd,COUNT(*) AS trade_eventsFROM polymarket_polygon.market_tradesWHERE action = 'CLOB trade'AND amount > 0