Query editor
WITH target_contracts AS (SELECT address AS contract_addressFROM ethereum.creation_tracesWHERE block_number <= 4832000AND block_month >= DATE '2015-07-01'AND block_month <= DATE '2017-12-01'),eth_in AS (SELECT t."to" AS addr, SUM(CAST(t.value AS DOUBLE)) / 1e18 AS total_inFROM ethereum.traces tINNER JOIN target_contracts tc ON t."to" = tc.contract_addressWHERE t.success = trueAND CAST(t.value AS DOUBLE) > 0GROUP BY t."to"),eth_out AS (SELECT t."from" AS addr, SUM(CAST(t.value AS DOUBLE)) / 1e18 AS total_outFROM ethereum.traces tINNER JOIN target_contracts tc ON t."from" = tc.contract_addressWHERE t.success = trueAND CAST(t.value AS DOUBLE) > 0GROUP BY t."from")SELECTCOALESCE(i.addr, o.addr) AS contract_address,COALESCE(i.total_in, 0) AS total_eth_received,COALESCE(o.total_out, 0) AS total_eth_sent,COALESCE(i.total_in, 0) - COALESCE(o.total_out, 0) AS estimated_balanceFROM eth_in iFULL OUTER JOIN eth_out o ON i.addr = o.addrWHERE COALESCE(i.total_in, 0) - COALESCE(o.total_out, 0) > 100ORDER BY estimated_balance DESC