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 = LMT×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_date ↓datevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
put_wall_distance_pctLMT2026-09-17-0.0057425338metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-16-0.0041879944metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-150.0028868144metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-140.0106161925metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-110.0206222934metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-100.0092054629metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-090.0200968615metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-08-0.0021449221metric_daily——2026-09-18 18:302026-09-18 18:30
put_wall_distance_pctLMT2026-09-040.0185044167metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-09-030.0038465147metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-09-020.0064904525metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-09-01-0.0174471993metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-310.0156263920metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-280.0109071562metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-270.0072628956metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-260.0077437149metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-250.0242219507metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-240.0103874925metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-210.0114094079metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-200.0236578708metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-19-0.0070440465metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-18-0.0365136617metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-17-0.0147202479metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-14-0.0389038575metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-13-0.0217554890metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-12-0.0028349156metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-11-0.0213627315metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-10-0.0301080974metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-07-0.0305298070metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-06-0.0220468388metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-05-0.0131578947metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-04-0.0327999593metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-08-03-0.0277848846metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-31-0.0905034835metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-30-0.0071589068metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-290.0014054814metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-28-0.0194560561metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-27-0.0172413793metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-24-0.0902849296metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-23-0.0678696424metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-220.0304067190metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-21-0.0041215563metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-200.0401538643metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-170.0417280893metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-16-0.0263280885metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-15-0.0281071415metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-14-0.0291073613metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-13-0.0397172928metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-10-0.0443790375metric_daily——2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctLMT2026-07-09-0.0062902790metric_daily——2026-09-15 12:172026-09-15 12:17