Query editor
WITH eth_transfer_raw as (select "from" as address, (-1) * cast(value as decimal(38, 0)) as amountfrom ethereum.traceswhere (call_type is null or call_type not in ('delegatecall', 'callcode', 'staticcall'))and success = true and value > uint256 '0'union allselect "to" as address, cast(value as decimal(38, 0)) as amountfrom ethereum.traceswhere (call_type is null or call_type not in ('delegatecall', 'callcode', 'staticcall'))and success = true and value > uint256 '0'union allselect "from" as address, (-1) * cast(gas_price as double) * gas_used as amountfrom ethereum.transactions where success = true),eth_balance as (select address, sum(amount) / 1e18 as balancefrom eth_transfer_rawwhere address is not nullgroup by 1order by 2 desclimit 1000),pre2019_contracts AS (SELECT address, block_timeFROM ethereum.creation_tracesWHERE block_number <= 6988614AND block_month <= DATE '2019-01-01')SELECTb.address,b.balance,c.block_time as created_at,cm.contract_project,cm.contract_nameFROM eth_balance bINNER JOIN pre2019_contracts c ON b.address = c.addressLEFT JOIN contracts.contract_mapping cmON cm.contract_address = b.address AND cm.blockchain = 'ethereum'ORDER BY b.balance DESC