TST: Refactor S3 tests #24035

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

Provide feedback