Query editor
withall as (select dt from unnest(sequence(timestamp '2023-06-10', cast(current_timestamp as timestamp), interval '1' day)) tbl(dt)), rpeth_deposit_ as (selectdate_trunc('day', evt_block_time) as dt, sum(cast(value as double)) / 1e18 as amtfrom erc20_ethereum.evt_Transferwhere evt_block_number >= 17445564 -- Createdand to = 0x1bee69b7dfffa4e2d53c2a2df135c388ad25dcd2 -- rETH Pooland contract_address = 0xae78736cd615f374d3085123a210448e74fc6393 -- rETHgroup by 1), steth_deposit_ as (selectdate_trunc('day', evt_block_time) as dt, sum(cast(value as double)) / 1e18 as amtfrom erc20_ethereum.evt_Transferwhere evt_block_number >= 17445564 -- Createdand to = 0x93c4b944d05dfe6df7645a86cd2206016c51564d -- stETH Pooland contract_address = 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 -- stETH-- from (-- select-- evt_block_time-- , value-- from erc20_ethereum.evt_Transfer-- where evt_block_number >= 17445564 -- Created-- and to = 0x93c4b944d05dfe6df7645a86cd2206016c51564d -- stETH Pool-- and contract_address = 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 -- stETH-- union all-- select-- block_time as evt_block_time-- -- , substr(topic1, 12, 20) as "from"-- -- , substr(topic2, 12, 20) as to-- , bytearray_to_uint256(data) as value-- from ethereum.logs-- where block_number >= 17445564 -- Created-- and topic0 = 0x9d9c909296d9c674451c0c24f02cb64981eb3b727f99865939192f880a755dcb -- TransferShares-- and substr(topic2, 12, 20) = 0x93c4b944d05dfe6df7645a86cd2206016c51564d -- stETH Pool-- and contract_address = 0xae7ab96520de3a18e5e111b5eaab095312d7fe84 -- stETH-- )group by 1), cbeth_deposit_ as (selectdate_trunc('day', evt_block_time) as dt, sum(cast(value as double)) / 1e18 as amtfrom erc20_ethereum.evt_Transferwhere evt_block_number >= 17445564 -- Createdand to = 0x54945180db7943c0ed0fee7edab2bd24620256bc -- cbETH Pooland contract_address = 0xbe9895146f7af43049ca1c1ae358b0541ea49704 -- cbETHgroup by 1)