Back to Projects

TradingOctopus

AI-driven trading platform for collecting, analyzing, and acting on financial market data at scale. TradingOctopus implements a modular microservices architecture with a high-performance FastAPI REST API, TimescaleDB for time-series storage, and a multi-source data mining service with real-time market data collection. The platform features comprehensive domain models (instruments, listings, venues, OHLCV candles, fundamentals, corporate actions), event-driven architecture with flexible JSONB-based financial events, data provenance tracking, and a Yahoo Finance collector with multi-timeframe support. Built entirely using the AI Development Framework with 3 rounds of test quality audits ensuring production-grade reliability, demonstrating the framework's capability to deliver complex financial data infrastructure.

Active
PythonFastAPITimescaleDBDockerTrading
Project Timeline

Start Date

October 5, 2025

End Date

Ongoing

Duration

4+ months

Key Metrics

Tickets Created

93

Tickets Completed

70

AI Sessions

41

Development Journey
Technical Stack
Python 3.11+FastAPISQLAlchemy 2.0 (async)PostgreSQL + TimescaleDBPydanticAlembicDocker & Docker ComposeAPSchedulerhttpxpytestNext.jsTailwind CSSCaddyPrometheusGrafana
Achievements
  • ✅ High-performance async REST API with FastAPI
  • ✅ TimescaleDB hypertables for OHLCV time-series data
  • ✅ Comprehensive domain models (instruments, listings, venues, candles, fundamentals)
  • ✅ Event-driven architecture with flexible JSONB financial events
  • ✅ Bitemporal fundamental data schema with point-in-time queries
  • ✅ SEC EDGAR integration for financial statements
  • ✅ Corporate actions and adjustment factor calculations
  • ✅ Data provenance tracking and audit trails
  • ✅ Yahoo Finance multi-timeframe collector (1m + 1d candles)
  • ✅ Multi-source data mining service with rate limiting and retry logic
  • ✅ Seed configuration with canonical asset identifiers
  • ✅ End-to-end mining pipeline (discovery → collection → ingestion)
  • ✅ 3 rounds of test quality audits with comprehensive coverage
  • ✅ Docker-based dev and production environments
  • ✅ Automated database migrations with Alembic
  • ✅ Health-check endpoints with Prometheus metrics
  • ✅ API-key authentication for production security
  • ✅ Caddy reverse proxy with public HTTPS access
  • ✅ Finnhub client & OHLCV market data collector
  • ✅ Finnhub fundamentals collector (financial statements)
  • ✅ Multi-datasource seed configuration support
  • ✅ Next.js landing page for tradingoctopus.com
  • ✅ German legal compliance (Impressum, Datenschutz, Risikohinweis)
  • ✅ Interactive Brokers API feasibility research
  • ✅ Validated AI Development Framework for financial data systems
Repository Information

This project follows a multi-repository architecture with specialized repositories for different concerns.

Meta Repository

Private Repository

Private

Data API

Private Repository

Private

Miner

Private Repository

Private

Frontend

Private Repository

Private

Infrastructure

Private Repository

Private

AI Conversations

Private Repository

Private