Query editor
WITH sena_transfers AS (SELECT"from" AS from_address,"to" AS to_address,value / POW(10, 18) AS amount, -- Assuming 18 decimals for $sENAevt_block_time AS block_timestampFROMerc20_ethereum.evt_TransferWHEREcontract_address = FROM_HEX('8be3460a480c80728a8c4d7a5d5303c85ba7b3b9')AND evt_block_time BETWEEN TIMESTAMP '2024-09-02 00:00:00' AND TIMESTAMP '2025-03-23 23:59:59'),balance_changes AS (SELECTto_address AS wallet_address,SUM(amount) AS receivedFROMsena_transfersGROUP BYto_addressUNION ALLSELECTfrom_address AS wallet_address,-SUM(amount) AS receivedFROMsena_transfersGROUP BYfrom_address)SELECTwallet_address,SUM(received) AS sena_balanceFROMbalance_changesGROUP BYwallet_addressHAVINGSUM(received) > 0ORDER BYsena_balance DESC;