S3 has a low-latency offering[0]
which promises single digit millisecond latency, I’m surprised not to see it mentioned.
[0]: https://aws.amazon.com/s3/storage-classes/express-one-zone/
[0]: https://aws.amazon.com/s3/storage-classes/express-one-zone/
Even for any single query it will likely run on multiple nodes with distributed workers gathering and processing data from storage layer, that is whole idea behind MapReduce after all.