Simplify Analytics
← Data Explorer

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

as_of_dateto
column equals (exact text)
sort
chart against as_of_date
reset
active:entity_id = MSFT×metric_id = iv_term_regime_days×

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_idtextentity_idtextas_of_date ↓datevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
iv_term_regime_daysMSFT2026-09-18-35.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-17-34.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-16-33.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-15-32.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-14-31.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-11-30.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-10-29.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-09-28.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-08-27.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
iv_term_regime_daysMSFT2026-09-04-26.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-09-03-25.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-09-02-24.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-09-01-23.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-31-22.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-28-21.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-27-20.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-26-19.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-25-18.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-24-17.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-21-16.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-20-15.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-19-14.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-18-13.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-17-12.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-14-11.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-13-10.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-12-9.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-11-8.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-10-7.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-07-6.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-06-5.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-05-4.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-04-3.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-08-03-2.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-31-1.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-3024.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-2923.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-2822.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-2721.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-2420.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-2319.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-2218.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-2117.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-2016.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-1715.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-1614.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-1513.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-1412.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-1311.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
iv_term_regime_daysMSFT2026-07-1010.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17