Curious, why not use httpfs extension and directly read multiple parquet files as demonstrated here[1]?

  SELECT *
    FROM read_parquet([
      's3://bucket/file1.parquet',
      's3://bucket/file2.parquet'
    ]);

[1]: https://duckdb.org/docs/extensions/httpfs/s3api#reading