Query editor
WITHtransferEvents AS (SELECTcontract_address,evt_block_number,evt_block_time,evt_index,evt_tx_hash,"from","to",valueFROMerc20_{{blockchain}}.evt_transferWHEREevt_block_number >= {{initial_block_number}}AND contract_address = {{token_address}}),firstTransfers AS (SELECT"to" AS address,MIN(evt_block_time) AS first_transfer_timeFROMtransferEventsGROUP BY "to"),initialBalances AS (SELECTt."to" AS address,SUM(CAST(t.value AS INT256)) AS initial_balance,f.first_transfer_time AS initial_timeFROMtransferEvents tJOIN firstTransfers f ON t."to" = f.address AND t.evt_block_time = f.first_transfer_timeGROUP BYt."to",f.first_transfer_time),currentTransfers AS ((SELECT"to" AS address,SUM(CAST(value AS INT256)) AS balanceFROMtransferEventsGROUP BY "to")UNION ALL(SELECT"from" AS address,-SUM(CAST(value AS INT256)) AS balanceFROMtransferEventsGROUP BY "from")),currentBalances AS (SELECTaddress,SUM(balance) / {{decimal}} AS balance