Query editor
WITH weekly_volume AS (SELECT DATE_TRUNC('week', dt) AS week, category, SUM(volume_usd) AS volume_usdFROM dune.adam_tehc_co.result_result_volume_bagsGROUP BY 1, 2UNION ALLSELECT DATE_TRUNC('week', dt) AS week, category, SUM(volume_usd) AS volume_usdFROM dune.adam_tehc_co.result_result_volume_moonshotGROUP BY 1, 2UNION ALLSELECT DATE_TRUNC('week', dt) AS week, category, SUM(volume_usd) AS volume_usdFROM dune.adam_tehc_co.result_result_volume_bonkGROUP BY 1, 2UNION ALLSELECT DATE_TRUNC('week', dt) AS week, category, SUM(volume_usd) AS volume_usdFROM dune.adam_tehc_co.result_result_volume_pumpdotfunGROUP BY 1, 2UNION ALLSELECT DATE_TRUNC('week', dt) AS week, category, SUM(volume_usd) AS volume_usdFROM query_7336421GROUP BY 1, 2)SELECT week AS dt, category, volume_usdFROM weekly_volumeWHERE week < DATE_TRUNC('week', CURRENT_DATE)ORDER BY dt DESC, category;