{"columns":[{"name":"sentry","type":"string"},{"name":"txs_seen","type":"uint64"},{"name":"coverage_pct","type":"double"}],"n_rows":2,"rows_kept":2,"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":"sentry","type":"string","nullable":true,"metadata":null,"children":null},{"name":"txs_seen","type":"uint64","nullable":true,"metadata":null,"children":null},{"name":"coverage_pct","type":"double","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional binary field_id=-1 sentry (String);\n  optional int64 field_id=-1 txs_seen (Int(bitWidth=64, isSigned=false));\n  optional double field_id=-1 coverage_pct;\n}\n"},"kv_metadata":[["sql","\nWITH canonical_hashes AS (\n    SELECT DISTINCT hash\n    FROM canonical_beacon_block_execution_transaction\n    WHERE meta_network_name = 'mainnet'\n      AND slot_start_date_time >= '2025-12-16' AND slot_start_date_time < '2025-12-16'::date + INTERVAL 1 DAY\n),\ntotal_canonical AS (\n    SELECT count() AS total FROM canonical_hashes\n)\nSELECT\n    meta_client_name AS sentry,\n    count(DISTINCT hash) AS txs_seen,\n    round(count(DISTINCT hash) * 100.0 / (SELECT total FROM total_canonical), 2) AS coverage_pct\nFROM mempool_transaction\nWHERE meta_network_name = 'mainnet'\n  AND event_date_time >= '2025-12-16'::date - INTERVAL 1 HOUR\n  AND event_date_time < '2025-12-16'::date + INTERVAL 1 DAY\n  AND hash GLOBAL IN (SELECT hash FROM canonical_hashes)\nGROUP BY meta_client_name\nORDER BY txs_seen DESC\n"],["ARROW:schema",{"$cut":{"chars":2176,"head":""}}],["pandas","{\"index_columns\": [], \"column_indexes\": [], \"columns\": [{\"name\": \"sentry\", \"field_name\": \"sentry\", \"pandas_type\": \"unicode\", \"numpy_type\": \"string\", \"metadata\": null}, {\"name\": \"txs_seen\", \"field_name\": \"txs_seen\", \"pandas_type\": \"uint64\", \"numpy_type\": \"uint64\", \"metadata\": null}, {\"name\": \"coverage_pct\", \"field_name\": \"coverage_pct\", \"pandas_type\": \"float64\", \"numpy_type\": \"float64\", \"metadata\": null}], \"attributes\": {}, \"creator\": {\"library\": \"pyarrow\", \"version\": \"22.0.0\"}, \"pandas_version\": \"2.3.3\"}"]]}
["ethpandaops/mainnet/xatu-sentry-syd1-xatu-mimicry",877216,53.32]
["ethpandaops/mainnet/xatu-sentry-sfo3-xatu-mimicry",875896,53.24]