Add negative scenarios for historical tests

[bilyana-gospodinova]

This task is opened due to the comment in here: #9262 (comment)

The goal is to add some scenarios that cover:

1. Pass a historical block before the point where the data was persisted -> the test fails since the data is not persisted yet. Assert for an exception.
2. Persist the data.
3. Pass a historical block after the point where the data was persisted -> the test succeeds since the data is available at that moment.