Query editor
WITH eth2_contracts AS (SELECTname,lower(tokens) AS token,decimalsFROM (SELECT 'Lido' AS name, '0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84' AS tokensUNION ALL SELECT 'Coinbase' AS name, '0xBe9895146f7AF43049ca1c1AE358B0541Ea49704' AS tokensUNION ALL SELECT 'Rocket Pool' AS name, '0xae78736Cd615f374D3085123A210448E74Fc6393' AS tokenUNION ALL SELECT 'Stakewise' AS name, '0xFe2e637202056d30016725477c5da089Ab0A043A' AS tokenUNION ALL SELECT 'Stakewise' AS name, '0x20BC832ca081b91433ff6c17f85701B6e92486c5' AS tokenUNION ALL SELECT 'Stakehound' AS name, '0xDFe66B14D37C77F4E9b180cEb433d1b164f0281D' AS tokenUNION ALL SELECT 'Ankr' AS name, '0xE95A203B1a91a908F9B9CE46459d101078c2c3cb' AS tokenUNION ALL SELECT 'CREAM' AS name, '0xcBc1065255cBc3aB41a6868c22d1f1C573AB89fd' AS tokenUNION ALL SELECT 'SharedStake' AS name, '0x898BAD2774EB97cF6b94605677F43b41871410B1' AS tokenUNION ALL SELECT 'StaFi' AS name, '0x9559Aaa82d9649C7A7b220E7c461d2E74c9a3593' AS token)mainLEFT JOIN tokens.erc20 ON lower(contract_address) = lower(tokens))SELECTtime,delta,name,SUM(delta) OVER (PARTITION BY name ORDER BY time) AS eth_staked,SUM(delta) OVER (ORDER BY time) AS eth_staked_totalFROM (SELECTtime,name,SUM(amount) AS deltaFROM (SELECTDATE(evt_block_time) AS time,name,value/POW(10,decimals) AS amountFROM erc20_ethereum.evt_TransferLEFT JOIN eth2_contracts ON contract_address = tokenWHERE contract_address IN (SELECT token FROM eth2_contracts)AND `from` = lower('0x0000000000000000000000000000000000000000')UNION allSELECTDATE(evt_block_time) AS time,name,-value/POW(10,decimals) AS amountFROM erc20_ethereum.evt_TransferLEFT JOIN eth2_contracts ON contract_address = tokenWHERE contract_address IN (SELECT token FROM eth2_contracts)AND `to` = lower('0x0000000000000000000000000000000000000000')UNION allselecttime,name,null::decimal as amountfrom (SELECT explode(sequence(DATE('2020-12-12'), DATE(NOW()), interval'1 day')) AS time)gg