{"uid":"cap_81N1yDftSei2eFje444Cn","slug":"mining-pool-metric-imports-csv-column-statistics-8fa2ab9d","name":"Mining Pool Metric Imports — CSV Column Statistics","description":"Mining pool metric imports — Column statistics: Column statistics for Mining pool metric imports. Validate a declared CSV table contract, up to 1000 rows. Quoted cells supported; no external enrichment. Specialised preset in a shared 50-profile, 20-operation engine. 0.01 USDC includes one CSV column statistics report.","url":"https://market.datapackvibe.com/x402/assistant-bx-csv-pool-metrics-column-stats?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","default":"observation_id,observed_on,pool_id,hashrate_ths,reported_reward_btc\nrecord-a,2026-01-01,group-a,10,2\nrecord-b,2026-01-02,group-b,20,3","maxLength":100000,"minLength":1},"maximum":{"type":"number","default":1000000000000,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":-1000000000000,"maximum":1000000000000,"minimum":-1000000000000},"delimiter":{"enum":[",",";","\t"],"type":"string","default":","},"max_cell_length":{"type":"integer","default":1000,"maximum":5000,"minimum":1},"allowed_categories":{"type":"array","items":{"type":"string","default":"","maxLength":100,"minLength":1},"default":["group-a","group-b"],"maxItems":100,"minItems":0}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_UVxovfVwELfKQS8VEtme1","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Computes per-column statistics for a CSV file of mining pool metrics, validating up to 1000 rows against a declared table contract.","exampleAgentPrompt":"Can you run column statistics on this mining pool metrics CSV — it uses a comma delimiter, cells up to 1000 characters, numeric values between 0 and 1,000,000,000,000, and the allowed pool categories are group-a and group-b? Here's the CSV: observation_id,observed_on,pool_id,hashrate_ths,reported_reward_btc...","exampleUseCases":[{"title":"Validate daily pool hashrate report","prompt":"I've got a CSV of daily mining pool observations with columns for hashrate_ths and reported_reward_btc — can you run column statistics on it to check that all numeric values are between 0 and 500,000,000 and that pool_id only contains group-a or group-b? Delimiter is comma, max cell length 1000."},{"title":"Audit imported pool metrics for data quality","prompt":"We just imported a batch of mining pool metrics into our system and I need a column-level stats report on the CSV to catch any out-of-range values — numeric bounds are -1,000,000,000,000 to 1,000,000,000,000, comma-separated, and allowed categories are pool-alpha and pool-beta."},{"title":"Summarize CSV columns before pipeline ingestion","prompt":"Before I push this mining pool CSV into our analytics pipeline, can you generate column statistics for it? It's comma-delimited with up to 800 characters per cell, and I want to confirm the hashrate and reward columns stay within 0 to 999,999,999."}],"resultDescription":"Returns a per-column statistics report for the submitted mining pool metrics CSV, including numeric distribution metrics (min, max, mean, etc.), category value validation results, row counts, and any detected contract violations — covering up to 1000 rows with quoted-cell support.","failureModes":["CSV exceeds 100,000 character limit — request rejected","More than 1000 rows submitted — only first 1000 processed or error returned","Invalid delimiter specified (not comma, semicolon, or tab) — schema validation error","Numeric values outside declared minimum/maximum bounds flagged as violations","Cell length exceeds max_cell_length threshold — flagged or truncated","Malformed CSV (unclosed quotes, inconsistent columns) — parse error returned","Empty CSV string submitted — rejected by minLength:1 constraint"],"whenToPreferThis":"Choose this endpoint when you need fast, contract-bound column statistics for a mining pool metrics CSV — specifically when you want to validate that numeric columns (hashrate, reward) fall within declared bounds and that categorical columns (pool IDs) match an allowed list, without any external data enrichment. Ideal for pre-ingestion data quality checks on pool observation files up to 1000 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T00:53:32.506Z","isFirstParty":false,"canonicalSlug":"mining-pool-metric-imports-csv-column-statistics-8fa2ab9d"}