Query editor
WITH dex_volumes AS (SELECTproject as dex_name,SUM(amount_usd) as volume_usdFROM dex.tradesWHERE (token_bought_symbol = 'BTC' OR token_sold_symbol = 'BTC' ORtoken_bought_symbol = 'WBTC' OR token_sold_symbol = 'WBTC')AND block_time >= NOW() - INTERVAL '30' dayGROUP BY 1),total_volume AS (SELECT SUM(volume_usd) as total_volume_usdFROM dex_volumes)SELECTdex_name,ROUND(volume_usd, 2) as volume_usd,ROUND(volume_usd / 1e6, 2) as volume_millions_usd,ROUND((volume_usd / tv.total_volume_usd) * 100, 2) as market_share_percent,ROUND(tv.total_volume_usd / 1e6, 2) as total_volume_millions_usdFROM dex_volumes dCROSS JOIN total_volume tvWHERE volume_usd > 0ORDER BY volume_usd DESC;