Query editor
-- DEX Volume Analysis for Last 7 Days (Stacked Bar Chart)-- CAT Token: 0x20C69C12abf2B6F8D8ca33604DD25C700c7e70A5WITH 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 = 0x20C69C12abf2B6F8D8ca33604DD25C700c7e70A5OR token_sold_address = 0x20C69C12abf2B6F8D8ca33604DD25C700c7e70A5)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 = 0x20C69C12abf2B6F8D8ca33604DD25C700c7e70A5OR token_sold_address = 0x20C69C12abf2B6F8D8ca33604DD25C700c7e70A5)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 = 0x20C69C12abf2B6F8D8ca33604DD25C700c7e70A5OR token_sold_address = 0x20C69C12abf2B6F8D8ca33604DD25C700c7e70A5)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