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 = XLE×sorted by as_of_date ↑×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 100 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
px_vs_200dmaXLE2016-09-140.0671204436metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-14-0.0594376392metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-14718976496.7331390000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-1422.5070120904metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-150.0124315525metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-150.2205103228metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-150.0802228545metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-15-0.0477449889metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-15733836643.6265540000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-1522.7868091920metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-16-0.0080806792metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-160.2215854082metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-160.0714231395metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-16-0.0554398561metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-16738795458.7363380000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-1622.6026762969metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-19-0.0005930319metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-190.2071958696metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-190.0705452835metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-19-0.0560000104metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-19709780570.5188180000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-1922.5892721893metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-20-0.0072689512metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-200.2068338555metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-200.0624552723metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-20-0.0628619003metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-20715286030.5319550000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-2022.4250718723metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-210.0231619845metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-210.2212298424metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-210.0865806074metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-21-0.0411559222metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-21728347148.1209460000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-2122.9444810385metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-220.0011683949metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-220.2196763862metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-220.0871537882metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-22-0.0400356136metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-22729784228.0401140000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-2222.9712892535metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-23-0.0132749818metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-230.2237575875metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-230.0720600686metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-23-0.0527791233metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-23743174243.8909110000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-2322.6663458076metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-26-0.0044352454metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-260.2239906254metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-260.0667390332metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-26-0.0569802804metric_daily——2026-09-09 11:172026-09-09 11:17