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.

698,194 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 = SMH×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_1dSMH2016-09-010.0092131098metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-010.0876363749metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-010.2117910292metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSMH2016-09-010.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSMH2016-09-0181044927.8150937000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-0130.4358320165metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSMH2016-09-02-0.0008979348metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-020.0870654255metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-020.2091653035metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSMH2016-09-02-0.0008979348metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSMH2016-09-0283246025.7459712000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-0230.4085026253metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSMH2016-09-06-0.0001497903metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-060.0806787741metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-060.2074817184metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSMH2016-09-06-0.0010475905metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSMH2016-09-0687021432.2474738000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-0630.4039477268metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSMH2016-09-07-0.0065917603metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-070.0856863398metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-070.1981255493metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSMH2016-09-07-0.0076324454metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSMH2016-09-0796293629.9127586000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-0730.2035321912metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSMH2016-09-08-0.0019604886metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-080.0843865840metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-080.1944220449metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSMH2016-09-08-0.0095779707metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSMH2016-09-08101494233.6422340000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-0830.1443185102metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSMH2016-09-09-0.0362647325metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-090.1531857426metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-090.1499900103metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSMH2016-09-09-0.0454953607metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSMH2016-09-09129929495.2246080000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-0929.0511428616metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSMH2016-09-120.0205393540metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-120.1688773583metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-120.1723932813metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSMH2016-09-12-0.0258904520metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSMH2016-09-12147084526.4788660000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-1229.6478345698metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSMH2016-09-13-0.0109079736metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-130.1728024089metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSMH2016-09-130.1584859913metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSMH2016-09-13-0.0365160132metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSMH2016-09-13153741372.8517040000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-1329.3244367738metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSMH2016-09-140.0083876980metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSMH2016-09-140.1706603938metric_daily——2026-09-09 11:172026-09-09 11:17