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 = XOM×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_30dXOM2026-09-180.0199840000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-170.0105450000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-160.0104140000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-150.0438920000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-140.0317120000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-110.0499990000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-100.0410980000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-090.0664470000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-080.0314310000metric_daily2026-09-18 18:302026-09-18 18:30
vrp_30dXOM2026-09-040.0118050000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-09-030.0304490000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-09-020.0377490000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-09-010.0380240000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-310.0580480000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-280.0622020000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-270.0742290000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-260.0810710000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-250.0641830000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-240.0792430000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-210.0901290000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-200.0831270000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-190.0784830000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-180.0637360000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-170.0861330000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-140.0788530000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-130.0487000000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-120.0483620000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-110.0760050000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-100.0521160000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-070.0495350000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-060.0294250000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-050.0543240000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-040.0305790000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-08-030.0199120000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-310.0086600000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-300.0228050000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-290.0364040000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-280.0300580000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-270.0229690000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-240.0483270000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-230.0321590000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-220.0264710000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-210.0367470000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-200.0344230000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-170.0264290000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-160.0253650000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-15-0.0064750000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-140.0055110000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-130.0001400000metric_daily2026-09-15 12:172026-09-15 12:17
vrp_30dXOM2026-07-100.0618060000metric_daily2026-09-15 12:172026-09-15 12:17