Query editor
witheth_outflow (select date_trunc('day', block_time) as time,(-1) * sum(value) as amountfrom ethereum.traceswhere block_time >= Now() - interval '1 year'and (call_type not IN ('delegatecall', 'callcode', 'staticcall') OR call_type is null)and successand `from` in (LOWER('0x01c952174c24e1210d26961d456a77a39e1f0bb0'),LOWER('0x161ba15a5f335c9f06bb5bbb0a9ce14076fbb645'),LOWER('0x1fbe2acee135d991592f167ac371f3dd893a508b'),LOWER('0x21a31ee1afc51d94c2efccaa2092ad1028285549'),LOWER('0x28c6c06298d514db089934071355e5743bf21d60'),LOWER('0x29bdfbf7d27462a2d115748ace2bd71a2646946c'),LOWER('0x3c783c21a0383057d128bae431894a5c19f9cf06'),LOWER('0x47ac0Fb4F2D84898e4D9E7b4DaB3C24507a6D503'),LOWER('0x4976a4a02f38326660d17bf34b431dc6e2eb2327'),LOWER('0x515b72ed8a97f42c568d6a143232775018f133c8'),LOWER('0x56eddb7aa87536c09ccc2793473599fd21a8b17f'),LOWER('0x5a52e96bacdabb82fd05763e25335261b270efcb'),LOWER('0x73f5ebe90f27b46ea12e5795d16c4b408b19cc6f'),LOWER('0x8894e0a0c962cb723c1976a4421c95949be2d4e3'),LOWER('0x9696f59e4d72e237be84ffd425dcad154bf96976'),LOWER('0xBE0eB53F46cd790Cd13851d5EFf43D12404d33E8'),LOWER('0xa180fe01b906a1be37be6c534a3300785b20d947'),LOWER('0xa344c7aDA83113B3B56941F6e85bf2Eb425949f3'),LOWER('0xbd612a3f30dca67bf60a39fd0d35e39b7ab80774'),LOWER('0xdccf3b77da55107280bd850ea519df3705d1a75a'),LOWER('0xdfd5293d8e347dfe59e90efd55b2956a1343963d'),LOWER('0xe2fc31f816a9b94326492132018c3aecc4a93ae1'),LOWER('0xeb2d2f1b8c558a40207669291fda468e50c8a0bb'),LOWER('0xf977814e90da44bfa03b6295a0616a897441acec'))group by 1),eth_inflow (select date_trunc('day', block_time) as time, sum(value) as amountfrom ethereum.traceswhere block_time >= now() - interval '1 year'and (call_type not IN ('delegatecall', 'callcode', 'staticcall') OR call_type is null)and successand `to` in (LOWER('0x01c952174c24e1210d26961d456a77a39e1f0bb0'),LOWER('0x161ba15a5f335c9f06bb5bbb0a9ce14076fbb645'),LOWER('0x1fbe2acee135d991592f167ac371f3dd893a508b'),LOWER('0x21a31ee1afc51d94c2efccaa2092ad1028285549'),LOWER('0x28c6c06298d514db089934071355e5743bf21d60'),LOWER('0x29bdfbf7d27462a2d115748ace2bd71a2646946c'),LOWER('0x3c783c21a0383057d128bae431894a5c19f9cf06'),LOWER('0x47ac0Fb4F2D84898e4D9E7b4DaB3C24507a6D503'),LOWER('0x4976a4a02f38326660d17bf34b431dc6e2eb2327'),LOWER('0x515b72ed8a97f42c568d6a143232775018f133c8'),LOWER('0x56eddb7aa87536c09ccc2793473599fd21a8b17f'),LOWER('0x5a52e96bacdabb82fd05763e25335261b270efcb'),LOWER('0x73f5ebe90f27b46ea12e5795d16c4b408b19cc6f'),LOWER('0x8894e0a0c962cb723c1976a4421c95949be2d4e3'),LOWER('0x9696f59e4d72e237be84ffd425dcad154bf96976'),LOWER('0xBE0eB53F46cd790Cd13851d5EFf43D12404d33E8'),LOWER('0xa180fe01b906a1be37be6c534a3300785b20d947'),LOWER('0xa344c7aDA83113B3B56941F6e85bf2Eb425949f3'),LOWER('0xbd612a3f30dca67bf60a39fd0d35e39b7ab80774'),LOWER('0xdccf3b77da55107280bd850ea519df3705d1a75a'),LOWER('0xdfd5293d8e347dfe59e90efd55b2956a1343963d'),LOWER('0xe2fc31f816a9b94326492132018c3aecc4a93ae1'),LOWER('0xeb2d2f1b8c558a40207669291fda468e50c8a0bb'),LOWER('0xf977814e90da44bfa03b6295a0616a897441acec'))group by 1),eth_netflow as (select time, sum(amount/1e18) as amount from (select time, amount from eth_inflowunion ALLselect time, amount from eth_outflow)agroup by 1),erc20_outflow (select date_trunc('day', evt_block_time) as time,contract_address,(-1)*sum(value) as amountfrom erc20_ethereum.evt_Transferwhere evt_block_time >= now() - interval '1 year'and `from` in (LOWER('0x01c952174c24e1210d26961d456a77a39e1f0bb0'),LOWER('0x161ba15a5f335c9f06bb5bbb0a9ce14076fbb645')