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 = XLY×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_1dXLY2016-09-010.0019860973metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-010.0709030700metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-010.0383258691metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLY2016-09-01-0.0175267770metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLY2016-09-01276340234.1609780000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-0136.3746751267metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLY2016-09-020.0019821606metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-020.0712099574metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-020.0401844424metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLY2016-09-02-0.0155793574metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLY2016-09-02280215772.3447240000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-0236.4467755729metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLY2016-09-060.0018545994metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-060.0607830727metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-060.0419930503metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLY2016-09-06-0.0137536514metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLY2016-09-06289382417.6612910000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-0636.5143697413metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLY2016-09-070.0004936443metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-070.0598378284metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-070.0423908174metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLY2016-09-07-0.0132667965metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLY2016-09-07297061112.4908010000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-0736.5323948528metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLY2016-09-08-0.0086345134metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-080.0661243519metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-080.0333842303metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLY2016-09-08-0.0217867575metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLY2016-09-08286823114.6916590000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-0836.2169554005metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLY2016-09-09-0.0241383601metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-090.1047947060metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-090.0085791408metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLY2016-09-09-0.0453992210metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLY2016-09-09307194135.7332240000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-0935.3427374899metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLY2016-09-120.0140252454metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-120.1112027841metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-120.0227824124metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLY2016-09-12-0.0320107108metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLY2016-09-12331308887.2422430000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-1235.8384280578metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLY2016-09-13-0.0142084748metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-130.1195437358metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLY2016-09-130.0084066738metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLY2016-09-13-0.0457643622metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLY2016-09-13353743777.8833020000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-1335.3292186562metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLY2016-09-140.0001275510metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-140.1189287531metric_daily——2026-09-09 11:172026-09-09 11:17