Query editor
WITH queue_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, 'queued' AS actionFROM hyperevm.logsWHERE contract_address = 0x88888880793F89cE85777FF2e0e2d366bf05b20cAND topic0 = 0xac39592b52b98ab542b1e680c2d9f02306d4588d970d156036112d83603ccb74), cancel_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, 'cancelled' AS actionFROM hyperevm.logsWHERE contract_address = 0x88888880793F89cE85777FF2e0e2d366bf05b20cAND topic0 = 0xb22134d72f63b7dd70b21f2b2ca318ed7713b1341d5c3564efb80665be253d9c), 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)SELECTqwe.withdrawal_id, qwe.withdrawal_id <= (SELECT last_withdrawal_id FROM last_withdrawal_events) AS is_processed, qwe.block_time AS withdrawal_request_time, qwe.withdrawal_vhype_amount, SUM(qwe.withdrawal_vhype_amount) OVER (ORDER BY qwe.withdrawal_id ASC) AS cumulative_withdrawal_vhype_amount, cwe.withdrawal_id IS NOT NULL AS is_cancelled, cwe.block_time AS cancel_request_timeFROM queue_withdrawal_events qweLEFT JOIN cancel_withdrawal_events cweON qwe.withdrawal_id = cwe.withdrawal_idORDER BY qwe.withdrawal_id DESC