← Selected work

Data / dashboard

Market Atlas

Ten years of market data, current every morning, and a question box that can't be talked into a bad query.

A market-intelligence dashboard over the S&P 500, NASDAQ-100 and Dow 30, with a ten-year backfill kept current by incremental daily updates into TimescaleDB. Sector heatmaps, candlesticks with indicators and per-symbol news sentiment sit on top. The Claude-powered query flow answers plain-English questions only through approved SQL templates, with a validated read-only fallback and every query logged.

Role: Data pipeline, schema and hypertables, Streamlit UI, Claude query flow, daily refresh on GitHub Actions

  • Python
  • PostgreSQL
  • TimescaleDB
  • Streamlit
  • Plotly
  • Claude API
  • GitHub Actions