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

from external.defillama.fact_dex_volume

where chain = 'linea'

group by 1

order by 1 desc, 2 desc