requirements.txt

# Requiered Python 3.12

# FastAPI Server Requirements

# Core frameworks
fastapi>=0.104.0
uvicorn[standard]>=0.24.0


# Database
sqlalchemy[asyncio]>=2.0.0
aiomysql>=0.2.0
pymysql>=1.1.0

# Data processing
pandas>=2.0.0
aiohttp>=3.9.0
lxml>=4.9.0  # Required for pandas.read_html()
html5lib>=1.1  # Alternative parser for pandas.read_html()
yfinance>=0.2.0  # Yahoo Finance data

# Configuration and environment
pydantic>=2.5.0
python-dotenv>=1.0.0
PyYAML>=6.0

# Logging and utilities
pytz>=2023.3

# Optional: For development
pytest>=7.4.0
pytest-asyncio>=0.21.0
httpx>=0.25.0  # For testing FastAPI