Revert backport of #33632: Parquet & s3 I/O changes
Ref: https://github.com/pandas-dev/pandas/issues/34626#issuecomment-640225867

Revert backport of https://github.com/pandas-dev/pandas/pull/33632
Backport: https://github.com/pandas-dev/pandas/pull/34173

cc @jorisvandenbossche @simonjayhawkins 

The doc failure is related to https://github.com/pandas-dev/pandas/pull/34458, which needs to be backported