Zetian Tao

Portfolio

Projects built and run by Zetian Tao.

Career Platform (in progress)

This website, and a project in progress. A FastAPI and Jinja resume and portfolio site, built in GitHub Codespaces, run on an Azure Ubuntu VM with SQLite, and now on Railway with PostgreSQL. Pages read from the database on every request, with a cached profile if the database is down. It will grow into a career platform through the semester.

  • Python
  • FastAPI
  • Jinja
  • PostgreSQL
  • Railway
  • Cloudflare
  • GitHub
  • uv
Project details Source code
Visitor · HTTPS nginx → FastAPI SQLite Snapshot Azure Ubuntu VM

SEC EDGAR Data Pipeline & Earnings Analytics

A 7-script Python pipeline that pulls XBRL financials, 8-K earnings dates, and daily prices for 18 software companies plus the S&P 500 (SPY) from the SEC EDGAR API and Yahoo Finance into an indexed SQLite schema.

  • Python
  • SQL
  • SQLite
  • REST API
  • SEC EDGAR
  • Yahoo Finance
Project details