Query editor
-- 24-Hour Total Trading Volume for PURPLE Token (Counter Display)-- PURPLE Token: 0xD642B49d10cc6e1BC1c6945725667c35e0875f22-- Across all DEX marketsWITH volume_24h AS (-- Get all PURPLE trading volume from last 24 hours across all DEXesSELECTproject as dex_name,SUM(amount_usd) as volume_usd,COUNT(*) as trade_countFROM dex.tradesWHEREblock_time >= NOW() - interval '24' hourAND (token_bought_address = 0xD642B49d10cc6e1BC1c6945725667c35e0875f22OR token_sold_address = 0xD642B49d10cc6e1BC1c6945725667c35e0875f22)AND project IN ('velodrome', 'inkyswap', 'uniswap')AND amount_usd > 0GROUP BY project)-- Final aggregated volumeSELECTSUM(volume_usd) as total_volume_24h_usd,SUM(trade_count) as total_trades_24h,COUNT(*) as active_dex_count,ARRAY_JOIN(ARRAY_AGG(dex_name || ': ' || CAST(ROUND(volume_usd, 2) AS VARCHAR) ORDER BY volume_usd DESC), ', ') as volume_by_dexFROM volume_24h;