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 = XLP×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_1dXLP2016-09-010.0003677823metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-010.0520613568metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLP2016-09-010.0462652851metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLP2016-09-01-0.0235146293metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLP2016-09-01371672108.9471300000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-0141.5942087743metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLP2016-09-020.0077205882metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-020.0581265574metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLP2016-09-020.0536257252metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLP2016-09-02-0.0159755879metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLP2016-09-02375815173.2631370000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-0241.9153405332metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLP2016-09-060.0021743889metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-060.0583093927metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLP2016-09-060.0552533671metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLP2016-09-06-0.0138359361metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLP2016-09-06370456790.2928990000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-0642.0064807848metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLP2016-09-07-0.0087223695metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-070.0660914025metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLP2016-09-070.0454531090metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLP2016-09-07-0.0224376234metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLP2016-09-07381065920.6359700000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-0741.6400847398metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLP2016-09-08-0.0055086302metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-080.0676151772metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLP2016-09-080.0390978561metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLP2016-09-08-0.0278226530metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLP2016-09-08391764248.8771920000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-0841.4107049120metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLP2016-09-09-0.0271418021metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-090.1129447813metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLP2016-09-090.0104987873metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLP2016-09-09-0.0542092982metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLP2016-09-09424975067.5384970000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-0940.2867437558metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLP2016-09-120.0187891441metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-120.1338165010metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLP2016-09-120.0289969292metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLP2016-09-12-0.0364387004metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLP2016-09-12454831334.8893990000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-1241.0436971875metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLP2016-09-13-0.0122950820metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-130.1382047890metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaXLP2016-09-130.0159401797metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dXLP2016-09-13-0.0482857656metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dXLP2016-09-13479258405.6095750000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-1340.5390615664metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dXLP2016-09-14-0.0030177292metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLP2016-09-140.1382474520metric_daily——2026-09-09 11:172026-09-09 11:17