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_daily699,474 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_attimestamp with time zone |
|---|
| close_adj | XLU | 2016-09-01 | 17.8467154400 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-02 | 18.0835542525 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-06 | 18.2803126506 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-07 | 18.2839563246 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-08 | 18.3458987833 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-09 | 17.6572443900 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-12 | 17.9706003573 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-13 | 17.7228305227 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-14 | 17.7920603294 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-15 | 17.9268762689 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-16 | 18.1018382897 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-19 | 18.2819012365 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-20 | 18.2488284504 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-21 | 18.6199786061 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-22 | 18.7338959807 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-23 | 18.7191969646 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-26 | 18.6714251624 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-27 | 18.4288913972 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-28 | 18.4031681191 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-29 | 18.1275615678 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-09-30 | 18.0026199312 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-03 | 17.7490619040 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-04 | 17.3779117482 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-05 | 17.3411642081 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-06 | 17.3374894540 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-07 | 17.3154409299 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-10 | 17.4587563366 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-11 | 17.2603196197 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-12 | 17.4293583045 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-13 | 17.6461687915 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-14 | 17.5469504330 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-17 | 17.6424940375 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-18 | 17.7931589522 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-19 | 17.7527366580 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-20 | 17.7417123960 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-21 | 17.6388192835 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-24 | 17.7049648558 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-25 | 17.8152074763 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-26 | 17.8593045245 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-27 | 17.7527366580 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-28 | 17.8078579683 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-10-31 | 18.1643091080 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-11-01 | 17.8335812464 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-11-02 | 17.6094212513 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-11-03 | 17.6755668236 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-11-04 | 17.6204455134 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-11-07 | 17.9291248508 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-11-08 | 18.0687655035 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-11-09 | 17.4036350264 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLU | 2016-11-10 | 16.9847130684 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |