{"uid":"cap_PKuSPbYNsqbj_ASvo_NKJ","slug":"treasury-supplied-balances-grouped-numeric-summary-category-frequencies-477f1dc3","name":"Treasury Supplied Balances — Grouped Numeric Summary + Category Frequencies","description":"Treasury supplied balances — Grouped numeric summary + Category frequencies: Grouped numeric summary + Category frequencies for supplied treasury supplied balances records (opening_balance, closing_balance). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-finance-16-086?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","opening_balance","closing_balance"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"closing_balance":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"opening_balance":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","closing_balance":1,"opening_balance":10,"instrument_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","closing_balance":2,"opening_balance":20,"instrument_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","closing_balance":3,"opening_balance":15,"instrument_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","closing_balance":4,"opening_balance":30,"instrument_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["opening_balance","closing_balance"],"type":"string","default":"opening_balance"}}},"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_akZib4OtdreBisnugwjbV","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 a grouped numeric summary and category frequency report for treasury supplied balance records (opening_balance and closing_balance) across up to 200 rows.","exampleAgentPrompt":"Can you run a grouped numeric summary and category frequency report on my treasury supplied balances? I have 4 rows with instrument groups like 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, and I want to analyze the opening_balance field.","exampleUseCases":[{"title":"Treasury balance distribution by instrument","prompt":"I have treasury balance records for October with instrument groups like 'bonds' and 'equities' — can you give me a grouped numeric summary and category frequency breakdown of the opening_balance across all those instrument groups?"},{"title":"Daily closing balance analytics","prompt":"Can you run a grouped summary and category frequencies on my closing_balance data? I have 50 rows of treasury records each tagged with an instrument_group and a date, and I want to see how they break down statistically."},{"title":"Audit prep for treasury positions","prompt":"I need to summarize 120 rows of treasury supplied balance records by instrument group — can you compute the grouped numeric stats and category frequencies for the closing_balance field so I can review the distribution before month-end?"}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary (e.g. mean, min, max, count) of the selected balance field (opening_balance or closing_balance) broken down by instrument_group, and (2) category frequency counts showing how often each instrument_group appears in the dataset. Covers up to 200 input rows.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, instrument_group, date, opening_balance, closing_balance) — validation error","Invalid date format (must match YYYY-MM-DD pattern) — schema validation failure","Balance values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — rejected","Empty rows array — minimum 1 item required","Invalid field enum value — must be 'opening_balance' or 'closing_balance'"],"whenToPreferThis":"Use this endpoint when you need both a grouped statistical summary and a category frequency count for treasury balance data in a single call. It is ideal for financial analytics workflows where you want to understand the distribution of opening or closing balances across instrument groups without building your own aggregation logic. Best suited for batch analysis of up to 200 records at $0.01 USDC per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T06:47:45.360Z","isFirstParty":false,"canonicalSlug":"treasury-supplied-balances-grouped-numeric-summary-category-frequencies-477f1dc3"}