Query editor
WITH excluded(addr) AS (VALUES(0x0000000000000000000000000000000000000000),(0xd5f7838f5c461feff7fe49ea5ebaf7728bb0adfa), -- mETH token(0xe3cbd06d7dadb3f4e6557bab7edd924cd1489e8f), -- Staking(0x38fdf7b489316e03ed8754ad339cb5c4483fdcf9) -- UnstakeRequestsManager),first_recv AS (SELECT"to" AS wallet,min(evt_block_time) AS first_timeFROM mantle_ethereum.meth_evt_transferWHERE "to" NOT IN (SELECT addr FROM excluded)GROUP BY 1),eoa_first AS (SELECT f.wallet, f.first_timeFROM first_recv fLEFT JOIN ethereum.contracts cON c.address = f.walletWHERE c.address IS NULL -- 过滤合约地址,保留EOA)SELECTdate_trunc('day', first_time) AS date,count(*) AS new_holders_eoa,sum(count(*)) OVER (ORDER BY date_trunc('day', first_time)) AS total_unique_holders_eoaFROM eoa_firstWHERE first_time >= TIMESTAMP '2025-01-01'GROUP BY 1ORDER BY 1;