You can just:
pip install chdb python3 -m chdb \ "SELECT * FROM \`hits.parquet\` \ LIMIT 10000000 \ INTO OUTFILE 'hits10m.parquet'"