Stock Analytics

Archived Cloudflare Workers stock analytics prototype.

Current Status

This repository is retained for reference and possible future rebuild work. It is not an active production service.

• Production Worker stock-analytics was removed on 2026-06-14.
• The D1 database was deleted on 2026-06-14 and its data is not recoverable from this repo.
• wrangler.toml, deploy scripts, remote migration scripts, and Workers Cron trigger configuration were intentionally removed.
• apps/worker/src/index.ts still contains the historical scheduled() handler logic for reference and regression coverage.
• Do not recreate production deploy or remote migration configuration without an explicit resurrection plan.

Repository Layout

• apps/worker/src/: Worker HTTP routes, scheduled handler reference code, data ingestion, signal, LLM, Discord, and review logic.
• apps/worker/tests/: Vitest coverage using Cloudflare Workers test pool and test-only Miniflare bindings.
• apps/worker/wrangler.test.toml: test-only Worker config for local Vitest D1 bindings. It is not a production deploy config.
• docs/agents/: Domain and issue-tracking guidance for future agent work.
• docs/superpowers/: Historical planning and review notes.
• TECH-STACK.md: Source of truth for decommissioned infrastructure and future rebuild constraints.

Local Setup

pnpm install
pnpm run check

Useful focused commands:

pnpm -r test
pnpm --filter worker typecheck
pnpm --filter worker dev

pnpm --filter worker dev is only for local experimentation. It does not imply production deployment is configured.

Environment

The project keeps only variable names and placeholders in repo files. Raw values must stay in 1Password or the target platform secret store.

Historical secret names:

• FINMIND_TOKEN
• FINNHUB_KEY
• ALPHAVANTAGE_KEY
• ANTHROPIC_API_KEY
• INGEST_WEBHOOK_TOKEN

If the project is rebuilt, create or verify 1Password items first, then wire local env files with op:// references. Do not commit raw tokens, API keys, webhook secrets, database passwords, or private keys.

CI

The repository has a non-deploying CI gate at .github/workflows/ci.yml. It installs pnpm dependencies and runs pnpm run check.

Future Rebuild Gate

Before any production resurrection:

1. Write a short rebuild plan covering D1 schema/data source, Worker name, Cron triggers, platform secrets, and deploy rollback.
2. Recreate infrastructure in a branch, not directly on main.
3. Add or update tests before changing runtime behavior.
4. Run pnpm run check and a local Worker smoke test.
5. Store all raw secrets outside the repo.