Query editor
WITH btc_tx AS (SELECTblock_date AS day,COUNT(*) AS btc_tx_countFROM bitcoin.transactionsWHERE block_date >= CURRENT_DATE - INTERVAL '120' DAYGROUP BY 1),btc_active AS (SELECTday,COUNT(DISTINCT address) AS btc_active_addressesFROM (SELECT block_date AS day, addressFROM bitcoin.inputsWHERE block_date >= CURRENT_DATE - INTERVAL '120' DAYAND address IS NOT NULLUNIONSELECT block_date AS day, addressFROM bitcoin.outputsWHERE block_date >= CURRENT_DATE - INTERVAL '120' DAYAND address IS NOT NULL) tGROUP BY 1),eth_daily AS (SELECTblock_date AS day,COUNT(*) AS eth_tx_count,COUNT(DISTINCT "from") AS eth_active_addressesFROM ethereum.transactionsWHERE block_date >= CURRENT_DATE - INTERVAL '120' DAYGROUP BY 1)SELECTCOALESCE(b.day, e.day) AS day,COALESCE(b.btc_tx_count, 0) AS btc_tx_count,COALESCE(e.eth_tx_count, 0) AS eth_tx_count,COALESCE(a.btc_active_addresses, 0) AS btc_active_addresses,COALESCE(e.eth_active_addresses, 0) AS eth_active_addressesFROM btc_tx bFULL OUTER JOIN eth_daily e ON b.day = e.dayLEFT JOIN btc_active a ON COALESCE(b.day, e.day) = a.dayORDER BY 1