Derived metrics
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.
696,350 rowsexport restricted — no row in this table may be redistributed
Sources in this table
metric_daily696,350 rowsrestricted — hover for the licence
as_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 |
|---|---|---|---|---|---|---|---|---|
| rr_25d | XOM | 2026-07-30 | 0.0109495524 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLY | 2026-07-30 | 0.0259328117 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLV | 2026-07-30 | 0.0057144896 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLU | 2026-07-30 | -0.0079541338 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLK | 2026-07-30 | 0.0742730027 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLI | 2026-07-30 | 0.0293932062 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLF | 2026-07-30 | 0.0389224631 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLE | 2026-07-30 | -0.0287947561 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | WDC | 2026-07-30 | 0.0292073962 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | SOXX | 2026-07-30 | 0.0249499398 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | SNDK | 2026-07-30 | -0.0200204808 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | SMH | 2026-07-30 | 0.0215148524 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | PANW | 2026-07-30 | 0.0457812597 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | ORCL | 2026-07-30 | -0.0338528742 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | NVDA | 2026-07-30 | 0.0095640003 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | MU | 2026-07-30 | -0.0184875253 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | MSFT | 2026-07-30 | 0.0046577837 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | MRVL | 2026-07-30 | 0.0145153518 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | META | 2026-07-30 | -0.0353452349 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | LMT | 2026-07-30 | 0.0305232436 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | IWM | 2026-07-30 | 0.0350772912 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | INTC | 2026-07-30 | -0.0453189018 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | GOOG | 2026-07-30 | -0.0138190239 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | DIA | 2026-07-30 | 0.0198570320 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | DELL | 2026-07-30 | -0.0098374223 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | DE | 2026-07-30 | -0.0063357563 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | CRWD | 2026-07-30 | -0.0031488784 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | CAT | 2026-07-30 | 0.0014164599 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | AVGO | 2026-07-30 | -0.0021810129 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | AMZN | 2026-07-30 | -0.0370364849 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | AMD | 2026-07-30 | -0.0261092072 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | AAPL | 2026-07-30 | 0.0362914126 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XOM | 2026-07-31 | 0.0306314769 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLY | 2026-07-31 | 0.0155759286 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLV | 2026-07-31 | -0.0080243511 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLU | 2026-07-31 | -0.0083786248 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLP | 2026-07-31 | -0.0066074887 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLK | 2026-07-31 | 0.0337553497 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLI | 2026-07-31 | 0.0049636963 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLF | 2026-07-31 | 0.0105128873 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | XLE | 2026-07-31 | -0.0144867502 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | WDC | 2026-07-31 | 0.0040804239 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | STX | 2026-07-31 | 0.0051906185 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | SPY | 2026-07-31 | 0.0297735499 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | SPCX | 2026-07-31 | -0.0845044551 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | SOXX | 2026-07-31 | 0.0214958514 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | SNDK | 2026-07-31 | 0.0313890070 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | SMH | 2026-07-31 | 0.0208446131 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | QQQ | 2026-07-31 | 0.0414391651 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| rr_25d | PLTR | 2026-07-31 | -0.0394500285 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |