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 = SPCX×metric_id = gamma_flip_distance_atr×

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_distance_atrSPCX2026-09-17-1.0965364800metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrSPCX2026-09-16-1.0370149114metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrSPCX2026-09-15—metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrSPCX2026-09-14-0.8417260853metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrSPCX2026-09-11-1.3699646906metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrSPCX2026-09-10-0.3349407968metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrSPCX2026-09-090.2356955085metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrSPCX2026-09-08-1.1186764260metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_distance_atrSPCX2026-09-04-0.4576466046metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-09-03-1.4448838441metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-09-02-0.2247955153metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-09-01-0.6087178133metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-31-0.7649121886metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-28-0.5444866143metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-27-0.5989793848metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-26-0.4659902838metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-25-0.1828730022metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-240.2728116766metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-210.3070947424metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-200.5031526937metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-190.0884097699metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-18-0.3000770794metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-17-0.7300200855metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-14-0.2394290125metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-13-0.5171943705metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-12-1.3666889664metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-11-0.3791819480metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-10-1.0022243442metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-07-0.4472322698metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-060.8453762667metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-051.9813133909metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-040.4909215504metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-08-032.2072447602metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-31—metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-301.2112254874metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-291.6807939906metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-281.9371289043metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-272.9065107818metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-24—metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-231.4993133546metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-222.9684624670metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-212.2933809635metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-20—metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-17—metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-162.4249615507metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-152.2915891244metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-142.4317390044metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-132.2307996969metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-101.6200742962metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_distance_atrSPCX2026-07-090.3570839587metric_daily——2026-09-15 12:172026-09-15 12:17