Query editor
1SELECT2 DATE_TRUNC('month', block_time) AS month,3 SUM(amount_usd) AS total_volume4FROM dex_solana.trades5WHERE6 block_time >= TRY_CAST('2023-01-01' AS DATE)7GROUP BY8 19ORDER BY10 month
SELECT
DATE_TRUNC('month', block_time) AS month,
SUM(amount_usd) AS total_volume
FROM dex_solana.trades
WHERE
block_time >= TRY_CAST('2023-01-01' AS DATE)
GROUP BY
1
ORDER BY
month