Query editor
withblacklisted_addresses as (select contract from (values(0x47666fab8bd0ac7003bce3f5c3585383f09486e2),(0xa4b2fd68593b6f34e51cb9edb66e71c1b4ab449e),(0x36ed3c0213565530c35115d93a80f9c04d94e4cb),(0x1542368a03ad1f03d96D51B414f4738961Cf4443)) as b(contract)),withdrawals AS (SELECTevt_block_time AS block_time,evt_tx_hash AS tx_hash,"to" AS exploiter,"value" AS amount,contract_addressFROM erc20_ethereum.evt_transfer tJOIN blacklisted_addresses ba ON "to" = contract),data AS (SELECT w.block_time, w.tx_hash, w.exploiter, amount/POW(10, decimals) AS amount, erc.symbol,sum(amount/pow(10, decimals)) over (partition by erc.symbolorder by w.block_time) as cumulative_amountFROM withdrawals wJOIN tokens.erc20 erc ON erc.contract_address = w.contract_addressWHERE blockchain = 'ethereum')SELECT *FROM dataWHERE symbol != 'Daram'ORDER BY block_time DESC