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