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_daily698,194 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 |
|---|
| close_adj | META | 2016-09-01 | 125.0716797506 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-02 | 125.4087200226 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-06 | 128.6006896572 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-07 | 129.9091989484 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-08 | 129.1359889127 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-09 | 125.9935840240 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-12 | 127.5697429429 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-13 | 126.1026264649 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-14 | 126.6577516187 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-15 | 127.2327026709 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-16 | 127.9464350116 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-19 | 127.5300911462 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-20 | 127.5201781970 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-21 | 128.8088615899 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-22 | 128.9476428783 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-23 | 126.8460976531 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-26 | 126.2017559566 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-27 | 127.5697429429 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-28 | 128.1050421984 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-29 | 126.9749659924 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-09-30 | 127.1533990775 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-03 | 127.6490465363 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-04 | 127.0740954841 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-05 | 127.3516580610 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-06 | 127.6193076888 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-07 | 127.8671314182 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-10 | 129.1062500651 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-11 | 127.7580889772 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-12 | 127.9266091132 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-13 | 126.7073163646 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-14 | 126.7667940597 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-17 | 126.4297537877 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-18 | 127.4507875528 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-19 | 128.9773817259 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-20 | 128.8683392849 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-21 | 130.9203197643 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-24 | 132.1197866146 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-25 | 131.1384046462 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-26 | 129.8992859992 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-27 | 128.5610378605 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-28 | 130.1471097286 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-10-31 | 129.8497212533 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-11-01 | 128.3726918261 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-11-02 | 126.0629746682 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-11-03 | 118.9553901092 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-11-04 | 119.6988612973 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-11-07 | 121.0866741820 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-11-08 | 123.1386546613 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-11-09 | 122.1077079471 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | META | 2016-11-10 | 119.7484260432 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |