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 |
|---|
| gamma_flip_level | XLI | 2026-06-17 | 175.7402773965 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-06-18 | 184.5384729180 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-06-22 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-06-23 | 195.1875666061 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-06-24 | 190.7635791064 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-06-25 | 191.7079765892 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-06-26 | 191.0305102493 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-06-29 | 191.9006895842 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-06-30 | 189.0836153324 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-01 | 184.7192964413 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-02 | 189.8227940319 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-06 | 190.7466128033 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-07 | 194.7209978715 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-08 | 191.2705700681 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-09 | 206.8823631540 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-10 | 188.5893145963 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-13 | 190.3451740027 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-14 | 186.7478220679 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-15 | 186.4590575263 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-16 | 186.7386031371 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-17 | 190.9495316520 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-20 | 193.4204941133 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-21 | 193.5313109094 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-22 | 194.2686161841 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-23 | 191.8742784704 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-24 | 197.7759463187 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-27 | 193.0395138861 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-28 | 190.5314744824 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-29 | 196.4810907504 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-30 | 187.0865645160 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-07-31 | 189.4958339459 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-03 | 188.1291747333 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-04 | 191.7865440582 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-05 | 189.1969472999 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-06 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-07 | 193.4266878538 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-10 | — | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-11 | 190.9966729117 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-12 | 187.5584188596 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-13 | 187.0335830865 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-14 | 186.8227602438 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-17 | 188.9471022444 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-18 | 185.6362264404 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-19 | 184.5810147630 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-20 | 188.8634190759 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-21 | 192.1130011219 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-24 | 191.9914968523 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-25 | 189.4826814233 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-26 | 186.1785604550 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| gamma_flip_level | XLI | 2026-08-27 | 183.7330268265 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |