Query editor
with transfers as (selectblock_time, LOWER(SUBSTRING(TRY_CAST(topic1 as VARCHAR), 13, 40)) as sender, LOWER(SUBSTRING(TRY_CAST(topic2 as VARCHAR), 13, 40)) as receiver, BYTEARRAY_TO_UINT256 (data) / POWER(10, 18) as amountfrom bnb.logswhere contract_address = 0x4BfAa776991E85e5f8b1255461cbbd216cFc714fand topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef /* Transfer(address,address,uint256) */and block_time >= TIMESTAMP '2025-05-31'and block_time < TRY_CAST(FORMAT('%s-%s-%s', SUBSTRING(CAST({{to_date}} as VARCHAR), 1, 4), SUBSTRING(CAST({{to_date}} as VARCHAR), 5, 2), SUBSTRING(CAST({{to_date}} as VARCHAR), 7, 2)) as TIMESTAMP)), 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 holder_countfrom net_balanceswhere balance > 0