Query editor
SELECTdate AS block_date,SUM(total_fees) AS total_fees_btc,SUM(mint_reward) AS block_subsidy_btc,SUM(total_reward) AS total_miner_revenue_btcFROM bitcoin.blocksWHERE date >= CURRENT_DATE - INTERVAL '365' DAYGROUP BY 1ORDER BY 1 ASC