← Results index

Create sqlite data-sources DB for historic prices/macros; reads must not dirty the DB file

2026-07-23T21:34:42Z Data pipeline done Sqlite data/market
t99

Source report: research/findings/sqlite-datastore-t99.md

Objective

Create sqlite data-sources DB for historic prices/macros; reads must not dirty the DB file.

Notes: Sqlite data/market.sqlite + CLI; RO mode=ro/query_only; wired download_ticker + download_fred_series; tests/test_datastore.py 8 passed. Findings: sqlite-datastore-t99.md

Approach

Reuses existing report research/findings/sqlite-datastore-t99.md — tables/metrics preserved verbatim via source_report pointer. Body below summarizes grounded evidence from that report and adjacent artifacts.

Files / code / data changed

Associated commits (inferred from log grep t99):

Results

Key table from source report (preserved):

PiecePath
Module + CLIbacktest/datastore.py (python3 -m backtest.datastore)
Price wire-throughbacktest/data.py → download_ticker / download_history
Macro wire-throughbacktest/macro.py → download_fred_series
Teststests/test_datastore.py (8 cases; RO dirty-check)

Conclusions and metrics are in research/findings/sqlite-datastore-t99.md; see detail page for preserved tables/metrics.

Conclusions

[reconstructed — uncertain] Outcome inferred from status done and task note.

Problems / follow-ups

Links

Source artifact: research/results/t99.md