select

trunc(x.date,'week') as week,

avg(tvl_usd) as tvl,

sum(volume) as dex_volume,

sum(dex_volume) over (order by week) as total_dex_volume

from external.defillama.fact_chain_tvl x

join external.defillama.fact_dex_volume y on lower(x.chain)=y.chain and x.date=y.date

where x.chain='Flow' and week<trunc(current_date,'week')

group by 1 order by 1 desc