Query editor
WITHdetails AS (SELECT0x18084fba666a33d37592fa2633fd49a74dd93a88 AS token,18 AS dec),transfer1 AS (SELECTt.contract_address,t."from" AS address,- CAST(t.value AS DOUBLE) AS amountFROMerc20_ethereum.evt_Transfer AS t,detailsWHEREt.contract_address = tokenUNION ALLSELECTt.contract_address,t."to" AS address,CAST(t.value AS DOUBLE) AS amountFROMerc20_ethereum.evt_Transfer t,detailsWHEREt.contract_address = token),transfer as (SELECTt1.address,t1.amount,name as labelFROMtransfer1 t1LEFT JOIN ethereum.creation_traces tr ON t1.address = tr.addressLEFT JOIN labels.contracts lc ON t1.address = lc.addressWHEREtx_hash IS NOT NULL)selectrow_number() over (order bysub.balance_amount desc) as Rank_id,sub.address AS Wallet_Address,sub.label,round(sub.balance_amount, 2) AS Holding_AmountFROM(SELECTtt.address,sum(tt.amount / (power(10, dec))) AS balance_amount,tt.labelFROMtransfer tt,detailsGROUP BY1,3ORDER BY