Is there a way to query/filter the data every hour?
- Aave Protocol Aave
Expert
Is there a way to query/filter the data every hour? This currently returns the data for every block.
Thanks!
Answers 1
There are two ways I can think to do this.
- Query for all items then put them into a separate database such as BigQuery where you can filter by hour.
- 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;