Query editor
-- DEX Volume Analysis for Last 7 Days (Stacked Bar Chart)-- SHROOMY Token: 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111WITH daily_volumes AS (-- Velodrome VolumeSELECTDATE_TRUNC('day', block_time) as trade_date,'Velodrome' as dex_name,SUM(amount_usd) as volume_usdFROM dex.tradesWHEREblock_time >= NOW() - interval '7' dayAND project = 'velodrome'AND (token_bought_address = 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111OR token_sold_address = 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111)GROUP BY 1UNION ALL-- InkySwap VolumeSELECTDATE_TRUNC('day', block_time) as trade_date,'InkySwap' as dex_name,SUM(amount_usd) as volume_usdFROM dex.tradesWHEREblock_time >= NOW() - interval '7' dayAND project = 'inkyswap'AND (token_bought_address = 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111OR token_sold_address = 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111)GROUP BY 1UNION ALL-- Uniswap VolumeSELECTDATE_TRUNC('day', block_time) as trade_date,'Uniswap' as dex_name,SUM(amount_usd) as volume_usdFROM dex.tradesWHEREblock_time >= NOW() - interval '7' dayAND project = 'uniswap'AND (token_bought_address = 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111OR token_sold_address = 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111)GROUP BY 1),-- Create a complete date series for the last 7 daysdate_series AS (SELECT DATE_TRUNC('day', NOW() - interval '6' day) as trade_dateUNION ALL SELECT DATE_TRUNC('day', NOW() - interval '5' day)UNION ALL SELECT DATE_TRUNC('day', NOW() - interval '4' day)UNION ALL SELECT DATE_TRUNC('day', NOW() - interval '3' day)UNION ALL SELECT DATE_TRUNC('day', NOW() - interval '2' day)UNION ALL SELECT DATE_TRUNC('day', NOW() - interval '1' day)UNION ALL SELECT DATE_TRUNC('day', NOW())),-- Cross join dates with DEX names to ensure all combinations exist