VOL. I — NO. 001 NEW YORK · US EQUITIES —
Analytico

A personal market-data platform.
Daily bars, indicators, screeners, analyst snapshots.

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.

How it is built
01 — UNIVERSE / TRADABLE NYSE · NASDAQ · AMEX · ARCA
02 — DAILY BARS —
03 — FEATURE ROWS SMA · EMA · RSI · MACD · ATR · BBANDS
04 — ON DISK PARQUET, PARTITIONED BY SYMBOL

LATEST SESSION

The tape, after the close

Single-session moves among symbols trading at least $1M a day. Auction prices, consolidated volume.

GAINERS
SymbolCloseChg
Reading the tape…
DECLINERS
SymbolCloseChg
Reading the tape…
MOST ACTIVE
SymbolClose$ 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

AAPL Apple Inc. NASDAQ
— — —
SMA 50SMA 200Volume
— —

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.

  1. 01

    Universe

    Alpaca's active, tradable US equities, saved as a dated snapshot.

    —
  2. 02

    Daily bars

    Adjusted, consolidated SIP bars. One Parquet file per symbol, resumed by append.

    —
  3. 03

    Indicators

    Incremental SMA, EMA, RSI, MACD, ATR and Bollinger bands, state carried forward exactly.

    —
  4. 04

    Minute watchlist

    A fifty-symbol tape for intraday work, partitioned by year.

    —
  5. 05

    Analysts

    Monthly Finnhub recommendation snapshots, upserted into one small table.

    —
  6. 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.