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_attimestamp with time zone |
|---|
| ret_1d | STX | 2016-09-01 | -0.0008891523 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-02 | 0.0062296055 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-06 | 0.0162146226 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-07 | 0.0591818973 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-08 | -0.0054779512 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-09 | -0.0060589369 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-12 | 0.0127459130 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-13 | -0.0112175103 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-14 | -0.0019369120 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-15 | 0.0105350707 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-16 | -0.0013717421 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-19 | 0.0050321498 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-20 | -0.0116828929 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-21 | 0.0326484661 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-22 | -0.0079040611 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-23 | 0.0016483516 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-26 | 0.0202962150 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-27 | 0.0327956989 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-28 | -0.0054659032 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-29 | -0.0109918869 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-09-30 | 0.0201111405 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-03 | -0.0036316472 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-04 | -0.0044259307 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-05 | 0.0078451883 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-06 | -0.0189413596 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-07 | 0.0021158424 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-10 | 0.0021113750 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-11 | -0.0755859889 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-12 | 0.0037037037 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-13 | -0.0014192450 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-14 | -0.0005685048 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-17 | -0.0042662116 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-18 | 0.0094258783 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-19 | -0.0288624788 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-20 | 0.0192307692 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-21 | -0.0137221269 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-24 | 0.0005797101 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-25 | -0.0072421784 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-26 | 0.0166326233 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-27 | -0.0172215844 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-28 | -0.0026285047 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-10-31 | 0.0046852123 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-11-01 | -0.0174876129 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-11-02 | -0.0314446752 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-11-03 | 0.0131699847 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-11-04 | -0.0024183797 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-11-07 | 0.0500000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-11-08 | -0.0046176046 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-11-09 | 0.0078283560 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | STX | 2016-11-10 | 0.0405638665 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |