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 = XLP×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_25dXLP2026-09-17-0.0061413031metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dXLP2026-09-16-0.0051656719metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dXLP2026-09-150.0040441971metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dXLP2026-09-140.0059542388metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dXLP2026-09-110.0118875896metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dXLP2026-09-10-0.0091788807metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dXLP2026-09-09-0.0006859230metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dXLP2026-09-08-0.0097457624metric_daily——2026-09-18 18:302026-09-18 18:30
rr_25dXLP2026-09-04-0.0008755731metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-09-03-0.0033997272metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-09-02-0.0015639134metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-09-01-0.0123466436metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-31-0.0071363061metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-280.0010859445metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-27-0.0097855518metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-26-0.0158646833metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-25-0.0107247124metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-240.0020077094metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-21-0.0116710167metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-20-0.0175668589metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-19-0.0122643263metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-18-0.0087631661metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-17-0.0104990832metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-14-0.0179918467metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-13-0.0095114228metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-12-0.0121552260metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-11-0.0062066922metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-10-0.0075627761metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-07-0.0152513097metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-06-0.0116752308metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-05-0.0196891837metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-04-0.0155439293metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-08-03-0.0141046866metric_daily——2026-09-15 12:172026-09-15 12:17
rr_25dXLP2026-07-31-0.0066074887metric_daily——2026-09-15 12:172026-09-15 12:17