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_daily698,194 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 |
|---|
| ret_1d | XLF | 2016-09-01 | -0.0040716612 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-01 | 0.0895428343 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLF | 2016-09-01 | 0.0727051573 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-01 | -0.0040716612 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLF | 2016-09-01 | 480797897.0708320000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| close_adj | XLF | 2016-09-01 | 16.5124162815 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLF | 2016-09-02 | 0.0044971382 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-02 | 0.0886984054 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLF | 2016-09-02 | 0.0773360481 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-02 | 0.0000000000 | 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 |
| close_adj | XLF | 2016-09-02 | 16.5866748992 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLF | 2016-09-06 | -0.0016280016 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-06 | 0.0639710496 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLF | 2016-09-06 | 0.0754984046 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-06 | -0.0016280016 | 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 |
| close_adj | XLF | 2016-09-06 | 16.5596717655 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLF | 2016-09-07 | -0.0004076641 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-07 | 0.0641498085 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLF | 2016-09-07 | 0.0749878940 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-07 | -0.0020350020 | 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 |
| close_adj | XLF | 2016-09-07 | 16.5529209821 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLF | 2016-09-08 | -0.0008156607 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-08 | 0.0644347459 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLF | 2016-09-08 | 0.0740530350 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-08 | -0.0028490028 | 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 |
| close_adj | XLF | 2016-09-08 | 16.5394194152 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLF | 2016-09-09 | -0.0187755102 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-09 | 0.0892799059 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLF | 2016-09-09 | 0.0539137532 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-09 | -0.0215710216 | 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 |
| close_adj | XLF | 2016-09-09 | 16.2288833772 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLF | 2016-09-12 | 0.0112312812 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-12 | 0.0968412655 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLF | 2016-09-12 | 0.0656983168 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-12 | -0.0105820106 | 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 |
| close_adj | XLF | 2016-09-12 | 16.4111545299 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLF | 2016-09-13 | -0.0176881942 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-13 | 0.1156186340 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| px_vs_200dma | XLF | 2016-09-13 | 0.0468999075 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-13 | -0.0280830281 | 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 |
| close_adj | XLF | 2016-09-13 | 16.1208708422 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | XLF | 2016-09-14 | -0.0025125628 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| realized_vol_21d | XLF | 2016-09-14 | 0.1133349246 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |