TST: Refactor S3 tests #24038

Job	Run time
Linux-32-bit	18m 11s
Pyodide build	23m 19s
python-dev	0s
Linux-Musl	15m 29s
macos-13 actions-312.yaml	25m 27s
macos-13 actions-313.yaml	32m 19s
macos-13 actions-311.yaml	29m 33s
windows-latest actions-310.yaml	34m 5s
macos-14 actions-310.yaml	31m 45s
windows-latest actions-313.yaml	42m 19s
macos-14 actions-313.yaml	24m 51s
windows-latest actions-311.yaml	36m 22s
macos-13 actions-310.yaml	30m 11s
macos-14 actions-311.yaml	21m 41s
macos-14 actions-312.yaml	21m 18s
windows-latest actions-312.yaml	38m 55s
ubuntu-24.04-arm actions-310.yaml	35m 31s
ubuntu-24.04 actions-310.yaml	45m 49s
ubuntu-24.04 actions-313.yaml	48m 8s
ubuntu-24.04-arm actions-312.yaml	35m 16s
Minimum Versions	25m 0s
Freethreading	21m 8s
ubuntu-24.04-arm actions-313.yaml	37m 7s
ubuntu-24.04 actions-311.yaml	41m 52s
ubuntu-24.04 actions-312.yaml	45m 32s
Pyarrow Nightly	21m 5s
ubuntu-24.04-arm actions-311.yaml	34m 40s
Pypy	1m 26s
Future infer strings	43m 1s
Future infer strings (without pyarrow)	38m 53s
Locale: zh_CN	25m 10s
Downstream Compat	5m 32s
Locale: it_IT	24m 43s
Numpy Dev	16m 44s
	16h 12m 22s

Provide feedback