Query editor
WITH excluded(addr) AS (VALUES(0x0000000000000000000000000000000000000000),(0xd5f7838f5c461feff7fe49ea5ebaf7728bb0adfa), -- mETH token(0xe3cbd06d7dadb3f4e6557bab7edd924cd1489e8f), -- Staking(0x38fdf7b489316e03ed8754ad339cb5c4483fdcf9) -- UnstakeRequestsManager),flows AS (SELECT evt_block_time, "to" AS addr, CAST(value AS DECIMAL(38,0)) AS deltaFROM mantle_ethereum.meth_evt_transferUNION ALLSELECT evt_block_time, "from" AS addr, -CAST(value AS DECIMAL(38,0)) AS deltaFROM mantle_ethereum.meth_evt_transfer),balances AS (SELECTaddr,sum(delta) / CAST(1e18 AS DECIMAL(38,0)) AS balance_methFROM flowsWHERE addr NOT IN (SELECT addr FROM excluded)AND evt_block_time < TIMESTAMP '2026-01-01 00:00:00'GROUP BY 1)SELECTaddr AS wallet,balance_meth,CASEWHEN balance_meth >= 100 THEN 'C_100+'WHEN balance_meth >= 10 THEN 'B_10-100'WHEN balance_meth >= 1 THEN 'A_1-10'ELSE 'NOT_ELIGIBLE'END AS tierFROM balancesWHERE balance_meth >= 1ORDER BY balance_meth DESC;