-- forked from 9d0dd060-fdf8-46ae-bae7-2a22b58e42d2
SELECT
DATE_TRUNC('month', date) AS month,
protocol,
SUM(volume) AS monthly_volume
FROM
external.defillama.fact_dex_volume
WHERE
chain = 'avalanche'
AND date BETWEEN '2022-01-01' AND '2023-02-28'
GROUP BY
1, 2
ORDER BY
1, 2