Query editor
SELECTdate AS block_date,AVG(difficulty) AS avg_difficulty,AVG(size) / 1024.0 AS avg_block_size_kb,SUM(transaction_count) AS daily_tx_count,COUNT(*) AS blocks_minedFROM bitcoin.blocksWHERE date >= CURRENT_DATE - INTERVAL '365' DAYGROUP BY 1ORDER BY 1 ASC