Query editor
WITH tt AS (selectaddress,sum(amount / 1e18) as amountfrom(select"to" AS address,sum(TRY_CAST(value AS DOUBLE)) as amountfromerc20_ethereum.evt_TransferwhereDATE(evt_block_time) >= DATE('2021-08-03')and contract_address = 0x92D6C1e31e14520e676a687F0a93788B716BEff5group by1unionallselect"from" AS address,sum(TRY_CAST(value AS DOUBLE) * -1) as amountfromerc20_ethereum.evt_TransferwhereDATE(evt_block_time) >= DATE('2021-08-03')and contract_address = 0x92D6C1e31e14520e676a687F0a93788B716BEff5group by1) ttgroup by1)SELECTaddress,CASEWHEN cast(address as varbinary) = 0x01a9b6c6bce7cb729b0383cad2cd8b8a5cd1b767 THEN '1confirmation Fund I LP'WHEN cast(address as varbinary) = 0xac9878183dda3d9e38b0a84c4bebfaee36692ac0 THEN 'A-DKB-18-Fund'WHEN cast(address as varbinary) = 0x13e9ede7bf66fa0e3e369facea39673e93aac1b3 THEN 'A-DKB-18-Fund'WHEN cast(address as varbinary) = 0xEbC7D306b2a085125b7868a18fF5e387721b1b9e THEN 'A-DKB-18-Fund'WHEN cast(address as varbinary) = 0xcF217477798A05e409d8193348334E998c82909E THEN 'A-DKB-18-Fund'WHEN cast(address as varbinary) = 0x51691336aa88a14c2c55646166D12D1BAcb99f1c THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x76596f3fd7655a2cfa8605981baa46676718b5d5 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x6dd7829ce680aa3371184dcd85e21652cd823237 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x5aa6a4ffeca0ac490c4f2e0b12341c988610ac67 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x4385D35D6C2668a481EcCA73553d15AEfF30a979 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x383d8ebcd2ca72ebc6a5a627b1c9d17af84ec710 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x390f76272c69a42c4ceb5e7270b368c4e255ed81 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x3ecc07c75fcd5a93509e2a56f7123f85b9fc5aee THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x4621b8138830982d080b5eb337c3793065377635 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x764d16c451a71ce521a1b6df9bcb886a2b8dac48 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x81aa284df8a40c0011e608d3c3fa7c3bf7b65705 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0xa511221bbdef5de5b5ff757d6acc1d4dc3b62269 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0xb96eecf2b77bd21b16a7cd4d73771e67148b23f1 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0xcd375b6dc34c66f14a00b0c75e7897b31106f6fe THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0xce2d12d17bc1f818f4b6f9b81cd2c6b38ceacadf THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0xcfb78a4d0a063ee02f7ab49a67daf32da17fe865 THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0xd7ec2398980102d2e1994263777333491536ccee THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0xe630682b202e215eaed81b583a3e70fb56155e3f THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x8b5B4b920f1944826B54B80d921BAF178c0a554a THEN 'a16z / CNK Fund'WHEN cast(address as varbinary) = 0x2d88d1d3ba2fb5271c65778e3d9ab491dd65cf14 THEN 'Aaron Ng'