Query editor
1SELECT 2 DATE_TRUNC('day', block_time) AS day,3 AVG(fee) / 1e8 AS avg_fee_btc,4 COUNT(*) AS tx_count5FROM bitcoin.transactions6WHERE block_time >= CURRENT_DATE - INTERVAL '90' DAY7GROUP BY 18ORDER BY 1 DESC
SELECT
DATE_TRUNC('day', block_time) AS day,
AVG(fee) / 1e8 AS avg_fee_btc,
COUNT(*) AS tx_count
FROM bitcoin.transactions
WHERE block_time >= CURRENT_DATE - INTERVAL '90' DAY
GROUP BY 1
ORDER BY 1 DESC