Query editor
WITH tokent AS (SELECTcontract_address,blockchainFROM tokens.erc20WHERE contract_address IN (0x7A56E1C57C7475CCf742a1832B028F0456652F97,0x4aae823a6a0b376De6A78e74eCC5b079d38cBCf7,0x3647c54c4c2C65bC7a2D63c0Da2809B399DBBDC0,0xbc78d84ba0c46dfe32cf2895a19939c86b81a777,0xa68d25fC2AF7278db4BcdcAabce31814252642a9,0x541FD749419CA806a8bc7da8ac23D346f2dF8B77,0x3B86Ad95859b6AB773f55f8d94B4b9d443EE931f,0xaE4EFbc7736f963982aACb17EFA37fCBAb924cB3)),pricet AS (SELECT priceFROM prices.latestWHERE contract_address = 0x7A56E1C57C7475CCf742a1832B028F0456652F97AND blockchain = 'ethereum'),-- ✅ 1-pass aggregation over transfers (very fast)balances AS (SELECTt.blockchain,t.contract_address,t.symbol,addr AS user,SUM(amount) AS balanceFROM (SELECTblockchain,contract_address,symbol,"to" AS addr,amountFROM tokens.transfersWHERE contract_address IN (SELECT contract_address FROM tokent)UNION ALLSELECTblockchain,contract_address,symbol,"from" AS addr,-amountFROM tokens.transfersWHERE contract_address IN (SELECT contract_address FROM tokent)) tGROUP BY 1,2,3,4HAVING SUM(amount) > 0.00000000001),supplyt AS (SELECT