Query editor
-- Solana: top 15 DEXes by volume (ranked by 7d, with 24h/30d)with vols as (select project,sum(case when block_time >= now() - interval '1' day then amount_usd else 0 end) as vol_24h,sum(case when block_time >= now() - interval '7' day then amount_usd else 0 end) as vol_7d,sum(amount_usd) as vol_30dfrom dex_solana.tradeswhere block_time > now() - interval '30' dayand amount_usd > 0 and amount_usd < 1e9group by 1)select row_number() over (order by vol_7d desc) as rank,project as dex,round(vol_24h/1e6, 2) as vol_24h_m_usd,round(vol_7d/1e6, 2) as vol_7d_m_usd,round(vol_30d/1e6, 2) as vol_30d_m_usd,round(100.0 * vol_7d / sum(vol_7d) over (), 2) as share_7d_pctfrom volsorder by vol_7d desclimit 15