{"columns":[{"name":"DAY","type":"string"},{"name":"N_OBS","type":"int64"},{"name":"N_BUS","type":"int64"},{"name":"FILT_OBS","type":"int64"},{"name":"DIST_AVG","type":"double"},{"name":"DIST_STD","type":"double"},{"name":"DIST_MAX","type":"double"},{"name":"DIST_MAX_BUS","type":"string"},{"name":"INTERVAL_AVG","type":"duration[ns]"},{"name":"INTERVAL_STD","type":"duration[ns]"},{"name":"INTERVAL_MIN","type":"duration[ns]"},{"name":"INTERVAL_MAX","type":"duration[ns]"},{"name":"INTERVAL_MIN_BUS","type":"string"},{"name":"INTERVAL_MAX_BUS","type":"string"},{"name":"AVGSPEED_AVG","type":"double"},{"name":"AVGSPEED_STD","type":"double"},{"name":"AVGSPEED_MIN","type":"double"},{"name":"AVGSPEED_MAX","type":"double"},{"name":"AVGSPEED_MIN_BUS","type":"string"},{"name":"AVGSPEED_MAX_BUS","type":"string"},{"name":"VELOCITY_AVG","type":"double"},{"name":"VELOCITY_STD","type":"double"},{"name":"VELOCITY_MIN","type":"double"},{"name":"VELOCITY_MAX","type":"double"},{"name":"VELOCITY_MIN_BUS","type":"string"},{"name":"VELOCITY_MAX_BUS","type":"string"}],"n_rows":1,"rows_kept":1,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"parquet-cpp-arrow version 9.0.0","schema":{"fields":[{"name":"DAY","type":"string","nullable":true,"metadata":null,"children":null},{"name":"N_OBS","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"N_BUS","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"FILT_OBS","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"DIST_AVG","type":"double","nullable":true,"metadata":null,"children":null},{"name":"DIST_STD","type":"double","nullable":true,"metadata":null,"children":null},{"name":"DIST_MAX","type":"double","nullable":true,"metadata":null,"children":null},{"name":"DIST_MAX_BUS","type":"string","nullable":true,"metadata":null,"children":null},{"name":"INTERVAL_AVG","type":"duration[ns]","nullable":true,"metadata":null,"children":null},{"name":"INTERVAL_STD","type":"duration[ns]","nullable":true,"metadata":null,"children":null},{"name":"INTERVAL_MIN","type":"duration[ns]","nullable":true,"metadata":null,"children":null},{"name":"INTERVAL_MAX","type":"duration[ns]","nullable":true,"metadata":null,"children":null},{"name":"INTERVAL_MIN_BUS","type":"string","nullable":true,"metadata":null,"children":null},{"name":"INTERVAL_MAX_BUS","type":"string","nullable":true,"metadata":null,"children":null},{"name":"AVGSPEED_AVG","type":"double","nullable":true,"metadata":null,"children":null},{"name":"AVGSPEED_STD","type":"double","nullable":true,"metadata":null,"children":null},{"name":"AVGSPEED_MIN","type":"double","nullable":true,"metadata":null,"children":null},{"name":"AVGSPEED_MAX","type":"double","nullable":true,"metadata":null,"children":null},{"name":"AVGSPEED_MIN_BUS","type":"string","nullable":true,"metadata":null,"children":null},{"name":"AVGSPEED_MAX_BUS","type":"string","nullable":true,"metadata":null,"children":null},{"name":"VELOCITY_AVG","type":"double","nullable":true,"metadata":null,"children":null},{"name":"VELOCITY_STD","type":"double","nullable":true,"metadata":null,"children":null},{"name":"VELOCITY_MIN","type":"double","nullable":true,"metadata":null,"children":null},{"name":"VELOCITY_MAX","type":"double","nullable":true,"metadata":null,"children":null},{"name":"VELOCITY_MIN_BUS","type":"string","nullable":true,"metadata":null,"children":null},{"name":"VELOCITY_MAX_BUS","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional binary field_id=-1 DAY (String);\n  optional int64 field_id=-1 N_OBS;\n  optional int64 field_id=-1 N_BUS;\n  optional int64 field_id=-1 FILT_OBS;\n  optional double field_id=-1 DIST_AVG;\n  optional double field_id=-1 DIST_STD;\n  optional double field_id=-1 DIST_MAX;\n  optional binary field_id=-1 DIST_MAX_BUS (String);\n  optional int64 field_id=-1 INTERVAL_AVG;\n  optional int64 field_id=-1 INTERVAL_STD;\n  optional int64 field_id=-1 INTERVAL_MIN;\n  optional int64 field_id=-1 INTERVAL_MAX;\n  optional binary field_id=-1 INTERVAL_MIN_BUS (String);\n  optional binary field_id=-1 INTERVAL_MAX_BUS (String);\n  optional double field_id=-1 AVGSPEED_AVG;\n  optional double field_id=-1 AVGSPEED_STD;\n  optional double field_id=-1 AVGSPEED_MIN;\n  optional double field_id=-1 AVGSPEED_MAX;\n  optional binary field_id=-1 AVGSPEED_MIN_BUS (String);\n  optional binary field_id=-1 AVGSPEED_MAX_BUS (String);\n  optional double field_id=-1 VELOCITY_AVG;\n  optional double field_id=-1 VELOCITY_STD;\n  optional double field_id=-1 VELOCITY_MIN;\n  optional double field_id=-1 VELOCITY_MAX;\n  optional binary field_id=-1 VELOCITY_MIN_BUS (String);\n  optional binary field_id=-1 VELOCITY_MAX_BUS (String);\n}\n"},"kv_metadata":[["ARROW:schema",{"$cut":{"chars":6816,"head":""}}],["pandas","{\"index_columns\": [{\"kind\": \"range\", \"name\": null, \"start\": 0, \"stop\": 1, \"step\": 1}], \"column_indexes\": [{\"name\": null, \"field_name\": null, \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": {\"encoding\": \"UTF-8\"}}], \"columns\": [{\"name\": \"DAY\", \"field_name\": \"DAY\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"N_OBS\", \"field_name\": \"N_OBS\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"N_BUS\", \"field_name\": \"N_BUS\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"FILT_OBS\", \"field_name\": \"FILT_OBS\", \"pandas_type\": \"int64\", \"numpy_type\": \"int64\", \"metadata\": null}, {\"name\": \"DIST_AVG\", \"field_name\": \"DIST_AVG\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"DIST_STD\", \"field_name\": \"DIST_STD\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"DIST_MAX\", \"field_name\": \"DIST_MAX\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"DIST_MAX_BUS\", \"field_name\": \"DIST_MAX_BUS\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"INTERVAL_AVG\", \"field_name\": \"INTERVAL_AVG\", \"pandas_type\": \"object\", \"numpy_type\": \"timedelta64[ns]\", \"metadata\": null}, {\"name\": \"INTERVAL_STD\", \"field_name\": \"INTERVAL_STD\", \"pandas_type\": \"object\", \"numpy_type\": \"timedelta64[ns]\", \"metadata\": null}, {\"name\": \"INTERVAL_MIN\", \"field_name\": \"INTERVAL_MIN\", \"pandas_type\": \"object\", \"numpy_type\": \"timedelta64[ns]\", \"metadata\": null}, {\"name\": \"INTERVAL_MAX\", \"field_name\": \"INTERVAL_MAX\", \"pandas_type\": \"object\", \"numpy_type\": \"timedelta64[ns]\", \"metadata\": null}, {\"name\": \"INTERVAL_MIN_BUS\", \"field_name\": \"INTERVAL_MIN_BUS\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"INTERVAL_MAX_BUS\", \"field_name\": \"INTERVAL_MAX_BUS\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"AVGSPEED_AVG\", \"field_name\": \"AVGSPEED_AVG\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"AVGSPEED_STD\", \"field_name\": \"AVGSPEED_STD\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"AVGSPEED_MIN\", \"field_name\": \"AVGSPEED_MIN\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"AVGSPEED_MAX\", \"field_name\": \"AVGSPEED_MAX\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"AVGSPEED_MIN_BUS\", \"field_name\": \"AVGSPEED_MIN_BUS\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"AVGSPEED_MAX_BUS\", \"field_name\": \"AVGSPEED_MAX_BUS\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"VELOCITY_AVG\", \"field_name\": \"VELOCITY_AVG\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"VELOCITY_STD\", \"field_name\": \"VELOCITY_STD\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"VELOCITY_MIN\", \"field_name\": \"VELOCITY_MIN\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"VELOCITY_MAX\", \"field_name\": \"VELOCITY_MAX\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}, {\"name\": \"VELOCITY_MIN_BUS\", \"field_name\": \"VELOCITY_MIN_BUS\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}, {\"name\": \"VELOCITY_MAX_BUS\", \"field_name\": \"VELOCITY_MAX_BUS\", \"pandas_type\": \"unicode\", \"numpy_type\": \"object\", \"metadata\": null}], \"creator\": {\"library\": \"pyarrow\", \"version\": \"9.0.0\"}, \"pandas_version\": \"1.4.3\"}"]]}
["G1-2019-07-09",4899365,5252,4843890,0.2407486821878515,0.4190191848204877,51.904611862267345,"D12102",88826899850,287957970053,0,64342000000000,"A50022","D86170","Infinity",null,0.0,"Infinity","A50022","A50005",12.93459632857062,17.65455855211594,0.0,186.31,"A50022","C82604"]