select date_trunc('week',date) as date,
replace(replace(replace(replace(replace(replace(protocol,' v3',''),' v2',''),' amm',''),'- elastic',''),'protocol',''),' concentrated liquidity','') as protocol,
sum(volume) as "Weekly volume"
from external.defillama.fact_dex_volume
where chain = 'base'
group by 1,2
order by 1 desc, 3 desc