- Home
- Skills
- Trading & Investing
- market data quality inspector
market data quality inspector
Automated market data validation for missing bars, stale quotes, outliers, and calendar inconsistencies.
$5
Works with the AI Agents you already use
market data quality inspector
Example session with this skill installed
Inspect my historical 1m AAPL data in data/aapl_1m.csv. It is from Nasdaq. Check for missing bars and price outliers from 2024-01-01 to 2024-01-10.
- Read your context and instructions
- Compiled the market data quality
Checked 3,900 bars.
Status: Warning
Issues
- Error: Missing 1m bars from 2024-01-02 14:30:00 to 14:35:00.
- Warning: Price spike detected at 2024-01-05 10:15:00 (High: 195.50 vs Rolling Median: 182.10).
- Info: 1 duplicate timestamp found and ignored.
Connects securely to your tools. The creator never sees your data.
About this skill
The problem
Bad market data ruins backtests and triggers erroneous trades. Manually hunting for missing bars, stale quotes, or unadjusted price gaps in large datasets is tedious and error-prone.
What it does
- Identifies missing intraday or daily bars by comparing data against official exchange trading calendars.
- Detects stale quotes and frozen prices where volume is zero or price remains static across multiple bars.
- Validates OHLC relationships, ensuring highs are greater than lows and prices are non-negative.
- Flags potential corporate action inconsistencies like unadjusted splits or dividend gaps.
- Cross-references multiple data feeds to find conflicting price levels or trade timestamps.
Frameworks & tools
Compatible with CSV, Parquet, and JSON formats. Handles Pandas DataFrames and structured market data feeds for XNAS, XNYS, and other major exchanges.
Why this beats prompting it yourself
General LLMs often overlook exchange-specific nuances like early closes, holiday calendars, and timezone-aware timestamp shifts. This skill uses a structured inspection framework to ensure mathematical consistency and calendar alignment that simple prompting misses.
Use cases
- Sanitizing historical OHLCV data before running a backtest.
- Verifying live feed integrity before an automated strategy goes live.
- Auditing data vendor quality by comparing overlapping feeds for inconsistencies.
- Detecting symbol mismatches and casing errors across heterogeneous data sources.
Known limitations
Identifies issues but does not automatically repair data unless requested. Statistical outlier detection may flag genuine high-volatility events as warnings.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Trading & Investing.
Does not repair data by default. Without a corporate actions calendar, split/dividend checks are heuristic. May flag high volatility as an outlier.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 3 months ago
Permissions
No special permissions declared or detected