select date_trunc('week',date) as date, sum(volume) as volume

from external.defillama.fact_dex_volume

where chain = 'zksync era'

group by 1

order by date desc, volume desc