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 = DIA×metric_id = vrp_30d×

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
vrp_30dDIA2026-09-180.0116050000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-170.0044400000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-160.0123420000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-150.0166330000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-140.0079580000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-110.0126550000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-100.0179500000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-090.0263350000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-080.0310310000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dDIA2026-09-040.0349960000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-09-030.0350470000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-09-020.0536070000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-09-010.0372400000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-310.0214670000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-280.0186150000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-270.0266870000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-260.0204340000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-250.0005070000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-240.0010880000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-21-0.0063580000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-20-0.0049550000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-19-0.0098000000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-18-0.0101580000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-17-0.0026350000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-14-0.0064950000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-13-0.0155140000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-12-0.0175840000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-11-0.0115230000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-10-0.0082810000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-07-0.0191510000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-06-0.0151580000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-05-0.0133450000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-04-0.0166390000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-08-03-0.0037310000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-310.0021850000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-300.0025700000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-290.0098090000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-280.0420970000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-270.0544180000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-240.0628640000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-230.0655720000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-220.0673720000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-210.0598850000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-200.0560150000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-170.0626370000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-160.0531940000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-150.0439570000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-140.0524970000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-130.0475450000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dDIA2026-07-100.0377790000metric_daily2026-09-15 12:172026-09-15 12:17