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 = put_wall_distance_pct×

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_datedatevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
put_wall_distance_pctIWM2026-09-17-0.0015064990metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctIWM2026-09-160.0038038884metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctIWM2026-09-15-0.0004909869metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctIWM2026-09-14-0.0101073252metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctIWM2026-09-11-0.0134653328metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctIWM2026-09-100.0079944387metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctIWM2026-09-09-0.0022020369metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctIWM2026-09-08-0.0158482370metric_daily2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctIWM2026-09-04-0.0203033681metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-09-03-0.0175818964metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-09-02-0.0136389919metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-09-01-0.0019616616metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-31-0.0133705304metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-28-0.0025359256metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-27-0.0160434942metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-26-0.0131468906metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-25-0.0141362831metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-24-0.0099674464metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-21-0.0165355381metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-20-0.0089696644metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-19-0.0222723054metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-18-0.0174199780metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-17-0.0297967506metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-14-0.0330722082metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-13-0.0280065898metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-12-0.0254699217metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-11-0.0199009934metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-10-0.0166011067metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-07-0.0217535482metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-06-0.0108968986metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-05-0.0159121994metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-04-0.0553843094metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-08-03-0.0378772534metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-31-0.0212912088metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-30-0.0088519772metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-29-0.0123713484metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-28-0.0285305246metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-27-0.0099347923metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-24-0.0211903699metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-23-0.0071553288metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-22-0.0129003710metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-21-0.0220543603metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-20-0.0079025692metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-17-0.0307441164metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-16-0.0189113299metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-15-0.0195084018metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-14-0.0153135717metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-13-0.0118577075metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-10-0.0202371702metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctIWM2026-07-09-0.0243574216metric_daily2026-09-15 12:172026-09-15 12:17