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 = IWM×metric_id = rr_25d×

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
rr_25dIWM2026-09-170.0123350526metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dIWM2026-09-160.0395038583metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dIWM2026-09-150.0356130516metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dIWM2026-09-140.0997734564metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dIWM2026-09-110.0155577999metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dIWM2026-09-100.0281186183metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dIWM2026-09-090.0203655616metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dIWM2026-09-080.0187648027metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dIWM2026-09-040.0172211328metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-09-030.0089187787metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-09-020.0251489406metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-09-010.0373746559metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-310.0215452659metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-280.0193461679metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-270.0183895237metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-260.0199315420metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-250.0205449325metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-240.0249950593metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-210.0235347891metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-200.0319523836metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-190.0241251802metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-180.0308285384metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-170.0255195800metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-140.0174357061metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-130.0152233218metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-120.0154558805metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-110.0188372606metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-100.0200220586metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-070.0137757902metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-060.0207586670metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-050.0169892249metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-040.0156055743metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-08-030.0245182730metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-07-310.0354153617metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dIWM2026-07-300.0350772912metric_daily——2026-09-15 12:172026-09-15 12:17