{"uid":"cap_A1POY8cQAcHC7kMMsZl2P","slug":"treasury-supplied-balances-adjacent-row-changes-explicit-missing-9bde631d","name":"Treasury Supplied Balances — Adjacent Row Changes + Explicit Missing-Value Fill","description":"Treasury supplied balances — Adjacent row changes + Explicit missing-value fill: Adjacent row changes + Explicit missing-value fill 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-162?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"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_1hq3S_tFK-aQavap1uAh6","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 adjacent-row changes and fills missing values in treasury balance data (opening_balance, closing_balance) for up to 200 rows, returning two local analytical reports.","exampleAgentPrompt":"I have 50 rows of treasury balance records with some missing opening_balance values — can you compute the adjacent row changes and fill those nulls using median imputation across all my instrument groups for dates in Q4 2026?","exampleUseCases":[{"title":"Treasury daily balance gap filling","prompt":"I've got a CSV of daily treasury closing balances for three instrument groups in October 2026 and there are about 8 null values scattered in — can you fill those missing closing_balance entries using median fill and also show me the day-over-day changes?"},{"title":"Instrument group opening balance analysis","prompt":"Can you run adjacent row change detection on my opening_balance data for treasury instruments from 2026-10-01 to 2026-10-31, using zero fill for any missing values? I have around 120 rows across four instrument groups."},{"title":"Balance data QA before reporting","prompt":"Before I submit this treasury report, can you check my closing_balance series for missing values and fill them with the mean, and also compute the row-by-row deltas so I can spot any anomalies in the 85 records I have?"}],"resultDescription":"Returns two analytical reports: (1) an adjacent row changes report showing delta values between consecutive rows for the selected balance field, and (2) a missing-value fill report showing which rows had nulls and what values were imputed using the chosen fill method (zero, mean, or median). Results cover up to 200 input rows processed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, instrument_group) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","Balance values outside ±1,000,000,000,000 range — rejected","Invalid fill method enum value — schema validation error","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you need both adjacent row delta computation and missing-value imputation on treasury balance data in a single $0.01 call. It is purpose-built for treasury opening_balance and closing_balance fields, supports up to 200 rows, and runs fully locally without any external data lookups or live market data dependencies. Prefer it over general analytics services when your data is already supplied and you need reproducible, offline-safe fill and change analysis.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:34:04.986Z","isFirstParty":false,"canonicalSlug":"treasury-supplied-balances-adjacent-row-changes-explicit-missing-9bde631d"}