Query editor
WITH redeem_requests AS (SELECTblock_time AS request_time, topic1 AS request_idFROM hyperevm.logsWHERE contract_address = 0xC898a5cbDb81F260bd5306D9F9B9A893D0FdF042AND topic0 = 0x55ba94d231fa70a45e82b0a1c6a60ef72e41bb2455385128ee5cf8d98c0c1c0eAND date_diff('day', block_time, current_timestamp) <= {{last_n_day}}), fulfill_requests AS (SELECTblock_time AS fulfillment_time, topic1 AS request_idFROM hyperevm.logsWHERE contract_address = 0xC898a5cbDb81F260bd5306D9F9B9A893D0FdF042AND topic0 = 0x03ea09e71742c9c754c9746b3e671ecb27fc372e3d29c31bac0192458ffd9d4b)SELECTvarbinary_to_uint256(rr.request_id) AS request_id, date_diff('day', rr.request_time, COALESCE(fr.fulfillment_time, current_timestamp)) AS day_waited, fr.request_id IS NOT NULL AS is_fulfilledFROM redeem_requests rrLEFT JOIN fulfill_requests frON rr.request_id = fr.request_idORDER BY 1