THE QUIET TERMINAL
The whole US tape,
kept like an archive.
Eleven thousand tradable US equities, six years of consolidated daily bars behind them, and a small stack of indicators and analyst snapshots on top. Built to be queried, not scrolled.
LATEST SESSION
The tape, after the close
Single-session moves among symbols trading at least $1M a day. Auction prices, consolidated volume.
| Symbol | Close | Chg |
|---|---|---|
| Reading the tape… | ||
| Symbol | Close | Chg |
|---|---|---|
| Reading the tape… | ||
| Symbol | Close | $ Vol |
|---|---|---|
| Reading the tape… | ||
DUCKDB / READ-ONLY
Three small lenses
Every result is filtered for a $1M average dollar volume and twenty recent sessions. Click any row to inspect the symbol.
Oversold
RSI(14) below 30, with volume above its 20-day average.
— MATCHES
| Running DuckDB… |
SYMBOL EXPLORER
One name, end to end
THE PIPELINE
From an API call to a quiet archive
A resumable Python pipeline. Each stage leaves files on disk, so the whole thing can be stopped, inspected, and resumed without losing work.
- 01
Universe
Alpaca's active, tradable US equities, saved as a dated snapshot.
- 02
Daily bars
Adjusted, consolidated SIP bars. One Parquet file per symbol, resumed by append.
- 03
Indicators
Incremental SMA, EMA, RSI, MACD, ATR and Bollinger bands, state carried forward exactly.
- 04
Minute watchlist
A fifty-symbol tape for intraday work, partitioned by year.
- 05
Analysts
Monthly Finnhub recommendation snapshots, upserted into one small table.
- 06
Query & look
DuckDB over the Parquet files: screeners, breadth, and this page.
DATA HEALTH
What is actually in there
Downloaded coverage, known caveats, and the last materialized dashboard cache.
COVERAGE
- Daily range
- —
- Latest session
- —
- Daily failures
- —
- Bad-price symbols
- —
- Dashboard cache
- —
KNOWN CAVEATS
- Loading the quality register…
PROVENANCE
Daily bars come from Alpaca's consolidated SIP feed, delayed fifteen minutes on the free plan. Open and close are official auction prices; high and low cover the regular session; volume includes all sessions and the closing auction. Prices use split and dividend adjustment.
This is a personal research archive, not investment advice. Data is provided as-is.