Query editor
-- 24-Hour Total Trading Volume for SHROOMY Token (Counter Display)-- SHROOMY Token: 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111-- Across all DEX marketsWITH volume_24h AS (-- Get all SHROOMY 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 = 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111OR token_sold_address = 0x0c5E2D1C98cd265C751e02F8F3293bC5764F9111)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;