{"uid":"cap_bW4h1JEtUwFUnFTJRS5Gi","slug":"wallet-inventory-two-measure-correlation-and-date-by-category-pivot-85786a14","name":"Wallet Inventory Two-Measure Correlation and Date-by-Category Pivot","description":"Wallet inventory — Two-measure correlation + Date by category pivot: Two-measure correlation + 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-182?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"}}},"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_I1Tvqn04gujnzIgWHqQGF","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":"Runs two analytical reports on supplied wallet inventory data: a Pearson/rank correlation between token_units and reference_price, and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"Run two analytical reports on my wallet inventory — a correlation between token_units and reference_price, and a date-by-category pivot — using these records: row-1 (2026-10-01, group-a, 10 units, $1), row-2 (2026-10-02, group-b, 20 units, $2), row-3 (2026-10-03, group-a, 15 units, $3).","exampleUseCases":[{"title":"Portfolio correlation check","prompt":"I have about 150 wallet inventory rows with token quantities and reference prices — can you compute the correlation between token_units and reference_price and also give me a pivot of the values broken down by date and instrument group?"},{"title":"DeFi holdings pattern analysis","prompt":"Here are my DeFi wallet records for the past month across three instrument groups. Run the two-report analysis: correlate token_units against reference_price, and pivot the data by date and category so I can see how each group performs over time."},{"title":"Crypto rebalancing data review","prompt":"Before I rebalance my portfolio, I want to see whether my token holdings and prices are correlated, and a breakdown of holdings by date and instrument group. I've got 80 rows of wallet data — can you run both reports?"}],"resultDescription":"Returns two structured analytical reports: (1) a two-measure correlation result quantifying the statistical relationship between token_units and reference_price across all supplied rows, and (2) a date-by-category pivot table showing aggregated values per date and instrument_group combination. Results are computed entirely from the user-supplied data with no external lookups.","failureModes":["Fewer than 1 row or more than 200 rows submitted — request rejected","Missing required fields (row_id, instrument_group, date, token_units, or reference_price) — validation error","Date values not matching YYYY-MM-DD format — schema validation failure","token_units or reference_price values outside allowed range — rejected","Insufficient numeric variation in data for meaningful correlation — may return NaN or degenerate result","Payment of 0.01 USDC not included or rejected — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of wallet inventory data with token_units and reference_price fields and need both a pairwise correlation report and a date-by-category pivot in a single low-cost call. It is ideal for crypto portfolio analysis workflows where you supply your own data and want purely local computation with no external API calls, live pricing, or predictions. Prefer it over generic BI tools when you need a lightweight, pay-per-use analytical micro-service integrated into an agentic finance workflow.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:33:08.333Z","isFirstParty":false,"canonicalSlug":"wallet-inventory-two-measure-correlation-and-date-by-category-pivot-85786a14"}