Query editor
WITH btc_cex_addresses AS (SELECT DISTINCT from_utf8(address) AS addressFROM cex.addressesWHERE blockchain = 'bitcoin'),btc_inflow AS (SELECTo.block_date AS day,SUM(o.value) AS btc_inflowFROM bitcoin.outputs oJOIN btc_cex_addresses a ON o.address = a.addressWHERE o.block_date >= CURRENT_DATE - INTERVAL '120' DAYGROUP BY 1),btc_outflow AS (SELECTi.block_date AS day,SUM(i.value) AS btc_outflowFROM bitcoin.inputs iJOIN btc_cex_addresses a ON i.address = a.addressWHERE i.block_date >= CURRENT_DATE - INTERVAL '120' DAYGROUP BY 1),eth_flows AS (SELECTCAST(date_trunc('day', block_time) AS DATE) AS day,SUM(CASE WHEN LOWER(flow_type) = 'inflow' THEN amount ELSE 0 END) AS eth_inflow,SUM(CASE WHEN LOWER(flow_type) = 'outflow' THEN amount ELSE 0 END) AS eth_outflowFROM cex.flowsWHERE blockchain = 'ethereum'AND token_symbol = 'ETH'AND block_time >= CURRENT_DATE - INTERVAL '120' DAYAND LOWER(flow_type) IN ('inflow', 'outflow')GROUP BY 1)SELECTd.day,COALESCE(bi.btc_inflow, 0) AS btc_inflow,COALESCE(bo.btc_outflow, 0) AS btc_outflow,COALESCE(bi.btc_inflow, 0) - COALESCE(bo.btc_outflow, 0) AS btc_netflow,COALESCE(e.eth_inflow, 0) AS eth_inflow,COALESCE(e.eth_outflow, 0) AS eth_outflow,COALESCE(e.eth_inflow, 0) - COALESCE(e.eth_outflow, 0) AS eth_netflowFROM (SELECT day FROM btc_inflowUNIONSELECT day FROM btc_outflowUNIONSELECT day FROM eth_flows) dLEFT JOIN btc_inflow bi ON d.day = bi.dayLEFT JOIN btc_outflow bo ON d.day = bo.dayLEFT JOIN eth_flows e ON d.day = e.dayORDER BY d.day