{"uid":"cap_-C4JrBqJe_-Slwk6VL_zJ","slug":"treasury-supplied-balances-category-frequencies-trailing-mean-series-3b4b3ea1","name":"Treasury Supplied Balances — Category Frequencies + Trailing Mean Series","description":"Treasury supplied balances — Category frequencies + Trailing mean series: Category frequencies + Trailing mean series 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-103?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"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_0dCdPHn49cLc26gJzENxe","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 category frequencies and a trailing mean series for treasury-supplied opening or closing balance records across up to 200 rows.","exampleAgentPrompt":"Can you run category frequency and trailing mean analysis on my treasury supplied balance records — I'll supply up to 50 rows each with a row_id, instrument_group, date, opening_balance, and closing_balance; analyze the closing_balance field with a window of 5?","exampleUseCases":[{"title":"Treasury instrument group distribution check","prompt":"I have 80 rows of treasury balance data with instrument groups, dates, opening and closing balances — can you compute the category frequencies for each instrument group and a trailing mean of the opening_balance using a window of 3?"},{"title":"Rolling average on daily closing balances","prompt":"Can you run a trailing mean series on our daily treasury closing balances for the last quarter? I have 90 rows with row IDs, instrument groups, and dates — use a window of 7 for the rolling average."},{"title":"Validate instrument group spread in treasury data","prompt":"I want to understand how evenly distributed our instrument groups are in our treasury records — please compute category frequencies and a trailing mean for closing_balance with a window of 4 across these 120 rows."}],"resultDescription":"Returns two analytical reports: (1) category frequency counts showing how often each instrument_group value appears in the submitted rows, and (2) a trailing mean series showing rolling averages of the selected numeric field (opening_balance or closing_balance) over the specified window size. Both reports are derived locally from the submitted data with no external lookups.","failureModes":["Fewer than 1 row submitted — validation error","More than 200 rows submitted — rejected with maxItems error","Window size larger than number of rows — may produce empty or partial trailing mean series","Invalid date format (not YYYY-MM-DD) — schema validation error","Numeric values outside ±1,000,000,000,000 range — rejected","Missing required fields (row_id, instrument_group, date, opening_balance, closing_balance) — schema error","Payment of 0.01 USDC not included or rejected — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need both a categorical frequency breakdown and a rolling mean time series for treasury balance data (opening or closing) in a single $0.01 USDC call. Ideal for batch offline analysis of up to 200 rows of treasury records without requiring any live data feeds or external lookups. Prefer this over separate analytics tools when you want two complementary reports — distribution and trend — delivered together cheaply and quickly.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:33:32.876Z","isFirstParty":false,"canonicalSlug":"treasury-supplied-balances-category-frequencies-trailing-mean-series-3b4b3ea1"}