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 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_1dXLE2016-09-01-0.0029192819metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-010.1479471878metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-010.0811178179metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-01-0.0378873239metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-01637972279.1018440000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-0122.7535000132metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-020.0112721417metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-020.1518489588metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-020.0930306467metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-02-0.0270422535metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-02625983356.5525480000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-0223.0099806897metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-060.0150550087metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-060.1568844608metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-060.1092125215metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-06-0.0123943662metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-06629995972.6852280000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-0623.3563961488metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-070.0057045066metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-070.1519979524metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-070.1151503191metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-07-0.0067605634metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-07616730295.6495560000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-0723.4896328639metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-080.0187180942metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-080.1610330837metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-080.1354454511metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-080.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-08633733739.0794460000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-0823.9293140236metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-09-0.0297884187metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-090.1914601644metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-090.1012887354metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-09-0.0297884187metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-09643348335.7499110000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-0923.2164975980metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-120.0098995696metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-120.1880475421metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-120.1119173535metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-12-0.0201837416metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-12654637682.8067630000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-1223.4463309315metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-13-0.0285551925metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-130.2140754360metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLE2016-09-130.0800253501metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLE2016-09-13-0.0481625835metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLE2016-09-13685750829.4129760000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-1322.7768164384metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLE2016-09-14-0.0118455689metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLE2016-09-140.2156030077metric_daily——2026-09-09 11:172026-09-09 11:17