{% include 'navigation.html' %}

πŸ”§ Stock Maintenance

Enter a symbol to view and manage its data. Use the tools below for database-wide operations.

πŸ“Š Stock Information

Loading stock information...

πŸ“… Date Range Management

Trim records outside a specific date range. This permanently removes data from the database.

Records before this date will be deleted
Records after this date will be deleted

πŸ”¬ Data Quality Analysis

Checks total records, duplicate dates, missing trading days (against the US market calendar including one-off NYSE closures), and invalid prices β€” all in one pass.

πŸ“€ Export Data

Export this symbol's data to CSV file.

βž• Add New Symbols

Add symbols as placeholders. They will be populated with data automatically when they appear in the next Stooq bulk import during Daily Tasks.

πŸ”¬ Symbol Debug Dump

Export a full snapshot of all database records for this symbol across every table. Use for anomaly investigation β€” scores that seem wrong, missing data, or unexpected pipeline output.

πŸ” Metric Gap Auditor

Surgical repair tool. Scans for specific price dates that are missing TTM Squeeze or Markov rows and fills only those missing rows. Use when the Setup page shows Markov history gaps. Does not touch rhythmic_metrics or setup grades β€” those are maintained by the daily pipeline.


πŸ“Š Which dates are gapped?

Read-only diagnostic. Scans the last 730 days and shows each specific date where some symbols have price data but are missing a TTM Squeeze or Markov row. Each date is annotated with whether the daily pipeline actually recorded a TTM sub-phase in the window that should have covered it β€” converting "which dates are gapped" into "why those dates are gapped" without touching any data.

⚠️ Danger Zone

πŸ—‘οΈ Delete All Data

Permanently delete all price data for this symbol. The symbol metadata remains.

πŸ’₯ Delete Symbol Completely

Permanently delete this symbol from the database including all metadata. This cannot be undone.

πŸ—ƒοΈ Symbol Database Browser

Full-universe symbol table. Click any symbol to load it in the tools above.

Loading symbol table…

Check date: β€”