{"columns":[{"name":"date","type":"timestamp[ns]"},{"name":"transport","type":"string"},{"name":"connections","type":"uint64"},{"name":"unique_peers","type":"uint64"}],"n_rows":14,"rows_kept":14,"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 22.0.0","schema":{"fields":[{"name":"date","type":"timestamp[ns]","nullable":true,"metadata":null,"children":null},{"name":"transport","type":"string","nullable":true,"metadata":null,"children":null},{"name":"connections","type":"uint64","nullable":true,"metadata":null,"children":null},{"name":"unique_peers","type":"uint64","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional int64 field_id=-1 date (Timestamp(isAdjustedToUTC=false, timeUnit=nanoseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional binary field_id=-1 transport (String);\n  optional int64 field_id=-1 connections (Int(bitWidth=64, isSigned=false));\n  optional int64 field_id=-1 unique_peers (Int(bitWidth=64, isSigned=false));\n}\n"},"kv_metadata":[["sql","\nSELECT\n    toDate(event_date_time) as date,\n    remote_transport_protocol as transport,\n    count(*) as connections,\n    uniqExact(remote_peer_id_unique_key) as unique_peers\nFROM default.libp2p_connected\nWHERE meta_network_name = 'mainnet'\n  AND event_date_time >= '2026-01-14'::date - INTERVAL 6 DAY AND event_date_time < '2026-01-14'::date + INTERVAL 1 DAY\nGROUP BY date, transport\nORDER BY date, transport\n"],["ARROW:schema",{"$cut":{"chars":1900,"head":""}}],["pandas","{\"index_columns\": [], \"column_indexes\": [], \"columns\": [{\"name\": \"date\", \"field_name\": \"date\", \"pandas_type\": \"datetime\", \"numpy_type\": \"datetime64[ns]\", \"metadata\": null}, {\"name\": \"transport\", \"field_name\": \"transport\", \"pandas_type\": \"unicode\", \"numpy_type\": \"string\", \"metadata\": null}, {\"name\": \"connections\", \"field_name\": \"connections\", \"pandas_type\": \"uint64\", \"numpy_type\": \"uint64\", \"metadata\": null}, {\"name\": \"unique_peers\", \"field_name\": \"unique_peers\", \"pandas_type\": \"uint64\", \"numpy_type\": \"uint64\", \"metadata\": null}], \"attributes\": {}, \"creator\": {\"library\": \"pyarrow\", \"version\": \"22.0.0\"}, \"pandas_version\": \"2.3.3\"}"]]}
["2026-01-08T00:00:00.000000000","tcp",949806,16298]
["2026-01-08T00:00:00.000000000","udp",379128,2228]
["2026-01-09T00:00:00.000000000","tcp",961394,16052]
["2026-01-09T00:00:00.000000000","udp",413947,2247]
["2026-01-10T00:00:00.000000000","tcp",900683,15074]
["2026-01-10T00:00:00.000000000","udp",387892,2204]
["2026-01-11T00:00:00.000000000","tcp",913312,15259]
["2026-01-11T00:00:00.000000000","udp",427502,2218]
["2026-01-12T00:00:00.000000000","tcp",1078146,16746]
["2026-01-12T00:00:00.000000000","udp",444337,2234]
["2026-01-13T00:00:00.000000000","tcp",994247,16655]
["2026-01-13T00:00:00.000000000","udp",409327,2261]
["2026-01-14T00:00:00.000000000","tcp",1066150,16724]
["2026-01-14T00:00:00.000000000","udp",425439,2252]