select date_trunc('week',date) as date, chain, sum(volume) as "Weekly volume"

from external.defillama.fact_dex_volume

where chain in ('arbitrum','optimism')

group by 1,2

order by 1 desc, 2 desc