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 = SOXX×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_1dSOXX2016-09-010.0078971534metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-010.0973328804metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-010.2025169863metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSOXX2016-09-010.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSOXX2016-09-0140354012.4275366000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0133.1871463452metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSOXX2016-09-02-0.0010021866metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-020.0957201814metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-020.1998905121metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSOXX2016-09-02-0.0010021866metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSOXX2016-09-0241164726.0107955000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0233.1538866322metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSOXX2016-09-06-0.0022799818metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-060.0899010156metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-060.1958134191metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSOXX2016-09-06-0.0032798834metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSOXX2016-09-0641003160.5142166000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0633.0782963754metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSOXX2016-09-07-0.0075868373metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-070.0953642159metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-070.1854799635metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSOXX2016-09-07-0.0108418367metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSOXX2016-09-0745916107.7558345000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0732.8273367228metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSOXX2016-09-08-0.0017500230metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-080.0931209472metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-080.1821800039metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSOXX2016-09-08-0.0125728863metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSOXX2016-09-0846312479.8031519000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0832.7698881276metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSOXX2016-09-09-0.0355231593metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-090.1561807252metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-090.1391783403metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSOXX2016-09-09-0.0476494169metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSOXX2016-09-0946449179.5793721000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0931.6057981729metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSOXX2016-09-120.0186549316metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-120.1688412295metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-120.1593484116metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSOXX2016-09-12-0.0298833819metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSOXX2016-09-1248052470.5405787000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-1232.1954021759metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSOXX2016-09-13-0.0088279489metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-130.1711907174metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSOXX2016-09-130.1481108092metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSOXX2016-09-13-0.0384475219metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSOXX2016-09-1349003195.4370734000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-1331.9111828104metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSOXX2016-09-140.0088118249metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-140.1671208583metric_daily——2026-09-09 11:172026-09-09 11:17