Architecture
Architecture This page documents the current architecture of the platform. I update it as the system evolves. Last updated: April 2026 Stack Overview Layer Technology Notes Data Sources yFinance, FRED API Equity prices + macro indicators Storage PostgreSQL Single database, multiple schemas Transformation dbt Staging → intermediate → mart pattern Orchestration Dagster Scheduled jobs + event sensors Auth / API FastAPI JWT-based auth, user management Frontend Streamlit Transaction input + personal dashboards Deployment Docker Compose-based, self-hosted Data Sources yFinance Yahoo Finance is the primary source for daily equity prices. When a user logs a transaction for a ticker the system hasn’t seen before, it backfills the full available price history for that ticker into bronze.raw_prices before writing the transaction. This ensures the daily holdings computation has complete data. ...