Query editor
with withdrawals AS(SELECTaccount AS address,SUM(CAST(amount AS DOUBLE) / 1e18) AS withdrawal_amountFROM redacted_ethereum.RLBTRFLY_evt_WithdrawnWHERE relock = FALSEAND evt_block_time >= CAST('2023-03-30' AS TIMESTAMP)AND evt_block_time < CAST('2023-03-31' AS TIMESTAMP)GROUP BY 1),lock AS(SELECTaccount AS address,SUM(CAST(amount AS DOUBLE) / 1e18) AS lock_amountFROM redacted_ethereum.RLBTRFLY_evt_LockedWHERE evt_block_time >= CAST('2023-03-30' AS TIMESTAMP)GROUP BY 1),outflow AS(SELECT"from" AS address,SUM(cast (value AS DOUBLE)/1e18) AS outflowFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xc55126051B22eBb829D00368f4B12Bde432de5DaAND evt_block_time >= CAST('2023-03-30' AS TIMESTAMP)AND to <> 0x742B70151cd3Bc7ab598aAFF1d54B90c3ebC6027GROUP BY 1),inflow_amount AS(SELECTto AS address,SUM(cast(value AS DOUBLE)/1e18) AS inflow_amountFROM erc20_ethereum.evt_TransferWHERE contract_address = 0xc55126051B22eBb829D00368f4B12Bde432de5DaAND to in (0x69145ffcd44b16677140170d399cdc9ca245ff24,0x8f544093191ceaac7a4f90bef33755dbf34be424,0x9fea6d71bed43ab13cff10d8eeb9354d47f4e42c,0xbdb849041edaf21f1b40a5b52ab4b18a8803a146,0x9aef7c447f6bc8d010b22aff52d5b67785ed942c,0xcada41bdb95227ee3f3c2f4a37a843d384fbb48d,0x119c7bc8eccabe20766544b54395ccb7d228bf0e,0x59198d89a4881265a1170073efe20188098da5ac,0x72cca842a7fb986cb81efcf168282ca78578f0da,0x87f8ab89edf94af400a636e297e758c7bd05f1cc,0xe42fc9d50eb4bcb72202c638f3d567bba9e58ab4,0x5fd0ff1925fd29c13fb4fa45869ace06e56a602a,0x06c68c8d06d17c5988eca4179213db5304e8682d,0x48520ea6ed9d1eda7abdc9e87206a0f57bf8c3f4,0x7fc05030a6fb04dd84c4e4a7540002136038b53e,0x16d2f86f30945bed4042593cbba1ec413cc11e3d,0x9c7141e5865a0e3653e6f102ed4ce8110a760874,0xd0d628acf9e985c94a4542cae88e0af7b2378c81,0x5b7dcb8ce882f3d4c953c9f9d79e08730efe4939,0x2d23b731e5f04996a2dfdbe434c7d922afdb5e00,0x0895b21d1b3abe7d4f761b5870c36887cb310a5b,0x28d60bac08c058a9f7374aa24f8a514f27aff2b2,0x74045116edd9359cbcb608f3cc026dacfb9ed8d1,0x1cf1270fbe90d656b20abadfd792232de72b710a,0xda4ad44954c137c98eb210612b0bc0f172df17c5,0x8fc6d9b4264da9595102f68329a699d6dac62aea,