Query editor
/* Check outflows from the final destination address and current balance status *//*WITH all_addresses AS (SELECT0x6c8ec8f14be7c01672d31cfa5f2cefeab2562b50 AS address,'Initial Theft Wallet' AS labelUNION ALLSELECT0x273589ca3713e7becf42069f9fb3f0c164ce850a,'Laundering Wallet 1'UNION ALLSELECT0x3b58192943ee6f9ae92d54dd1ef378cfd519862a,'Laundering Wallet 2'UNION ALLSELECT0x62afdd1bd84f6b152572404be90679ae58eb4862,'Laundering Wallet 3'UNION ALLSELECT0xd12f6e0fa7fbf4e3a1c7996e3f0dd26ab9031a60,'Final Destination'), inflows AS (SELECT"to" AS address,COALESCE(SUM(amount), 0) AS total_inFROM tokens_ethereum.transfersWHERE"to" IN (SELECTaddressFROM all_addresses)AND block_time >= CAST('2026-01-08 00:00:00' AS TIMESTAMP)GROUP BY"to"), outflows AS (SELECT"from" AS address,COALESCE(SUM(amount), 0) AS total_outFROM tokens_ethereum.transfersWHERE"from" IN (SELECTaddressFROM all_addresses)AND block_time >= CAST('2026-01-08 00:00:00' AS TIMESTAMP)GROUP BY"from")SELECTa.label,a.address,COALESCE(i.total_in, 0) AS total_inflows,COALESCE(o.total_out, 0) AS total_outflows,COALESCE(i.total_in, 0) - COALESCE(o.total_out, 0) AS net_balanceFROM all_addresses AS aLEFT JOIN inflows AS iON a.address = i.addressLEFT JOIN outflows AS o