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 | CRSR | 2020-09-23 | — | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-09-24 | 0.0933333333 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-09-25 | 0.1071887035 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-09-28 | 0.0707246377 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-09-29 | 0.0167839740 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-09-30 | 0.0702875399 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-01 | 0.0422885572 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-02 | -0.0023866348 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-05 | -0.0416267943 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-06 | -0.0868696955 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-07 | 0.0448332422 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-08 | -0.0387231816 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-09 | -0.0141535112 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-12 | 0.0254003313 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-13 | -0.0005385030 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-14 | 0.0123922414 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-15 | -0.0202235232 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-16 | 0.0429114612 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-19 | 0.0447916667 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-20 | 0.1450648056 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-21 | 0.0727035263 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-22 | -0.0251623377 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-23 | 0.0270607827 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-26 | -0.0077016619 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-27 | 0.0535130719 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-28 | -0.0275300504 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-29 | -0.0111642743 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-10-30 | -0.0306451613 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-02 | -0.0445091514 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-03 | 0.0879407923 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-04 | 0.0636254502 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-05 | 0.0451467269 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-06 | -0.0251979842 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-09 | -0.0280649926 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-10 | 0.0634498480 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-11 | 0.0410861022 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-12 | -0.0271105010 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-13 | 0.0292768959 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-16 | 0.0370116518 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-17 | 0.0608063450 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-18 | 0.0931464174 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-19 | 0.0800797948 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-20 | 0.0641160950 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-23 | 0.1237292338 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-24 | 0.1310679612 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-25 | -0.1650409676 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-27 | -0.0941588785 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-11-30 | -0.0203765798 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-12-01 | 0.0592417062 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | CRSR | 2020-12-02 | -0.1399453144 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |