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 | SPY | 2016-09-01 | 0.0000459748 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-02 | 0.0045080087 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-06 | 0.0030224116 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-07 | -0.0000913300 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-08 | -0.0022830008 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-09 | -0.0239348136 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-12 | 0.0143473228 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-13 | -0.0143755203 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-14 | -0.0003751911 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-15 | 0.0099929864 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-16 | -0.0038652848 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-19 | 0.0001875100 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-20 | 0.0000468300 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-21 | 0.0112454738 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-22 | 0.0063014825 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-23 | -0.0054792708 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-26 | -0.0081022268 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-27 | 0.0062080002 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-28 | 0.0049635476 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-29 | -0.0090472951 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-09-30 | 0.0075461620 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-03 | -0.0024040869 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-04 | -0.0050978126 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-05 | 0.0044252470 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-06 | 0.0006956082 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-07 | -0.0034294467 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-10 | 0.0052083847 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-11 | -0.0126295843 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-12 | 0.0013119712 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-13 | -0.0032755228 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-14 | 0.0005164077 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-17 | -0.0034721754 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-18 | 0.0062623692 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-19 | 0.0026671283 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-20 | -0.0018666885 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-21 | 0.0004675098 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-24 | 0.0042527480 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-25 | -0.0033505561 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-26 | -0.0020077182 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-27 | -0.0026668241 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-28 | -0.0029554112 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-10-31 | 0.0000470970 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-11-01 | -0.0072453916 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-11-02 | -0.0060186249 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-11-03 | -0.0045771239 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-11-04 | -0.0011016189 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-11-07 | 0.0220570172 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-11-08 | 0.0045039035 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-11-09 | 0.0106020456 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | SPY | 2016-11-10 | 0.0024955772 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |