Query editor
-- DEX Volume Analysis for Last 7 Days (Stacked Bar Chart)-- AK47 Token: 0x2a1bce657F919ac3f9aB50b2584CFC77563A02EcWITH 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 = 0x2a1bce657F919ac3f9aB50b2584CFC77563A02EcOR token_sold_address = 0x2a1bce657F919ac3f9aB50b2584CFC77563A02Ec)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 = 0x2a1bce657F919ac3f9aB50b2584CFC77563A02EcOR token_sold_address = 0x2a1bce657F919ac3f9aB50b2584CFC77563A02Ec)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 = 0x2a1bce657F919ac3f9aB50b2584CFC77563A02EcOR token_sold_address = 0x2a1bce657F919ac3f9aB50b2584CFC77563A02Ec)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