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 = AVGO×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_1dAVGO2016-09-010.0037977554metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-010.1513120104metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-010.1997879713metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAVGO2016-09-01-0.0017474634metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAVGO2016-09-01297655201.2321980000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-0113.7665311231metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAVGO2016-09-02-0.0224744480metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-020.1677025907metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-020.1707528677metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAVGO2016-09-02-0.0241826381metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAVGO2016-09-02336998752.8841090000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-0213.4571359350metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAVGO2016-09-06-0.0116111143metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-060.1618526785metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-060.1553473448metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAVGO2016-09-06-0.0355129651metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAVGO2016-09-06343766161.4321300000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-0613.3008835912metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAVGO2016-09-07-0.0128579778metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-070.1641091597metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-070.1387664799metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAVGO2016-09-07-0.0479143179metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAVGO2016-09-07351528494.9855630000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-0713.1298611254metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAVGO2016-09-08-0.0030787448metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-080.1529151055metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-080.1336104021metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAVGO2016-09-08-0.0508455468metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAVGO2016-09-08342422736.9954370000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-0813.0894376335metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAVGO2016-09-09-0.0451360019metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-090.2156235330metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-090.0810772534metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAVGO2016-09-09-0.0936865840metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAVGO2016-09-09356799446.4294700000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-0912.4986327516metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAVGO2016-09-120.0230128125metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-120.2335319940metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-120.1045685998metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAVGO2016-09-12-0.0728297632metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAVGO2016-09-12368489270.1070120000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-1212.7862614441metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAVGO2016-09-130.0046206226metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-130.2342343339metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAVGO2016-09-130.1082557892metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAVGO2016-09-13-0.0685456595metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAVGO2016-09-13379958172.2752780000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-1312.8453419323metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAVGO2016-09-140.0264463810metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAVGO2016-09-140.2450758233metric_daily——2026-09-09 11:172026-09-09 11:17