DATE_TRUNC('day', date) AS Day,

SUM(volume) AS "Daily Volume ($USD)"

FROM external.defillama.fact_dex_volume

WHERE chain IN('scroll', 'Scroll')

GROUP BY 1

ORDER BY 1 DESC