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.
Simplify Analyticsmetric_daily701,610 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 | AVGO | 2016-09-01 | 0.1997879713 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-02 | 0.1707528677 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-06 | 0.1553473448 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-07 | 0.1387664799 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-08 | 0.1336104021 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-09 | 0.0810772534 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-12 | 0.1045685998 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-13 | 0.1082557892 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-14 | 0.1360106984 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-15 | 0.1586214481 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-16 | 0.1471541840 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-19 | 0.1422008731 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-20 | 0.1245256453 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-21 | 0.1343067622 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-22 | 0.1268716476 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-23 | 0.1114869154 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-26 | 0.1109069850 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-27 | 0.1377362893 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-28 | 0.1356091748 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-29 | 0.1461083439 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-09-30 | 0.1453259485 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-03 | 0.1280294704 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-04 | 0.1201535775 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-05 | 0.1481912574 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-06 | 0.1517560043 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-07 | 0.1507287875 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-10 | 0.1532988107 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-11 | 0.1285659131 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-12 | 0.1230066363 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-13 | 0.1121071259 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-14 | 0.1187896291 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-17 | 0.1099145519 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-18 | 0.1303770449 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-19 | 0.1270885344 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-20 | 0.1356468390 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-21 | 0.1307684963 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-24 | 0.1526383127 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-25 | 0.1319752047 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-26 | 0.1261118981 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-27 | 0.1193399353 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-28 | 0.0989396184 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-10-31 | 0.1031333815 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-11-01 | 0.0917820911 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-11-02 | 0.1143033262 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-11-03 | 0.1152927505 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-11-04 | 0.1082614892 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-11-07 | 0.1371315454 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-11-08 | 0.1354265690 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-11-09 | 0.1106011813 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | AVGO | 2016-11-10 | 0.0740360515 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |