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_daily717,674 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 |
|---|
| dollar_volume_21d | XLU | 2016-09-01 | 505550375.0499920000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-02 | 511653958.7020420000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-06 | 490773032.6292750000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-07 | 486978195.8707550000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-08 | 491656001.4252010000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-09 | 520032111.3470880000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-12 | 547005974.8886290000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-13 | 563159684.8362990000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-14 | 566991962.2715050000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-15 | 585179630.7598070000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-16 | 572991144.3060050000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-19 | 570182049.0013010000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-20 | 566888835.6184350000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-21 | 585381910.0978420000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-22 | 590175410.9316480000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-23 | 595783104.2995920000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-26 | 597523171.5176760000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-27 | 593343688.3277710000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-28 | 600068928.6885600000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-29 | 612437972.1107210000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-09-30 | 618225571.9200960000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-03 | 624011419.3579740000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-04 | 638509847.3056310000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-05 | 658471020.3834280000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-06 | 671809616.3455470000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-07 | 677708887.7286240000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-10 | 650644154.7887920000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-11 | 630530014.0729140000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-12 | 618503722.6950350000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-13 | 644025776.0305680000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-14 | 621140639.0947470000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-17 | 602910395.5686380000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-18 | 606107922.6568450000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-19 | 598136671.8455580000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-20 | 578815171.0499500000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-21 | 587838044.6331110000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-24 | 586338902.6934600000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-25 | 588792606.5792940000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-26 | 575703380.4985160000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-27 | 572897325.2553620000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-28 | 567590595.3424790000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-10-31 | 581448425.0315160000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-11-01 | 589522156.7143850000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-11-02 | 591430149.6305050000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-11-03 | 564801580.9465360000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-11-04 | 555883148.1345640000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-11-07 | 557817997.8273320000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-11-08 | 573999255.8073080000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-11-09 | 621369115.2966370000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLU | 2016-11-10 | 681678185.0983780000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |