{"uid":"cap_QhRGCyPpLbsUbbYd8qb38","slug":"wallet-inventory-trailing-mean-series-date-by-category-pivot-ef1367de","name":"Wallet Inventory Trailing Mean Series + Date by Category Pivot","description":"Wallet inventory — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot for supplied wallet inventory records (token_units, reference_price). 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-24-152?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","token_units","reference_price"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"token_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"reference_price":{"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","token_units":10,"reference_price":1,"instrument_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","token_units":20,"reference_price":2,"instrument_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","token_units":15,"reference_price":3,"instrument_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","token_units":30,"reference_price":4,"instrument_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["token_units","reference_price"],"type":"string","default":"token_units"},"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_TxmFvB4VxdWM99tRRLDc-","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 trailing mean time series and a date-by-category pivot table from supplied wallet inventory records (token_units or reference_price), returning two independent analytical reports.","exampleAgentPrompt":"Can you run a trailing mean series and a date-by-category pivot on my wallet inventory data? I have 4 rows with fields like instrument_group, date, token_units, and reference_price — use token_units as the field and a window of 2.","exampleUseCases":[{"title":"Portfolio rolling average analysis","prompt":"I have my crypto wallet inventory for the past few weeks — rows with dates, token units, and reference prices across two instrument groups. Can you compute the trailing mean series for token_units with a window of 3, and also give me a date-by-category pivot so I can see holdings by group over time?"},{"title":"Reference price trend pivot report","prompt":"Here are 50 rows of my wallet inventory records — each has a row_id, date, instrument_group, token_units, and reference_price. Please calculate the trailing mean for reference_price with a window of 5 and pivot the data by date and instrument_group so I can spot pricing patterns."},{"title":"Instrument group performance summary","prompt":"I want to analyze my wallet inventory — I'll supply up to 100 rows with token_units and reference_price. Run both the trailing mean series on token_units with a window of 4 and the date-by-category pivot grouped by instrument_group so I can compare performance across my asset categories."}],"resultDescription":"Two independent analytical reports: (1) a trailing mean time series computed over the chosen field (token_units or reference_price) using the specified rolling window, and (2) a date-by-category pivot table grouping values by date and instrument_group — both derived purely from the supplied wallet inventory rows, with no external data lookups.","failureModes":["Fewer than 1 row supplied — validation error","More than 200 rows submitted — rejected, exceeds limit","Window size larger than number of rows — trailing mean may produce no or partial results","Invalid date format (not YYYY-MM-DD) — schema validation failure","Missing required fields (row_id, instrument_group, date) — request rejected","Null token_units or reference_price values may reduce usable rows in the series","Payment not provided or insufficient USDC — 402 payment required error"],"whenToPreferThis":"Choose this endpoint when you have pre-collected wallet inventory data (token_units, reference_price per instrument group and date) and need both a rolling/trailing mean time series and a cross-tabulated date-by-category pivot in a single low-cost call. It is ideal for offline or batch analytical workflows on up to 200 rows where no live price feeds, predictions, or external enrichment are needed. Prefer alternatives if you need real-time price lookups, forecasting, or more than two report types simultaneously.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:33:58.117Z","isFirstParty":false,"canonicalSlug":"wallet-inventory-trailing-mean-series-date-by-category-pivot-ef1367de"}