Query editor
/* NegRisk vs. CTF Exchange Analysis *//* Categorizes trades based on the presence of the 'neg_risk' field to distinguish between the two main exchange types. */SELECTCASEWHEN NOT neg_risk IS NULL AND neg_risk = TRUETHEN 'NegRisk Exchange (Binary Market)'ELSE 'CTF Exchange (Multi-Outcome/AMM)'END AS exchange_type,COUNT(tx_hash) AS total_trades,SUM(amount) AS total_volume_usd,SUM(fee) AS total_fees_usd,AVG(amount) AS avg_trade_size_usdFROM polymarket_polygon.market_tradesGROUP BY1ORDER BYtotal_volume_usd DESC