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 |
|---|
| rr_10d | SMH | 2026-07-30 | 0.0222462904 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-07-31 | 0.1039058712 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-03 | 0.1335522310 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-04 | 0.0878735374 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-05 | 0.0754701201 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-06 | 0.0704666184 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-07 | 0.0841813542 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-10 | 0.0336505929 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-11 | 0.0692246814 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-12 | 0.0436666604 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-13 | 0.0351494435 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-14 | 0.0624643426 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-17 | 0.0595168550 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-18 | 0.0754195662 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-19 | 0.0702039760 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-20 | 0.0691516890 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-21 | 0.0654501698 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-24 | 0.0563461955 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-25 | 0.0653146779 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-26 | 0.0472783926 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-27 | 0.0722355712 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-28 | 0.0413168671 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-08-31 | 0.0558304631 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-09-01 | 0.0685855826 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-09-02 | 0.0575212599 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-09-03 | 0.0485687325 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-09-04 | 0.0133244334 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_10d | SMH | 2026-09-08 | 0.0467038947 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | SMH | 2026-09-09 | 0.0698366617 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | SMH | 2026-09-10 | 0.0756009547 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| rr_10d | SMH | 2026-09-11 | 0.0339059121 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| rr_10d | SMH | 2026-09-14 | 0.0320687426 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| rr_10d | SMH | 2026-09-15 | 0.0604707790 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | SMH | 2026-09-16 | 0.1087491387 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | SMH | 2026-09-17 | 0.0350677575 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | SMH | 2026-09-18 | 0.0353839227 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | SMH | 2026-09-21 | 0.0258823683 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | SMH | 2026-09-22 | 0.0122603458 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | SMH | 2026-09-23 | 0.0459982857 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| rr_10d | SMH | 2026-09-24 | 0.0293566692 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |