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 | AVGO | 2016-09-01 | 0.0037977554 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-02 | -0.0224744480 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-06 | -0.0116111143 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-07 | -0.0128579778 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-08 | -0.0030787448 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-09 | -0.0451360019 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-12 | 0.0230128125 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-13 | 0.0046206226 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-14 | 0.0264463810 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-15 | 0.0214074512 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-16 | -0.0085687818 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-19 | -0.0029782761 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-20 | -0.0146430036 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-21 | 0.0095107888 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-22 | -0.0058293588 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-23 | -0.0129708600 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-26 | 0.0002400240 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-27 | 0.0250164977 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-28 | -0.0009364392 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-29 | 0.0103104862 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-09-30 | 0.0003479068 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-03 | -0.0142012520 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-04 | -0.0059975304 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-05 | 0.0262052647 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-06 | 0.0040926908 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-07 | 0.0001148172 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-10 | 0.0032145112 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-11 | -0.0205985009 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-12 | -0.0040895017 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-13 | -0.0089751862 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-14 | 0.0068071505 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-17 | -0.0071138809 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-18 | 0.0194812885 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-19 | -0.0017424638 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-20 | 0.0089602607 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-21 | -0.0028256733 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-24 | 0.0209923664 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-25 | -0.0164259417 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-26 | -0.0037431615 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-27 | -0.0043930636 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-28 | -0.0167789131 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-10-31 | 0.0054915855 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-11-01 | -0.0086915668 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-11-02 | 0.0222748815 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-11-03 | 0.0024918869 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-11-04 | -0.0047401584 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-11-07 | 0.0278213394 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-11-08 | 0.0002260398 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-11-09 | -0.0202259887 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AVGO | 2016-11-10 | -0.0315995848 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |