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 = MRVL×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_1dMRVL2016-09-010.0379032258metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-010.2483776186metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMRVL2016-09-010.3171211709metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMRVL2016-09-010.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMRVL2016-09-0146265892.5922048000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-0111.9613269233metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMRVL2016-09-020.0108780109metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-020.2486066388metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMRVL2016-09-020.3282745652metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMRVL2016-09-020.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMRVL2016-09-0248756852.5759218000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-0212.0914423677metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMRVL2016-09-06-0.0053804766metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-060.2510342605metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMRVL2016-09-060.3180194624metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMRVL2016-09-06-0.0053804766metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMRVL2016-09-0660008934.1607622000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-0612.0263846455metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMRVL2016-09-07-0.0239567233metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-070.2713014547metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMRVL2016-09-070.2838121970metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMRVL2016-09-07-0.0292083013metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMRVL2016-09-0762223431.7682632000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-0711.7382718758metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMRVL2016-09-08-0.0063341251metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-080.2710337803metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMRVL2016-09-080.2730895256metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMRVL2016-09-08-0.0353574174metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMRVL2016-09-0863574563.6994846000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-0811.6639201933metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMRVL2016-09-09-0.0191235060metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-090.2784595598metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMRVL2016-09-090.2463330532metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMRVL2016-09-09-0.0538047656metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMRVL2016-09-0966061674.5851122000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-0911.4408651457metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMRVL2016-09-120.0186839968metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-120.2816708245metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMRVL2016-09-120.2669571043metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMRVL2016-09-12-0.0361260569metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMRVL2016-09-1268022512.6334418000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-1211.6546262329metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMRVL2016-09-13-0.0071770335metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-130.2838343879metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMRVL2016-09-130.2552577584metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMRVL2016-09-13-0.0430438125metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMRVL2016-09-1369177930.2116589000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-1311.5709805901metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMRVL2016-09-140.0008032129metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMRVL2016-09-140.2724954337metric_daily——2026-09-09 11:172026-09-09 11:17