{"uid":"cap_Zyptl6qBxpmfOfi87ZlMq","slug":"treasury-supplied-balances-grouped-numeric-summary-secondary-measure-6dbfb2be","name":"Treasury Supplied Balances — Grouped Numeric Summary + Secondary-Measure Weighted Mean","description":"Treasury supplied balances — Grouped numeric summary + Secondary-measure weighted mean: Grouped numeric summary + Secondary-measure weighted mean 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-096?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_7bo0dWdDAi5cVPe0DZwZp","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 grouped numeric summaries and secondary-measure weighted means for treasury supplied balance records (opening and closing balances) across up to 200 rows.","exampleAgentPrompt":"Run two grouped analytics reports on these treasury balance records — I need a grouped numeric summary and a secondary-measure weighted mean for the opening_balance field, grouped by instrument_group, for these 4 rows: row-1 group-a 2026-10-01 opening 10 closing 1, row-2 group-b 2026-10-02 opening 20 closing 2, row-3 group-a 2026-10-03 opening 15 closing 3, row-4 group-b 2026-10-04 opening 30 closing 4.","exampleUseCases":[{"title":"Monthly treasury balance group summary","prompt":"I have 150 rows of treasury balance data across several instrument groups for last month — can you give me a grouped numeric summary and weighted mean for the closing_balance field so I can see how each group performed?"},{"title":"Bond portfolio opening balance analysis","prompt":"Analyze these bond portfolio records grouped by instrument type — I need both a grouped numeric summary and a secondary-measure weighted mean for the opening_balance across all 80 rows I'm uploading."},{"title":"Treasury audit reconciliation by instrument","prompt":"Can you run grouped summary statistics and a weighted mean on our treasury supplied balances for Q3? I've got 200 rows with opening and closing balances per instrument group and I want to use opening_balance as the primary field."}],"resultDescription":"Returns two independent analytical reports: (1) a grouped numeric summary (count, min, max, mean, std dev, etc.) per instrument_group for the selected balance field, and (2) a secondary-measure weighted mean across groups using the other balance field as weights. Up to 200 rows processed per call.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, instrument_group, date, opening_balance, closing_balance) cause validation error","Invalid date format (not YYYY-MM-DD) causes schema rejection","Numeric values outside ±1,000,000,000,000 range rejected","Empty rows array returns error","Invalid field enum value (not opening_balance or closing_balance) causes failure"],"whenToPreferThis":"Choose this endpoint when you have treasury or financial balance data structured with instrument groups and need both a grouped numeric summary and a secondary-measure weighted mean in a single call for up to 200 rows. Ideal for financial analytics workflows where grouping by instrument category and computing weighted averages over balance fields is required without needing live market data or external lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:51:39.135Z","isFirstParty":false,"canonicalSlug":"treasury-supplied-balances-grouped-numeric-summary-secondary-measure-6dbfb2be"}