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 = STX×metric_id = gamma_flip_level×sorted by as_of_date ↑×

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_levelSTX2026-06-17930.8538555199metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-06-18849.4184273738metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-06-22913.0325033404metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-06-23959.1380639758metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-06-24972.3437919792metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-06-25987.8691714427metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-06-26884.1105351992metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-06-29916.5871715104metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-06-30914.9981158433metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-01—metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-02913.0834791533metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-06893.4413666989metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-07904.6630514608metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-08894.9376770515metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-09882.3731087666metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-10855.5163459615metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-13—metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-14861.9455212025metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-15870.4456400774metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-16862.5457426547metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-17—metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-20834.4442197642metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-21820.6479559944metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-22848.6468277122metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-23885.1952144808metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-24747.7929734884metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-27747.7133473144metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-28763.5745265209metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-29764.3805866081metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-30778.0193020975metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-07-31774.0213557773metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-03798.7510822112metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-04791.7204437634metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-05812.0989623072metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-06834.3509038901metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-07799.3895741647metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-10798.6477259528metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-11805.5343869133metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-12823.7262058474metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-13829.0714371840metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-14810.1575567556metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-17837.0315811158metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-18869.3380505788metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-19860.1709205060metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-20846.6825205250metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-21861.1744416652metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-24852.1897379838metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-25851.8140938627metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-26842.8290068227metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_levelSTX2026-08-27841.3098625352metric_daily——2026-09-15 12:172026-09-15 12:17