There are two ways I can think to do this.

1. Query for all items then put them into a separate database such as BigQuery where you can filter by hour.
2. The first result of this query will be the closest item to this timestamp; where:{reserve_: { symbol: "USDC", timestamp_lt: INSERT_TIMESTAMP_IN_THE_PAST }}, so you could repeatedly run this query, decreasing the timestamp by the interval you want;