Step 2: Convert the select query to an append query. On the Home tab, in the View group, click View, and then click Design View. On the Design tab, in the Query Type group, click Append. The Append dialog box appears. Next, you specify whether to append records to a table in the current database, or to a table in a different database.
I can't speak to how QuickSight works though, just that this is okay for Athena/SQL. If your query needs to do something like "show what happened between 5PM and 7PM for any day" then you would need to date_parse out just the time part (you would probably have to do that though if this were a timestamp e.g. extract the time portion from the timestamp).