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 |
|---|
| dollar_volume_21d | XLF | 2016-09-01 | 480797897.0708320000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-02 | 504432337.7210280000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-06 | 510727958.2462170000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-07 | 507216108.2958310000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-08 | 533058746.5219340000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-09 | 553872872.9266140000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-12 | 593490808.9239930000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-13 | 627411031.9949590000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-14 | 662481687.3606040000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-15 | 693044518.9504130000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-16 | 723554007.6773610000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-19 | 745562441.0800190000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-20 | 756459422.7144180000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-21 | 785564522.6606220000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-22 | 796533378.5170060000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-23 | 826757347.6050700000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-26 | 850714702.0573730000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-27 | 846211881.9587770000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-28 | 853491634.1935240000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-29 | 875657319.3848470000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-30 | 875779290.1640740000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-03 | 860895855.0873680000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-04 | 870478101.7751120000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-05 | 877561656.0501350000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-06 | 894417962.5586550000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-07 | 891627247.1944550000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-10 | 879688305.5771730000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-11 | 885413574.1113810000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-12 | 873387599.6435660000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-13 | 878074661.9362880000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-14 | 889041451.4109140000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-17 | 874107125.2987160000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-18 | 871033099.5557320000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-19 | 879337494.1978970000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-20 | 873799705.3381630000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-21 | 874987235.4867830000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-24 | 856011246.4058270000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-25 | 843245292.2721710000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-26 | 838688666.8963480000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-27 | 841688733.4253350000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-28 | 838136976.6752710000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-10-31 | 832131525.5734870000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-11-01 | 855858513.6719610000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-11-02 | 855002644.5735100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-11-03 | 850846269.9386200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-11-04 | 859516757.8758760000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-11-07 | 863073752.9189510000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-11-08 | 883583690.8657390000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-11-09 | 1045190417.6586200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-11-10 | 1212935576.7358700000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |