core.metric_daily
Derived from the tables above via the registry in app/core/metrics.py. Export is decided per METRIC here, not per source - see core.metric_registry.
metric_daily718,603 rowsrestricted — hover for the licenceas_of_date leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.
| metric_idtext | entity_idtext | as_of_date ↑date | valuenumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_at |
|---|
| px_vs_200dma | QQQ | 2016-09-01 | 0.0748917100 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-02 | 0.0780633964 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-06 | 0.0845232889 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-07 | 0.0849083095 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-08 | 0.0783746099 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-09 | 0.0511842442 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-12 | 0.0698801750 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-13 | 0.0602117393 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-14 | 0.0651463055 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-15 | 0.0814683442 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-16 | 0.0807812581 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-19 | 0.0759032895 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-20 | 0.0776452310 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-21 | 0.0880225613 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-22 | 0.0963889246 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-23 | 0.0891427282 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-26 | 0.0797470477 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-27 | 0.0901022442 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-28 | 0.0914831826 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-29 | 0.0832041911 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-09-30 | 0.0909093488 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-03 | 0.0890552136 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-04 | 0.0870372759 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-05 | 0.0904012297 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-06 | 0.0894215806 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-07 | 0.0866573415 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-10 | 0.0931596255 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-11 | 0.0772834275 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-12 | 0.0760806929 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-13 | 0.0720536263 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-14 | 0.0731011395 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-17 | 0.0698822841 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-18 | 0.0789502168 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-19 | 0.0783935062 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-20 | 0.0766038280 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-21 | 0.0799304463 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-24 | 0.0920911434 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-25 | 0.0878402847 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-26 | 0.0797727220 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-27 | 0.0740261184 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-28 | 0.0666073105 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-10-31 | 0.0647826759 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-11-01 | 0.0560108557 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-11-02 | 0.0468268795 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-11-03 | 0.0358969773 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-11-04 | 0.0317615892 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-11-07 | 0.0555571557 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-11-08 | 0.0617395656 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-11-09 | 0.0657713199 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | QQQ | 2016-11-10 | 0.0478677957 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |