# Mining Pool Metric Imports — CSV Column Statistics

> Mining Pool Metric Imports — CSV Column Statistics is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-16).

Computes per-column statistics for a CSV file of mining pool metrics, validating up to 1000 rows against a declared table contract.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-bx-csv-pool-metrics-column-stats?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-16
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/mining-pool-metric-imports-csv-column-statistics-8fa2ab9d
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_81N1yDftSei2eFje444Cn

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability mining-pool-metric-imports-csv-column-statistics-8fa2ab9d -d '<json body>'
```

Example prompt: 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...

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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.

## Output

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.

## Request schema (JSON Schema)

```json
{
 "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
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/mining-pool-metric-imports-csv-column-statistics-8fa2ab9d/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)