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
active:metric_id = px_vs_200dma×
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 |
|---|---|---|---|---|---|---|---|---|
| px_vs_200dma | XOM | 2026-09-18 | 0.1252286871 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLY | 2026-09-18 | -0.0475861827 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLV | 2026-09-18 | 0.0851257076 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLU | 2026-09-18 | -0.0705974346 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLP | 2026-09-18 | -0.0020258410 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLK | 2026-09-18 | 0.1686715418 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLI | 2026-09-18 | -0.0081435272 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLF | 2026-09-18 | 0.0450620000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLE | 2026-09-18 | 0.1626149771 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | WDC | 2026-09-18 | 0.1444020208 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | STX | 2026-09-18 | 0.3879040942 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | SPY | 2026-09-18 | 0.0690607573 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | SPCX | 2026-09-18 | — | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | SOXX | 2026-09-18 | 0.2072259185 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | SNDK | 2026-09-18 | 0.6773600923 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | SMH | 2026-09-18 | 0.1760224537 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | QQQ | 2026-09-18 | 0.0901778749 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | PLTR | 2026-09-18 | 0.1705889204 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | PANW | 2026-09-18 | 0.5112741810 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | ORCL | 2026-09-18 | -0.1079469350 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | NVDA | 2026-09-18 | 0.1224546324 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | MU | 2026-09-18 | 0.5871447594 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | MSFT | 2026-09-18 | 0.1481235046 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | MRVL | 2026-09-18 | 0.5423530972 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | META | 2026-09-18 | 0.0676822796 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | LMT | 2026-09-18 | -0.0368517701 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | IWM | 2026-09-18 | 0.0387183304 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | INTC | 2026-09-18 | 0.4075402554 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | GOOG | 2026-09-18 | 0.0257389107 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | DIA | 2026-09-18 | 0.0366235049 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | DELL | 2026-09-18 | 1.0891554513 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | DE | 2026-09-18 | 0.1886464993 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | CRWD | 2026-09-18 | 0.6170042300 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | CRSR | 2026-09-18 | 0.6909044380 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | CAT | 2026-09-18 | 0.0342900461 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AVGO | 2026-09-18 | -0.0292519393 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AMZN | 2026-09-18 | 0.0558019482 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AMD | 2026-09-18 | 0.5786298713 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | AAPL | 2026-09-18 | 0.1755113658 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XOM | 2026-09-17 | 0.1252757385 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLY | 2026-09-17 | -0.0447670882 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLV | 2026-09-17 | 0.0883606206 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLU | 2026-09-17 | -0.0574947367 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLP | 2026-09-17 | 0.0066012217 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLK | 2026-09-17 | 0.1608602813 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLI | 2026-09-17 | -0.0119010252 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLF | 2026-09-17 | 0.0457890488 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | XLE | 2026-09-17 | 0.1677626615 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | WDC | 2026-09-17 | 0.1030294548 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| px_vs_200dma | STX | 2026-09-17 | 0.3041693759 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |