Query editor
WITH deltas AS(SELECT dst AS address, DATE(evt_block_time) AS dt, CAST(wad AS DOUBLE) AS deltaFROM maker_ethereum.DAI_evt_TransferUNION ALLSELECT src AS address, DATE(evt_block_time) AS dt, - CAST(wad AS DOUBLE) AS deltaFROM maker_ethereum.DAI_evt_TransferUNION ALLSELECT 0x197e90f9fad81970ba7976f33cbd77088e5d7cf7 AS address, DATE(call_block_time) AS dt, CAST(rad AS DOUBLE) / 1e27 AS deltaFROM maker_ethereum.VAT_call_moveWHERE call_successAND dst = 0x197e90f9fad81970ba7976f33cbd77088e5d7cf7UNION ALLSELECT 0x197e90f9fad81970ba7976f33cbd77088e5d7cf7 AS address, DATE(call_block_time) AS dt, -CAST(rad AS DOUBLE) / 1e27 AS deltaFROM maker_ethereum.VAT_call_moveWHERE call_successAND src = 0x197e90f9fad81970ba7976f33cbd77088e5d7cf7UNION ALLSELECT 0x197e90f9fad81970ba7976f33cbd77088e5d7cf7 AS address, DATE(call_block_time) AS dt, CAST(rad AS DOUBLE) / 1e27 AS deltaFROM maker_ethereum.VAT_call_suckWHERE call_successAND v = 0x197e90f9fad81970ba7976f33cbd77088e5d7cf7), deltas2 AS(SELECT CASE WHEN address = 0x197e90f9fad81970ba7976f33cbd77088e5d7cf7 THEN 'DSR' ELSE 'non-DSR' END AS wallet, address, deltas.dt, deltas.deltaFROM deltasWHERE address NOT IN (0x0000000000000000000000000000000000000000) /* burn address */UNION ALLSELECT wallet, NULL AS address, dt, 0 AS deltaFROM (SELECT 'DSR' AS wallet UNION SELECT 'non-DSR')CROSS JOINUNNEST(SEQUENCE(DATE('2020-01-01'), CURRENT_DATE, INTERVAL '1' DAY)) AS t(dt)), grouped AS(SELECT dt, SUM(CASE WHEN wallet = 'DSR' THEN delta ELSE 0 END) AS dsr_delta, SUM(CASE WHEN wallet = 'non-DSR' THEN delta ELSE 0 END) AS non_dsr_deltaFROM deltas2GROUP BY 1), dsr AS(SELECT DATE(call_block_time) AS dt