TST: Refactor S3 tests #24037

Job	Run time
Linux-32-bit	18m 22s
python-dev	0s
Linux-Musl	15m 36s
Pyodide build	23m 18s
windows-latest actions-311.yaml	35m 35s
macos-13 actions-312.yaml	32m 17s
macos-14 actions-311.yaml	25m 8s
windows-latest actions-312.yaml	38m 11s
macos-14 actions-312.yaml	39m 11s
windows-latest actions-310.yaml	36m 43s
macos-14 actions-313.yaml	16m 54s
macos-13 actions-310.yaml	26m 26s
windows-latest actions-313.yaml	44m 52s
macos-13 actions-313.yaml	32m 1s
macos-14 actions-310.yaml	24m 56s
ubuntu-24.04-arm actions-311.yaml	36m 9s
macos-13 actions-311.yaml	28m 2s
ubuntu-24.04-arm actions-313.yaml	35m 44s
Future infer strings (without pyarrow)	37m 56s
Freethreading	20m 58s
Pypy	1m 22s
Locale: zh_CN	23m 50s
ubuntu-24.04 actions-312.yaml	44m 14s
Numpy Dev	16m 32s
ubuntu-24.04 actions-313.yaml	46m 58s
Pyarrow Nightly	20m 14s
ubuntu-24.04-arm actions-310.yaml	36m 45s
Downstream Compat	5m 19s
Minimum Versions	22m 32s
ubuntu-24.04 actions-311.yaml	43m 3s
Locale: it_IT	24m 34s
Future infer strings	44m 47s
ubuntu-24.04 actions-310.yaml	46m 48s
ubuntu-24.04-arm actions-312.yaml	35m 31s
	16h 20m 48s

Provide feedback