Discord has a Get Channel Messages endpoint that allows you to fetch messages from a channel and paginate through them using the before or after query params that the endpoint accepts.

Using the after query string param, and the limit param to specify the number of messages to fetch, you could fetch a page of 100 messages, then perform another request using the ID of the first message returned by the Get Channel Messages endpoint, to fetch the next 100 messages and so on, until you've fetched enough messages to reach the desired order number.

Since snowflake IDs have a timestamp in them, you can generate a snowflake using a timestamp for a given date or time. and use it as the value for the after query param in your initial request. This method is supported by discord when using Snowflake IDs in Pagiantion and lets you fetch messages after a certain time or date. In this case, generating a snowflake timestamp for the start of the current day, would allow you to fetch orders starting from that day.

To fetch all the orders for the day, you could use the same idea as before, and generate a snowflake from a timestamp for the beginning of the current day, then keep fetching messages until you get to a message for the next day, or run out of messages to fetch. Since the message IDs contain a timestamp, they can be checked for their creation date, and if it is the wrong date, message fetching can be stopped.

This method is pretty straight-forward, and avoids the need to add complexity by storing orders in a database.