Query editor
WITH all_chains AS (-- Outgoing transfers (negative)SELECT-CAST(value AS DOUBLE) / 1e18 AS amount,"from" AS user,'mcake' AS token,evt_block_timeFROM erc20_bnb.evt_transferWHERE contract_address = 0x581FA684D0Ec11ccb46B1d92F1F24C8A3F95C0CAand evt_block_time <= TIMESTAMP '2025-04-15 15:23:00'UNION ALL-- Incoming transfers (positive)SELECTCAST(value AS DOUBLE) / 1e18 AS amount,"to" AS user,'mcake' AS token,evt_block_timeFROM erc20_bnb.evt_transferWHERE contract_address = 0x581FA684D0Ec11ccb46B1d92F1F24C8A3F95C0CAand evt_block_time <= TIMESTAMP '2025-04-15 15:23:00'),cumulative_balances AS (SELECTuser,token,evt_block_time,SUM(amount) OVER (PARTITION BY user, token ORDER BY evt_block_time) AS balanceFROM all_chainswhere evt_block_time <= TIMESTAMP '2025-04-15 15:23:00'),latest_balances AS (SELECT *,ROW_NUMBER() OVER (PARTITION BY user, token ORDER BY evt_block_time DESC) AS rnFROM cumulative_balances)SELECT user, token, balanceFROM latest_balancesWHERE balance > 0 AND rn = 1ORDER BY balance DESC;