Query editor
WITH tx_daily AS (SELECTblock_date AS day,COUNT(*) AS confirmed_tx,AVG(CASE WHEN is_coinbase = false THEN fee END) AS avg_fee_btcFROM bitcoin.transactionsWHERE block_date >= CURRENT_DATE - INTERVAL '120' DAYGROUP BY 1),block_intervals AS (SELECTdate AS day,time,date_diff('second',LAG(time) OVER (ORDER BY height),time) AS interval_secFROM bitcoin.blocksWHERE date >= CURRENT_DATE - INTERVAL '120' DAY),blocks_daily AS (SELECTday,COUNT(*) AS blocks_produced,AVG(interval_sec) AS avg_block_interval_secFROM block_intervalsWHERE interval_sec IS NOT NULLGROUP BY 1)SELECTt.day,t.confirmed_tx,t.avg_fee_btc,b.blocks_produced,b.avg_block_interval_secFROM tx_daily tLEFT JOIN blocks_daily b ON t.day = b.dayORDER BY t.day