{"uid":"cap_q38EG7S3TdGHgTAVCk1xO","slug":"exchange-quote-observations-exact-row-deduplication-explicit-missing-3e7eac78","name":"Exchange Quote Observations — Exact Row Deduplication + Explicit Missing-Value Fill","description":"Exchange quote observations — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied exchange quote observations records (bid_price, ask_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-04-054?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","bid_price","ask_price"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"ask_price":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"bid_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","ask_price":1,"bid_price":10,"instrument_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","ask_price":2,"bid_price":20,"instrument_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","ask_price":3,"bid_price":15,"instrument_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","ask_price":4,"bid_price":30,"instrument_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["bid_price","ask_price"],"type":"string","default":"bid_price"},"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_FFvj4MmXBE1Pu3FrgThin","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":"Deduplicates exchange quote observation rows and fills missing bid_price or ask_price values using zero, mean, or median imputation, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have up to 200 exchange quote rows with bid_price and ask_price fields — some rows are duplicates and some have null ask_price values. Can you deduplicate the dataset exactly and fill in the missing ask_price values using the median method?","exampleUseCases":[{"title":"Clean duplicate intraday quote feed","prompt":"I've got a batch of intraday exchange quote observations for multiple instrument groups and some rows got duplicated in the feed. Can you run exact deduplication on these records and fill any missing bid_price values using the mean, then give me both reports?"},{"title":"Impute missing ask prices before backtesting","prompt":"Before I run my backtesting pipeline, I need to clean up these quote observation rows — remove exact duplicates and fill in the null ask_price values using median imputation. Can you process up to 150 rows for me?"},{"title":"Audit quote data quality for compliance","prompt":"I need to audit these exchange quote records for data quality — specifically identify exact duplicate rows and flag or fill any missing bid_price fields using zero-fill so nothing is left as null. Can you generate both the deduplication and missing-value fill reports?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate exchange quote observations, and (2) an explicit missing-value fill report showing which bid_price or ask_price values were null and what values were imputed using the chosen method (zero, mean, or median). Covers up to 200 input rows per call.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, instrument_group, date, bid_price, ask_price) in one or more rows — validation error","Invalid date format not matching YYYY-MM-DD pattern — schema validation failure","Price value outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — rejected","Invalid method enum value (not zero, mean, or median) — schema error","Invalid field enum value (not bid_price or ask_price) — schema error","Empty rows array (minItems: 1 not met) — validation error"],"whenToPreferThis":"Choose this endpoint when you have exchange quote observation data (bid/ask prices per instrument group and date) that needs both exact duplicate removal and systematic missing-value imputation in a single call. Prefer it over generic data-cleaning tools when your data is structured as financial quote records with bid_price and ask_price fields, you need up to 200 rows processed at low cost ($0.01 USDC), and you want two focused reports — deduplication and fill — without any live market lookup or prediction.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:34:20.167Z","isFirstParty":false,"canonicalSlug":"exchange-quote-observations-exact-row-deduplication-explicit-missing-3e7eac78"}