fastapi>=0.104.0,<1.0.0
uvicorn[standard]>=0.24.0
sqlalchemy>=2.0.0,<3.0.0
alembic>=1.12.0
asyncpg>=0.29.0
greenlet>=2.0.0
pydantic>=2.0.0,<3.0.0
pydantic-settings>=2.0.0
python-multipart>=0.0.6
httpx>=0.25.0
redis>=5.0.0,<6.0.0
celery>=5.3.0
python-jose[cryptography]>=3.3.0
passlib[bcrypt]>=1.7.4
python-dotenv>=1.0.0
orjson>=3.9.0
markdown>=3.5.0

# Web scraping and HTTP requests
curl_cffi>=0.6.0
beautifulsoup4>=4.12.0

# SEC data processing - using direct API calls and EDGAR downloader
aiohttp>=3.8.0
pandas>=2.0.0,<3.0.0
pyarrow>=14.0.0  # parquet export (pit_panel)
numpy>=1.24.0,<3.0.0
python-dateutil>=2.8.0
sec-edgar-downloader>=5.0.0
lxml>=4.9.0

# Yahoo Finance price data only - using yfinance-plus installed from git
# yfinance-plus will be installed via: git+https://gitea.yirugi.synology.me/yirugi/yfinance_plus.git
# Regular yfinance is needed as dependency for yfinance-plus
yfinance>=0.2.65

# Overlay (Phase 5)
feedparser>=6.0.0          # Yahoo RSS feed parsing
apscheduler>=3.10.0        # Batch scheduling
pytrends>=4.9.0            # Google Trends (experimental, disabled by default)

# News v2 (Alpaca News + StockTwits + Finnhub)
pandas_market_calendars>=4.3.0  # NYSE holiday/short-day handling for session windows

# Development & Testing
pytest>=7.4.0
pytest-asyncio>=0.21.0
pytest-cov>=4.1.0
httpx>=0.25.0
faker>=20.0.0