Query editor
WITH eth_sums AS (SELECTwallet AS holder,SUM(CASE WHEN "to" = wallet THEN value ELSE 0 END) AS incoming,SUM(CASE WHEN "from" = wallet THEN value ELSE 0 END) AS outgoingFROM (SELECT "to" AS wallet, "from", "to", valueFROM erc20_ethereum.evt_transferWHERE contract_address = from_hex('15700b564ca08d9439c58ca5053166e8317aa138')UNION ALLSELECT "from" AS wallet, "from", "to", valueFROM erc20_ethereum.evt_transferWHERE contract_address = from_hex('15700b564ca08d9439c58ca5053166e8317aa138')) tGROUP BY wallet),avax_sums AS (SELECTwallet AS holder,SUM(CASE WHEN "to" = wallet THEN value ELSE 0 END) AS incoming,SUM(CASE WHEN "from" = wallet THEN value ELSE 0 END) AS outgoingFROM (SELECT "to" AS wallet, "from", "to", valueFROM erc20_avalanche_c.evt_transferWHERE contract_address = from_hex('b57b25851fe2311cc3fe511c8f10e868932e0680')UNION ALLSELECT "from" AS wallet, "from", "to", valueFROM erc20_avalanche_c.evt_transferWHERE contract_address = from_hex('b57b25851fe2311cc3fe511c8f10e868932e0680')) tGROUP BY wallet),plume_sums AS (SELECTwallet AS holder,SUM(CASE WHEN "to" = wallet THEN value ELSE 0 END) AS incoming,SUM(CASE WHEN "from" = wallet THEN value ELSE 0 END) AS outgoingFROM (SELECT "to" AS wallet, "from", "to", valueFROM erc20_plume.evt_transferWHERE contract_address = from_hex('1271656f45e251f588847721ba2c561dd1f0223f')UNION ALLSELECT "from" AS wallet, "from", "to", valueFROM erc20_plume.evt_transferWHERE contract_address = from_hex('1271656f45e251f588847721ba2c561dd1f0223f')) tGROUP BY wallet),eth AS (SELECT'ethereum' AS chain,holder,GREATEST(CAST(incoming AS double) - CAST(outgoing AS double), 0) AS balance_rawFROM eth_sumsWHERE GREATEST(CAST(incoming AS double) - CAST(outgoing AS double), 0) / 1e18 >= 1),