DATE_TRUNC('week', date) AS week,

chain AS chain,

-- protocol AS protocol,

SUM(volume) AS weekly_volume

FROM external.defillama.fact_dex_volume

WHERE chain = lower('{{Chain}}')

GROUP BY 1, 2

ORDER BY week DESC