Query editor
1SELECT2 blockchain,3 DATE_TRUNC('month', block_time),4 SUM(CAST(amount_usd AS DOUBLE)) AS usd_volume5FROM6 dex."trades" AS t 7WHERE8 block_time > NOW() - INTERVAL '3' year9GROUP BY10 1, 211ORDER BY 2 ASC, 3 DESC
SELECT
blockchain,
DATE_TRUNC('month', block_time),
SUM(CAST(amount_usd AS DOUBLE)) AS usd_volume
FROM
dex."trades" AS t
WHERE
block_time > NOW() - INTERVAL '3' year
GROUP BY
1, 2
ORDER BY 2 ASC, 3 DESC