Query editor
with transfer_detail as (select evt_block_time,"to" as address,value/1e18 as amountfrom erc20_ethereum.evt_Transferwhere contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2union allselect evt_block_time,"from" as address,-(value/1e18) as amountfrom erc20_ethereum.evt_Transferwhere contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2union all-- weth is special, as wrapping / unwrapping doesnt emit the transfer event, so you'll need the deposit / withdrawal functionsSELECT evt_block_time,dst,(wad/1e18) as amount from myname_ethereum.WETH9_evt_Depositunion allSELECT evt_block_time,src,-(wad/1e18) as amount from myname_ethereum.WETH9_evt_Withdrawal),address_balance as (select address,sum(amount) as balance_amountfrom transfer_detailgroup by address)select address,balance_amountfrom address_balanceorder by 2 desclimit 100