date_trunc('week', date) as week,

chain,

sum(volume) as volume_usd

FROM external.defillama.fact_dex_volume

WHERE chain In ('optimism', 'arbitrum', 'polygon', 'starknet', 'ethereum', 'avalanche', 'fantom', 'bsc')

AND date >= '2023-01-01'

GROUP BY 1,2