stock-oracle

Commit Graph

Author	SHA1	Message	Date
I Luk Kim	f5feffb80e	fix: adjustment='all' 조정가 적용 + parquet export 엔드포인트 - alpaca.py backfill: on_conflict_do_nothing → on_conflict_do_update 기존 미조정 행(split 전 $1,208)을 조정가($120)로 덮어씀 NVDA 2024-06-07 ~$120 통과 기준 - finra.py: POST /admin/export-pit-panel (Background) + GET /download pit_universe_membership × alpaca_price_data 조인 → /app/data/pit_panel.parquet - requirements-api.txt: pyarrow>=14.0.0 추가 Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>	2 months ago
I Luk Kim	1d087b54a4	feat: day_gainers 5분봉 수집 + News v2 ingest + overlay 정리 주요 변경사항: gainer snapshot (신규) - gainer_snapshots 테이블: 5분 단위 intraday top-100 day_gainers 스냅샷 - APScheduler CronTrigger (*/5 min, Mon-Fri ET) + 장중 guard (9:30~16:00) - alembic migration p7g8h9i0j1k2 /stocks/gainers 엔드포인트 (신규) - yfinance day_gainers preset, 실시간(캐시 없음) - yfinance_plus screen() wrapper — 모든 screen() 호출에 세션 풀 + 브라우저 지문 우회 적용 News v2 ingest (신규) - Alpaca News + StockTwits + Finnhub 수집 파이프라인 - news_headlines 테이블 + scheduler (5분 realtime poll, 일 1회 backfill) Overlay 정리 - 미사용 서브시스템 제거: wikimedia, youtube, google_trends, feature_builder, overlay_scorer - Yahoo RSS 어댑터 유지, 파이프라인 단순화 Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	3 months ago
I Luk Kim	d82ba624e2	chore: remove SQLite entirely, PostgreSQL only SQLite was never used in production (Docker Compose always sets DATABASE_URL to postgresql+asyncpg://...) but the fallback kept creating confusing stock_oracle.db files locally. - config.py: default DATABASE_URL fallback → PostgreSQL (localhost:15433) - database.py: remove _is_sqlite conditional branch and NullPool import - error_logs.py: replace strftime/dialect-check with pg to_char() - request_logs.py: replace strftime with pg to_char() - feature_builder.py: remove _ensure_utc() helper and all call sites - overlay_pipeline.py: remove naive-datetime workaround for is_stale() - requirements-api.txt / requirements-test.txt: drop aiosqlite - stock_oracle.db: deleted Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	5 months ago
I Luk Kim	29fc870b37	Add Phase 5 Attention Overlay API and fix Redis port mismatch - 12 REST endpoints: overlay score, bulk, top-movers, headlines, youtube, wiki, crowding, trends, history, admin (health/trigger/job-log) - 10 services: entity_resolver, yahoo_rss_adapter, wikimedia_adapter, youtube_adapter, google_trends_adapter, finra_overlay_loader, feature_builder, overlay_scorer, overlay_pipeline, scheduler - 10 DB tables across overlay_registry, overlay_raw_event, overlay_feature models - APScheduler: collect @ 23:30 UTC + feature build @ 01:30 UTC weekdays - Fix Redis port mismatch: config default 16379 → 16380 to match docker-compose external port - 64 overlay tests covering cache utils, Redis config, all 12 endpoints, route ordering Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	5 months ago
I Luk Kim	355aeb19d3	Initial commit with full project improvements Security: config-based CORS, default secret warnings, sort_by validation Error handling: debug logging in cache silent failures Architecture: shared resolve_time_parameters, deduplicated logger init, unified route structure Database: conditional SQLite/PostgreSQL engine, in-memory test DB, dialect-aware date formatting, optimized stats query Docker: .dockerignore, pinned yfinance_plus commit Dependencies: removed duplicates, added version upper bounds, removed unused axios Frontend: custom _document/_error pages, adminApi client, Layout standardization, ESLint version update Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>	5 months ago

5 Commits (main)