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 |
|---|---|---|---|---|---|---|---|---|
| vrp_30d | XOM | 2026-09-18 | 0.0199840000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | XLY | 2026-09-18 | 0.0441090000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | XLV | 2026-09-18 | 0.0220400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | XLU | 2026-09-18 | 0.0110230000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | XLP | 2026-09-18 | 0.0264020000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | XLK | 2026-09-18 | 0.0657450000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | XLI | 2026-09-18 | 0.0418370000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | XLF | 2026-09-18 | 0.0079610000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | XLE | 2026-09-18 | 0.0544250000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | WDC | 2026-09-18 | 0.2263400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | STX | 2026-09-18 | 0.1351830000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | SPY | 2026-09-18 | 0.0381440000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | SPCX | 2026-09-18 | 0.1828400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | SOXX | 2026-09-18 | 0.0501020000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | SNDK | 2026-09-18 | 0.1142450000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | SMH | 2026-09-18 | 0.0414160000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | QQQ | 2026-09-18 | 0.0711250000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | PLTR | 2026-09-18 | -0.0379700000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | PANW | 2026-09-18 | -0.2124680000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | ORCL | 2026-09-18 | 0.1795530000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | NVDA | 2026-09-18 | -0.0419220000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | MU | 2026-09-18 | 0.1319720000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | MSFT | 2026-09-18 | 0.0473760000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | MRVL | 2026-09-18 | 0.0952970000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | META | 2026-09-18 | 0.0620390000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | LMT | 2026-09-18 | 0.0288190000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | IWM | 2026-09-18 | 0.0569350000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | INTC | 2026-09-18 | 0.0329270000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | GOOG | 2026-09-18 | 0.0642220000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | DIA | 2026-09-18 | 0.0116050000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | DELL | 2026-09-18 | -0.0423030000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | DE | 2026-09-18 | -0.0799470000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | CRWD | 2026-09-18 | -0.3512490000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | CRSR | 2026-09-18 | 0.0133680000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | CAT | 2026-09-18 | 0.0961160000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | AVGO | 2026-09-18 | 0.1680810000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | AMZN | 2026-09-18 | 0.0301670000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | AMD | 2026-09-18 | 0.0515910000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| vrp_30d | AAPL | 2026-09-18 | 0.0250130000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_dispersion_21d | US | 2026-09-18 | 0.0371834875 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_corr_63d | US | 2026-09-18 | 0.0491649542 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| sector_breadth_200dma | US | 2026-09-18 | 0.5000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | XOM | 2026-09-18 | 0.0016537025 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | XLY | 2026-09-18 | -0.0032318880 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | XLV | 2026-09-18 | -0.0024880043 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | XLU | 2026-09-18 | -0.0141520748 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | XLP | 2026-09-18 | -0.0082644628 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | XLK | 2026-09-18 | 0.0081888759 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | XLI | 2026-09-18 | 0.0043784391 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | XLF | 2026-09-18 | -0.0003579098 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |