Query editor
WITH deltas AS(-- DAI (non DSR)SELECT dst AS wallet, date_trunc('day', "evt_block_time") AS dt, CAST(wad AS INT256) AS deltaFROM maker_ethereum.DAI_evt_TransferWHERE evt_block_number >= 8928674 -- Nov-13-2019 09:22:33 PMUNION ALLSELECT src AS wallet, date_trunc('day', "evt_block_time") AS dt, -CAST(wad AS INT256) AS deltaFROM maker_ethereum.DAI_evt_TransferWHERE evt_block_number >= 8928674 -- Nov-13-2019 09:22:33 PM-- Add DSRunion allSELECT"to" AS address, date_trunc('day', "evt_block_time") AS dt, CAST(value AS DOUBLE) AS deltaFROM sky_ethereum.USDS_evt_TransferWHERE evt_block_number >= 20770191 -- Sep-17-2024 12:00:23 PMUNION ALLSELECT"from" AS address,DATE(evt_block_time) AS dt,-CAST(value AS DOUBLE) AS deltaFROM sky_ethereum.USDS_evt_TransferWHERE evt_block_number >= 20770191 -- Sep-17-2024 12:00:23 PMUNION ALLselect 0x197E90f9FAD81970bA7976f33CbD77088E5D7cf7 as wallet, date_trunc('day', ts) as dt, dai_value * 1e18 as deltafrom dune.steakhouse.result_sky_accountingwhere cast(code as varchar) = '21110'-- Add Surplus Bufferunion allselect 0xa950524441892a31ebddf91d3ceefa04bf454466 as wallet, date_trunc('day', ts) as dt, dai_value * 1e18 as deltafrom dune.steakhouse.result_sky_accountingwhere cast(code as varchar) like '31%' and code <> 32110), maturities AS(SELECT 'Speculative' AS wallet, maturity, weightFROM(VALUES('1-block', 0.122000000000000000000), ('1-day', 0.122000000000000000000), ('1-week', 0.234000000000000000000), ('1-month', 0.061000000000000000000), ('3-months', 0.09000000000000000000), ('1-year', 0.371000000000000000000)) AS t(maturity, weight)UNION ALLSELECT 'Organic' AS wallet