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_attimestamp with time zone |
|---|
| ret_1d | XLI | 2016-09-01 | 0.0008533880 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-02 | 0.0049454297 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-06 | -0.0028847786 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-07 | 0.0011912866 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-08 | -0.0008499065 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-09 | -0.0282408983 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-12 | 0.0127801120 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-13 | -0.0146931720 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-14 | -0.0008771930 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-15 | 0.0079016681 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-16 | -0.0083811846 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-19 | 0.0044161809 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-20 | 0.0008793528 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-21 | 0.0130029872 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-22 | 0.0071118820 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-23 | -0.0058560110 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-26 | -0.0043312543 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-27 | 0.0069601531 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-28 | 0.0077760498 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-29 | -0.0078875171 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-09-30 | 0.0089872105 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-03 | 0.0008564577 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-04 | -0.0083861030 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-05 | 0.0063859165 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-06 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-07 | -0.0128622878 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-10 | 0.0010423905 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-11 | -0.0104130510 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-12 | 0.0019291477 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-13 | -0.0003500788 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-14 | 0.0021012082 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-17 | -0.0026210030 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-18 | 0.0021023125 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-19 | 0.0031468531 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-20 | -0.0054025793 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-21 | -0.0014017873 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-24 | 0.0019301632 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-25 | -0.0026269702 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-26 | 0.0035118525 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-27 | -0.0068241470 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-28 | 0.0059901339 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-10-31 | 0.0019264448 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-11-01 | -0.0085649362 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-11-02 | -0.0037023977 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-11-03 | -0.0015926385 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-11-04 | 0.0008862106 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-11-07 | 0.0246148397 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-11-08 | 0.0060490840 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-11-09 | 0.0250816011 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLI | 2016-11-10 | 0.0212837272 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |