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 = IWM×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_1dIWM2016-09-010.0007303416metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-010.0923399546metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-010.1065898739metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dIWM2016-09-01-0.0061250806metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dIWM2016-09-012095898359.3540000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-01108.7965445571metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dIWM2016-09-020.0096496919metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-020.0969179228metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-020.1166990925metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dIWM2016-09-020.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dIWM2016-09-022127867336.8936900000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-02109.8463976874metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dIWM2016-09-060.0009573528metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-060.0848457881metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-060.1172891164metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dIWM2016-09-060.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dIWM2016-09-062052484078.8554500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-06109.9515594463metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dIWM2016-09-070.0062649844metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-070.0866465193metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-070.1237436054metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dIWM2016-09-070.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dIWM2016-09-072071308694.9101100000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-07110.6404042565metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dIWM2016-09-08-0.0019934614metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-080.0873664662metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-080.1210094918metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dIWM2016-09-08-0.0019934614metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dIWM2016-09-082092636429.8262200000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-08110.4198468762metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dIWM2016-09-09-0.0312400128metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-090.1399628432metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-090.0857288795metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dIWM2016-09-09-0.0331711985metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dIWM2016-09-092271242317.2122500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-09106.9703294482metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dIWM2016-09-120.0139381443metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-120.1473504110metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-120.1005567359metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dIWM2016-09-12-0.0196953991metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dIWM2016-09-122335354005.0977000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-12108.4612973391metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dIWM2016-09-13-0.0191963559metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-130.1621475626metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaIWM2016-09-130.0792887364metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dIWM2016-09-13-0.0385136751metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dIWM2016-09-132513268251.5125600000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-13106.3792356690metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dIWM2016-09-140.0001658650metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dIWM2016-09-140.1576613706metric_daily——2026-09-09 11:172026-09-09 11:17