Query editor
-- gyroscope 30d volume: https://dune.com/queries/3926894/6602441-- other 30d volumes: https://dune.com/queries/4319-- combined: https://dune.com/queries/3926923WITHdex_volumes AS (SELECTproject AS "project",SUM(CAST(amount_usd AS DOUBLE)) AS usd_volumeFROMdex."trades" AS tWHEREblock_time > NOW() - INTERVAL '30' dayAND project IN ('uniswap', 'pancakeswap', 'curve', 'aerodrome', 'dodo', 'ramses', 'balancer', 'camelot', 'trader_joe', 'quickswap', 'sushiswap', 'maverick', 'velodrome', 'fraxswap', 'gmx', 'beethoven_x')GROUP BYproject),gyroscope_volume AS (SELECT'gyroscope' AS "project",trailing_30d_total_volume_usd AS usd_volumeFROM query_3926894ORDER BY trailing_30d_total_volume_usd DESCLIMIT 1),adjusted_dex_volumes AS (SELECTproject,CASEWHEN project = 'balancer' THEN usd_volume - (SELECT usd_volume FROM gyroscope_volume)ELSE usd_volumeEND AS usd_volumeFROM dex_volumes),combined_volumes AS (SELECT * FROM adjusted_dex_volumesUNION ALLSELECT * FROM gyroscope_volume)SELECTROW_NUMBER() OVER (ORDER BYusd_volume DESC NULLS FIRST) AS "rank",project AS "Project",usd_volume AS "30_days_volume",ROUND(COALESCE((SELECT usd_volume FROM gyroscope_volume), 0) / COALESCE(usd_volume, 1), 3) AS "gyroscope_share_percentage"FROM combined_volumesORDER BYusd_volume DESC NULLS FIRST;