How to gather hourly data analysis of S3 bucket

To my knowledge if you want this data by hour you will need to enable access logs and then aggregate over the log data. Standard cloudwatch metrics only give you data over 24 hours. Access logs will include the object size of any Put request - See format here You could aggregate using Athena or other log analytics (log insights/opensearch/splunk). You can see the schema and example queries here