Query editor
with transfers as (selectblock_time, LOWER(SUBSTRING(CAST(topic1 as varchar), 13, 40)) as sender, LOWER(SUBSTRING(CAST(topic2 as varchar), 13, 40)) as receiver, BYTEARRAY_TO_UINT256 (data) / POWER(10, 18) as amount /* adjust decimals if needed */from bnb.logswhere contract_address = 0x4BfAa776991E85e5f8b1255461cbbd216cFc714fand topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef /* Transfer(address,address,uint256) */and block_time >= TIMESTAMP '2025-05-31'), balances as (selectreceiver as address, SUM(amount) as receivedfrom transfersgroup byreceiverunion allselectsender as address, - SUM(amount) as sentfrom transfersgroup bysender), net_balances as (selectaddress, SUM(received) as balancefrom balancesgroup byaddress)selectCOUNT(*) as current_holder_countfrom net_balanceswhere balance > 0;