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_at |
|---|
| realized_vol_21d | XLP | 2016-09-01 | 0.0520613568 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-02 | 0.0581265574 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-06 | 0.0583093927 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-07 | 0.0660914025 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-08 | 0.0676151772 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-09 | 0.1129447813 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-12 | 0.1338165010 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-13 | 0.1382047890 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-14 | 0.1382474520 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-15 | 0.1420625998 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-16 | 0.1414751242 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-19 | 0.1403242282 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-20 | 0.1411290294 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-21 | 0.1428830538 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-22 | 0.1471233897 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-23 | 0.1476519224 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-26 | 0.1496325926 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-27 | 0.1499944394 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-28 | 0.1483564349 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-29 | 0.1506002488 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-09-30 | 0.1553536729 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-03 | 0.1565301026 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-04 | 0.1552070152 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-05 | 0.1545771996 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-06 | 0.1530790045 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-07 | 0.1524410157 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-10 | 0.1200070304 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-11 | 0.0997078302 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-12 | 0.0935530077 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-13 | 0.0930351882 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-14 | 0.0880677088 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-17 | 0.0888197057 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-18 | 0.0895213348 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-19 | 0.0906868872 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-20 | 0.0878186041 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-21 | 0.0836290849 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-24 | 0.0868051973 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-25 | 0.0831966753 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-26 | 0.0818132547 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-27 | 0.0826902175 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-28 | 0.0772776958 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-10-31 | 0.0688410333 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-11-01 | 0.0669302673 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-11-02 | 0.0605142212 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-11-03 | 0.0650160941 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-11-04 | 0.0711684780 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-11-07 | 0.0933238207 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-11-08 | 0.0943614588 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-11-09 | 0.1046549115 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLP | 2016-11-10 | 0.1374863967 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |