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 100 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 | XLE | 2026-09-18 | -0.0026364764 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | WDC | 2026-09-18 | 0.0412626513 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | STX | 2026-09-18 | 0.0693038487 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | SPY | 2026-09-18 | 0.0012867354 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | SPCX | 2026-09-18 | -0.0135650152 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | SOXX | 2026-09-18 | 0.0269119630 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | SNDK | 2026-09-18 | 0.1099052893 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | SMH | 2026-09-18 | 0.0221009258 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | QQQ | 2026-09-18 | 0.0063186966 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | PLTR | 2026-09-18 | 0.0079437131 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | PANW | 2026-09-18 | -0.0306084360 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | ORCL | 2026-09-18 | -0.0197888306 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | NVDA | 2026-09-18 | 0.0133582566 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | MU | 2026-09-18 | 0.0391815857 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | MSFT | 2026-09-18 | -0.0079758915 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | MRVL | 2026-09-18 | 0.0144957634 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | META | 2026-09-18 | -0.0242704929 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | LMT | 2026-09-18 | -0.0087531826 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | IWM | 2026-09-18 | -0.0046596363 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | INTC | 2026-09-18 | -0.0018382353 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | GOOG | 2026-09-18 | 0.0021240689 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | DIA | 2026-09-18 | -0.0024703882 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | DELL | 2026-09-18 | -0.0345683209 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | DE | 2026-09-18 | -0.0023919607 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | CRWD | 2026-09-18 | -0.0327635328 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | CRSR | 2026-09-18 | -0.0096225019 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | CAT | 2026-09-18 | 0.0130483239 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AVGO | 2026-09-18 | 0.0296861503 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AMZN | 2026-09-18 | 0.0100322465 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AMD | 2026-09-18 | 0.0270230604 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| ret_1d | AAPL | 2026-09-18 | -0.0025816024 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_flags | US | 2026-09-18 | 0.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| regime_code | US | 2026-09-18 | 1.0000000000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XOM | 2026-09-18 | 0.2549489392 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XLY | 2026-09-18 | 0.1595886304 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XLV | 2026-09-18 | 0.1522588724 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XLU | 2026-09-18 | 0.1521417610 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XLP | 2026-09-18 | 0.1338063747 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XLK | 2026-09-18 | 0.2068001689 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XLI | 2026-09-18 | 0.1320197600 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XLF | 2026-09-18 | 0.1330094673 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | XLE | 2026-09-18 | 0.1892642345 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | WDC | 2026-09-18 | 0.4937515093 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | STX | 2026-09-18 | 0.5788180619 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | SPY | 2026-09-18 | 0.0941379861 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | SPCX | 2026-09-18 | 0.4427433019 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | SOXX | 2026-09-18 | 0.3651415781 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | SNDK | 2026-09-18 | 0.7376428796 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | SMH | 2026-09-18 | 0.3325331699 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| realized_vol_21d | QQQ | 2026-09-18 | 0.1321470434 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |