Query editor
WITH first_transfers AS (SELECTcontract_address,MIN(evt_block_time) AS first_transfer_timeFROM erc20_base.evt_TransferWHEREcontract_address = 0x7300B37DfdfAb110d83290A29DfB31B1740219fE -- MAMO on BaseGROUP BY1), new_tokens AS (SELECTt.contract_address,t.symbol,t.decimals,ft.first_transfer_timeFROM tokens.erc20 AS tJOIN first_transfers AS ftON t.contract_address = ft.contract_addressWHEREt.blockchain = 'base'), token_holdings AS (SELECTt.contract_address,t.symbol,a."to" AS address,SUM(TRY_CAST(a.value AS DOUBLE) / POWER(10, t.decimals)) AS holdingFROM erc20_base.evt_Transfer AS aJOIN new_tokens AS tON a.contract_address = t.contract_addressWHERENOT a."to" IS NULLGROUP BY1, 2, 3UNION ALLSELECTt.contract_address,t.symbol,a."from" AS address,-SUM(TRY_CAST(a.value AS DOUBLE) / POWER(10, t.decimals)) AS holdingFROM erc20_base.evt_Transfer AS aJOIN new_tokens AS tON a.contract_address = t.contract_addressWHEREa."from" <> 0x2917956eff0b5eaf030abdb4ef4296df775009ca -- same exclusion as beforeGROUP BY1, 2, 3), token_balances AS (SELECTcontract_address,symbol,address,SUM(holding) AS balanceFROM token_holdingsGROUP BY1, 2, 3HAVINGSUM(holding) > 0 /* Exclude zero balances */AND SUM(holding) > 0.0001 /* Exclude negligible balances */), ranked_holders AS (SELECT