Query editor
1SELECT2 DATE_TRUNC('month', block_time) AS date,3 SUM(amount_usd) AS amount_usd4FROM5 nft.trades 6WHERE7 blockchain = 'ethereum'8 AND block_number >= 16308190 -- First block of 20239GROUP BY10 DATE_TRUNC('month', block_time)11ORDER BY12 date ASC
SELECT
DATE_TRUNC('month', block_time) AS date,
SUM(amount_usd) AS amount_usd
FROM
nft.trades
WHERE
blockchain = 'ethereum'
AND block_number >= 16308190 -- First block of 2023
GROUP BY
DATE_TRUNC('month', block_time)
ORDER BY
date ASC