Query editor
SELECTcase when project = 'whirlpool' then 'orca' else project end as project, COALESCE(sum(case when block_time > now() - interval '1' day then amount_usd else 0 end),0) as one_day_volume, COALESCE(sum(case when block_time > now() - interval '7' day then amount_usd else 0 end),0) as seven_day_volume, COALESCE(sum(case when block_time > now() - interval '30' day then amount_usd else 0 end),0) as thirty_day_volume, COALESCE(sum(amount_usd),0) as all_time_volumeFROM dex_solana.trades dxgroup by 1order by 2 desc