A 2021–22 retail-hype tracker, archived

1. 1
   quote.py

   TD Ameritrade API (tda-api) quotes for a watchlist plus StockTwits stream timing → quote
2. 2
   tweets.py

   tweepy search: time span of the latest tweets per ticker → twitter
3. 3
   reddits.py

   praw: ticker mentions per subreddit per day → reddit
4. 4
   options.py

   TDA option chains: open interest, volume, max pain → options
5. 5
   Flask + Socket.IO

   Original live dashboard reading Postgres and pushing updates every 10s

Scripts ran on a schedule via Windows batch jobs and wrote to PostgreSQL through SQLAlchemy.

The original dashboard pushed a fresh table to the browser every 10 seconds over Socket.IO. /live recreates that: the server replays the archive one hourly sample at a time, running a SQLite port of the original raw_query() (latest vs. previous quote per ticker, ordered by volume ratio) with the replay clock standing in for now(). Each frame is streamed every 10 seconds over Server-Sent Events, and the page falls back to polling if streaming isn't available.

• Play, pause, step forward and pick any archived day; the “Replaying” indicator shows the clock being replayed.
• The columns and colour rules come from the old template. Price change is shown with the sign corrected (a rise is positive).
• New: per-ticker 24h sparklines built from real quote rows, sortable columns, a ticker filter and a mobile layout.
• /reddit (the original home page) and /twitter are ports of the original pages, with “today” set to a chosen archive date.

• Tickers priced
  84
• Quote snapshots
  175,149
• Twitter samples
  230,531
• Reddit rows
  19,200
• Options snapshots
  12,899

The Postgres dump was converted to SQLite and down-sampled to one quote and one Twitter sample per ticker per hour. Reddit and options data are complete.