{"uid":"cap_Ckifce6nd9T__y95oW5ra","slug":"trade-observations-duplicate-key-report-trailing-mean-series-add5bf92","name":"Trade Observations — Duplicate Key Report + Trailing Mean Series","description":"Trade observations — Duplicate key report + Trailing mean series: Duplicate key report + Trailing mean series for supplied trade observations records (export_amount, import_amount). 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-economics-06-061?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","export_amount","import_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"region":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"export_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"import_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","export_amount":10,"import_amount":1},{"date":"2026-10-02","region":"group-b","row_id":"row-2","export_amount":20,"import_amount":2},{"date":"2026-10-03","region":"group-a","row_id":"row-3","export_amount":15,"import_amount":3},{"date":"2026-10-04","region":"group-b","row_id":"row-4","export_amount":30,"import_amount":4}],"maxItems":200,"minItems":1},"field":{"enum":["export_amount","import_amount"],"type":"string","default":"export_amount"},"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_uDWcmZQjUyc3fKhfODCvU","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":"Analyzes up to 200 trade observation rows to produce a duplicate key report and a trailing mean series for export_amount or import_amount fields.","exampleAgentPrompt":"Check my trade observation records for duplicate keys and compute a 3-period trailing mean for export_amount — here are the rows: [{\"row_id\":\"r1\",\"region\":\"north\",\"date\":\"2025-01-01\",\"export_amount\":100,\"import_amount\":50},{\"row_id\":\"r2\",\"region\":\"south\",\"date\":\"2025-01-02\",\"export_amount\":200,\"import_amount\":75}].","exampleUseCases":[{"title":"Auditing trade data for key duplicates","prompt":"I have 150 rows of regional trade observations and I want to know if any row_ids or region-date combinations are duplicated — can you run a duplicate key report on them?"},{"title":"Rolling average for export trend analysis","prompt":"Can you compute a trailing mean series with a window of 5 for the export_amount field across my trade records? I have about 80 rows covering different regions and dates."},{"title":"Data quality check before economics pipeline","prompt":"Before I load these trade observation records into our pipeline, run both a duplicate key check and a 4-period trailing mean on import_amount so I can spot any data issues upfront."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying any rows with repeated keys among the supplied trade observations, and (2) a trailing mean series for the selected numeric field (export_amount or import_amount) computed over the specified window size, all processed locally without external lookups.","failureModes":["Missing required fields (row_id, region, date, export_amount, import_amount) causes validation error","Fewer than 1 row or more than 200 rows triggers schema violation","Window size less than 2 or greater than 200 is rejected","Invalid date format (not YYYY-MM-DD) causes parsing error","Non-numeric values in export_amount or import_amount where number is expected","Payment not included or insufficient USDC causes x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and a trailing moving average computed together on the same batch of trade observation records (up to 200 rows) in a single call, without needing external data sources, live prices, or predictive modeling. It is ideal for local analytical pipelines where data quality and trend smoothing are needed simultaneously at low cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T12:53:35.752Z","isFirstParty":false,"canonicalSlug":"trade-observations-duplicate-key-report-trailing-mean-series-add5bf92"}