You can use DuckDB in ipython to solve the globbing issue. Then you don't have to worry about OOMs with geopandas.