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.

697,178 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×sorted by as_of_date ↑×

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
ret_1dXOM2016-09-01-0.0034427358metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-010.1140476276metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-010.0397730469metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXOM2016-09-01-0.0792626746metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXOM2016-09-01506818802.2164990000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-0156.3774498277metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXOM2016-09-020.0066789498metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-020.1163117624metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-020.0461224153metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXOM2016-09-02-0.0731131162metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXOM2016-09-02489935774.7256530000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-0256.7539919846metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXOM2016-09-060.0131548845metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-060.1244422118metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-060.0592569668metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXOM2016-09-06-0.0609200263metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXOM2016-09-06491095326.7281860000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-0657.5005841921metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXOM2016-09-07-0.0037258665metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-070.1189785641metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-070.0546800995metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXOM2016-09-07-0.0644189130metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXOM2016-09-07482980264.5795220000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-0757.2863446891metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXOM2016-09-080.0091795104metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-080.1229302484metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-080.0636432753metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXOM2016-09-08-0.0558307367metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXOM2016-09-08483102083.0142870000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-0857.8122052874metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXOM2016-09-09-0.0248175182metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-090.1381716922metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-090.0367130688metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXOM2016-09-09-0.0792626746metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXOM2016-09-09483554034.5065200000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-0956.3774498277metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXOM2016-09-120.0051819438metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-120.1387627809metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-120.0416187483metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXOM2016-09-12-0.0744914655metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXOM2016-09-12481796859.3286960000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-1256.6695946046metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXOM2016-09-13-0.0238286173metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-130.1542033755metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXOM2016-09-130.0164323000metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXOM2016-09-13-0.0965450541metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXOM2016-09-13489484630.8614230000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-1355.3192365249metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXOM2016-09-14-0.0071587842metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXOM2016-09-140.1554259358metric_daily——2026-09-09 11:172026-09-09 11:17