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_daily700,356 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 | AMZN | 2016-09-01 | 0.0018981746 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-02 | 0.0023617347 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-06 | 0.0212702605 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-07 | -0.0055649220 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-08 | -0.0005353865 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-09 | -0.0305078693 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-12 | 0.0149314600 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-13 | -0.0135841035 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-14 | 0.0001051235 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-15 | 0.0112995835 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-16 | 0.0114721511 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-19 | -0.0043929507 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-20 | 0.0066055993 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-21 | 0.0122016867 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-22 | 0.0189429432 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-23 | 0.0013048341 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-26 | -0.0081787155 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-27 | 0.0212097703 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-28 | 0.0154513485 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-29 | 0.0003982045 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-09-30 | 0.0099632109 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-03 | -0.0006807515 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-04 | -0.0032387599 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-05 | 0.0123856456 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-06 | -0.0031976882 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-07 | -0.0026495259 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-10 | 0.0027161288 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-11 | -0.0127240974 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-12 | 0.0037184116 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-13 | -0.0057667638 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-14 | -0.0076210689 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-17 | -0.0121634101 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-18 | 0.0057814134 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-19 | 0.0000489207 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-20 | -0.0090131957 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-21 | 0.0106994767 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-24 | 0.0233214081 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-25 | -0.0034721808 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-26 | -0.0150745947 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-27 | -0.0051422945 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-28 | -0.0513710348 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-10-31 | 0.0173897362 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-11-01 | -0.0055835507 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-11-02 | -0.0252734241 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-11-03 | 0.0019201630 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-11-04 | -0.0156186851 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-11-07 | 0.0395735382 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-11-08 | 0.0035926771 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-11-09 | -0.0201459854 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| ret_1d | AMZN | 2016-11-10 | -0.0382183759 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |