Index list of bucket

You can Filtering and retrieving data using Amazon S3 Select https://docs.aws.amazon.com/AmazonS3/latest/userguide/selecting-content-from-objects.html or Analyzing Data in S3 using Amazon Athena https://aws.amazon.com/blogs/big-data/analyzing-data-in-s3-using-amazon-athena/ easily.

Please let me know if there is anything else you are looking and we can guide.

https://docs.aws.amazon.com/cli/latest/userguide/cli-services-s3-commands.html

use aws cli >
List buckets and objects To list your buckets, folders, or objects, use the s3 ls command. Using the command without a target or options lists all buckets.

Syntax

$ aws s3 ls <target> [--options]