Query editor
WITH deposit_events AS (SELECTblock_time, block_date, varbinary_to_uint256(varbinary_substring(data, 1, 32)) / POWER(10, 18) AS deposit_amountFROM hyperevm.logsWHERE contract_address = 0x88888880793F89cE85777FF2e0e2d366bf05b20cAND topic0 = 0x90890809c654f11d6e72a28fa60149770a0d11ec6c92319d6ceb2bb0a4ea1a15), process_withdrawal_events AS (SELECTtx_hash, block_time, varbinary_to_uint256(varbinary_substring(data, 1, 32)) AS withdrawal_id, varbinary_to_uint256(varbinary_substring(data, 97, 32)) / POWER(10, 18) AS withdrawal_vhype_amount, 'processed' AS actionFROM hyperevm.logsWHERE contract_address = 0x88888880793F89cE85777FF2e0e2d366bf05b20cAND topic0 = 0x36c486f465d33811deb72acec843644580048a889ec96179091b1b1e3f9145b1), last_withdrawal_events AS (SELECT MAX(withdrawal_id) AS last_withdrawal_id, MAX(block_time) AS last_withdrawal_at FROM process_withdrawal_events)SELECTblock_time, block_time > (SELECT last_withdrawal_at FROM last_withdrawal_events) AS is_after_last_withdrawal_processing, deposit_amount, SUM(deposit_amount) OVER (ORDER BY block_time ASC) AS cumulative_depositFROM deposit_eventsORDER BY block_time DESC