Query editor
WITH tab1 AS (SELECTblock_date AS date,SUM(CASEWHEN flow = 'out' THEN -amountELSE amountEND) AS net_flows,SUM(CASEWHEN flow = 'out' THEN amountELSE 0END) AS outflow_volume,SUM(CASEWHEN flow = 'in' THEN amountELSE 0 END) AS inflow_volumeFROM (SELECTblock_date,'out' AS flow,SUM("value") AS amountFROM bitcoin.inputsWHERE address LIKE 'bc1pdwu79dady576y3fupmm82m3g7p2p9f6hgyeqy0tdg7ztxg7xrayqlkl8j9'GROUP BY 1,2UNION ALLSELECTblock_date,'in' AS flow,SUM("value") AS amountFROM bitcoin.outputsWHERE address LIKE 'bc1pdwu79dady576y3fupmm82m3g7p2p9f6hgyeqy0tdg7ztxg7xrayqlkl8j9'GROUP BY 1,2) subGROUP BY 1),date_range AS (SELECTMIN(date) AS min_date,MAX(date) AS max_dateFROM tab1),all_dates AS (SELECTd.dateFROM date_rangeCROSS JOIN UNNEST(SEQUENCE(min_date, max_date, INTERVAL '1' DAY)) AS d(date)),tab2 AS (SELECTad.date,COALESCE(t.net_flows, 0) AS net_flows,