Firstly, Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. If you are seeing only the data from the latest version in Athen that means you only have the latest version of data in the underlying S3 folder. As per your description it seems that the new versions is overwriting the old version in S3.
Secondly, if you are able to compare versions in Glue that means that a new version of table is getting added to glue catalog each time data is unloaded into S3.
Lastly, if you are looking for an ability to query all the versions of your table snapshot. You have to unload and store the data of each new version as a new folder under products (example version_1, version_2 etc ) and add the same to glue catalog. You can consider using glue crawler  for adding the new partitions to the table.
Have a nice day!
Set correct Table level, Include Path and Exclude path.Accepted Answerasked a month ago
Include request_datetime from S3 file in Athena table - table made by Glueasked a month ago
Using S3 bucket as source for table in Athenaasked 23 days ago
Glue Workflow: Add same glue job multiple times, each with different parametersasked 3 months ago
Athena how to query different table versions.asked 2 months ago
How can I find the Query ID for an Athena Saved Query on AWS console?asked 8 months ago
Query Athena from s3 database - remove metadata/corrupted dataasked a month ago
Lake Formation (Database Snapshot) blueprint creates a workflow that does not work. "Internal service error: Invalid Input Provided"asked a month ago
s3 - date folder structure for etl data processes (airflow, etc)asked 17 days ago
How to store the Athena Query Results in DynamoDB table?asked 3 years ago