Query editor
1SELECT2 block_date,3 COUNT(*) AS tx_count,4 SUM(output_value) AS btc_volume5FROM bitcoin.transactions6WHERE block_date >= CURRENT_DATE - INTERVAL '365' DAY7 AND NOT is_coinbase8GROUP BY 19ORDER BY 1 ASC
SELECT
block_date,
COUNT(*) AS tx_count,
SUM(output_value) AS btc_volume
FROM bitcoin.transactions
WHERE block_date >= CURRENT_DATE - INTERVAL '365' DAY
AND NOT is_coinbase
GROUP BY 1
ORDER BY 1 ASC