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 = SMH×metric_id = gamma_flip_level×

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
gamma_flip_levelSMH2026-09-17—metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_levelSMH2026-09-16560.0712746817metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_levelSMH2026-09-15558.9423570431metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_levelSMH2026-09-14565.9713480219metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_levelSMH2026-09-11568.0340982345metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_levelSMH2026-09-10565.9572257615metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_levelSMH2026-09-09567.6961760991metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_levelSMH2026-09-08564.5766503564metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_levelSMH2026-09-04568.3114011644metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-09-03561.6721712131metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-09-02562.8503801137metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-09-01563.1816003839metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-31567.1887451459metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-28569.3670536067metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-27562.6412362217metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-26564.9414807566metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-25569.5713541063metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-24572.3467965591metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-21574.9922478244metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-20576.0615876214metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-19579.1778789054metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-18583.9768653903metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-17583.7455586741metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-14581.5202203756metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-13582.0172896866metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-12578.9064176973metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-11578.0758776863metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-10582.1181126201metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-07583.0152273163metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-06579.8665147557metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-05580.3581746648metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-04588.9099572498metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-08-03589.2281113933metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-31585.3577332130metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-30582.0461771877metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-29618.7289797523metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-28620.7314955480metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-27635.4161515340metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-24643.1710139480metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-23637.8114538276metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-22651.1087808324metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-21656.4126150320metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-20666.6352508632metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-17679.9545645170metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-16626.9025635870metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-15632.8430868319metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-14640.6230905296metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-13651.2248063154metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-10654.1352434928metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSMH2026-07-09655.9897889471metric_daily——2026-09-15 12:172026-09-15 12:17