{"columns":[{"name":"client","type":"string"},{"name":"tcp_only","type":"uint64"},{"name":"quic_only","type":"uint64"},{"name":"both","type":"uint64"},{"name":"total","type":"uint64"},{"name":"quic_capable_pct","type":"double"}],"n_rows":11,"rows_kept":11,"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":"client","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tcp_only","type":"uint64","nullable":true,"metadata":null,"children":null},{"name":"quic_only","type":"uint64","nullable":true,"metadata":null,"children":null},{"name":"both","type":"uint64","nullable":true,"metadata":null,"children":null},{"name":"total","type":"uint64","nullable":true,"metadata":null,"children":null},{"name":"quic_capable_pct","type":"double","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional binary field_id=-1 client (String);\n  optional int64 field_id=-1 tcp_only (Int(bitWidth=64, isSigned=false));\n  optional int64 field_id=-1 quic_only (Int(bitWidth=64, isSigned=false));\n  optional int64 field_id=-1 both (Int(bitWidth=64, isSigned=false));\n  optional int64 field_id=-1 total (Int(bitWidth=64, isSigned=false));\n  optional double field_id=-1 quic_capable_pct;\n}\n"},"kv_metadata":[["sql","\nWITH peer_protocols AS (\n    SELECT\n        remote_agent_implementation as client,\n        remote_peer_id_unique_key,\n        groupUniqArray(remote_transport_protocol) as protocols\n    FROM default.libp2p_connected\n    WHERE meta_network_name = 'mainnet'\n      AND event_date_time >= '2026-01-24'::date - INTERVAL 6 DAY AND event_date_time < '2026-01-24'::date + INTERVAL 1 DAY\n      AND remote_agent_implementation NOT IN ('', 'unknown')\n    GROUP BY client, remote_peer_id_unique_key\n)\nSELECT\n    client,\n    countIf(has(protocols, 'tcp') AND NOT has(protocols, 'udp')) as tcp_only,\n    countIf(has(protocols, 'udp') AND NOT has(protocols, 'tcp')) as quic_only,\n    countIf(has(protocols, 'tcp') AND has(protocols, 'udp')) as both,\n    count(*) as total,\n    round(countIf(has(protocols, 'udp')) * 100.0 / count(*), 1) as quic_capable_pct\nFROM peer_protocols\nGROUP BY client\nHAVING total > 30\nORDER BY total DESC\n"],["ARROW:schema",{"$cut":{"chars":2988,"head":""}}],["pandas","{\"index_columns\": [], \"column_indexes\": [], \"columns\": [{\"name\": \"client\", \"field_name\": \"client\", \"pandas_type\": \"unicode\", \"numpy_type\": \"string\", \"metadata\": null}, {\"name\": \"tcp_only\", \"field_name\": \"tcp_only\", \"pandas_type\": \"uint64\", \"numpy_type\": \"uint64\", \"metadata\": null}, {\"name\": \"quic_only\", \"field_name\": \"quic_only\", \"pandas_type\": \"uint64\", \"numpy_type\": \"uint64\", \"metadata\": null}, {\"name\": \"both\", \"field_name\": \"both\", \"pandas_type\": \"uint64\", \"numpy_type\": \"uint64\", \"metadata\": null}, {\"name\": \"total\", \"field_name\": \"total\", \"pandas_type\": \"uint64\", \"numpy_type\": \"uint64\", \"metadata\": null}, {\"name\": \"quic_capable_pct\", \"field_name\": \"quic_capable_pct\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}], \"attributes\": {}, \"creator\": {\"library\": \"pyarrow\", \"version\": \"22.0.0\"}, \"pandas_version\": \"2.3.3\"}"]]}
["lighthouse",2424,609,495,3528,31.3]
["prysm",1697,605,236,2538,33.1]
["erigon",2404,0,0,2404,0.0]
["nimbus",1413,0,0,1413,0.0]
["teku",788,0,0,788,0.0]
["lodestar",216,0,0,216,0.0]
["rust-libp2p",37,40,2,79,53.2]
["grandine",29,10,16,55,47.3]
["tysm",48,0,0,48,0.0]
["xatu",47,0,0,47,0.0]
["hermes",35,0,0,35,0.0]