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 = PANW×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_1dPANW2016-09-010.0562438988metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-010.4348612716metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-01-0.0395143627metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dPANW2016-09-01-0.2732251731metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dPANW2016-09-01264027558.1238100000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-0123.4433333333metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dPANW2016-09-020.0321342244metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-020.4443783093metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-02-0.0080406240metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dPANW2016-09-02-0.2498708277metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dPANW2016-09-02276090013.9085710000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-0224.1966666667metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dPANW2016-09-06-0.0014464802metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-060.4448877584metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-06-0.0088422728metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dPANW2016-09-06-0.2509558748metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dPANW2016-09-06279880206.7000000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-0624.1616666667metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dPANW2016-09-070.0162792302metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-070.4320994213metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-070.0079842368metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dPANW2016-09-07-0.2387620130metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dPANW2016-09-07287926664.9242860000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-0724.5550000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dPANW2016-09-08-0.0023756194metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-080.4309166395metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-080.0064155740metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dPANW2016-09-08-0.2405704247metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dPANW2016-09-08291575721.6671430000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-0824.4966666667metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dPANW2016-09-09-0.0174853722metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-090.4008097914metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-09-0.0102463932metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dPANW2016-09-09-0.2538493335metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dPANW2016-09-09288995150.4852380000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-0924.0683333333metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dPANW2016-09-120.0189737553metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-120.4025580832metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-120.0097682988metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dPANW2016-09-12-0.2396920533metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dPANW2016-09-12294410212.5557140000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-1224.5250000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dPANW2016-09-13-0.0006116208metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-130.4030396057metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaPANW2016-09-130.0103692355metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dPANW2016-09-13-0.2401570735metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dPANW2016-09-13298724231.3976190000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-1324.5100000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dPANW2016-09-140.0086359309metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dPANW2016-09-140.3945232086metric_daily——2026-09-09 11:172026-09-09 11:17