I built an open-source financial research terminal (SEC data and SQL)

I posted this a few weeks ago and the server died under the traffic. Fixed that by adding an in-mem caching layer with Redis/valkey and added CloudFront caching for static content. Also upgraded the server.

Also fixed the Firefox bugs, trying again.

It's a research tool for US stocks. Financials for ~10k companies pulled from SEC filings. You can chart any metric across companies, filter news by ticker, ask questions in plain English and get a chart back. There's also SQL console against the whole database, which is the part I like to use together with the AI chat (generates an SQL query).

Doesn't do international stocks or intraday data yet.

Its a python flask app + gunicorn, with duckDB for datasets.

GitHub: https://github.com/alexanderdolotov/open-terminal Self-hosted: https://terminal.tesseractanalytics.ai Docs and landing page: https://tesseractanalytics.ai