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 = AMZN×sorted by as_of_date ↑×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 100 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
px_vs_200dmaAMZN2016-09-140.1472458352metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-14-0.0352149277metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-141732990720.7595200000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-1438.0545000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-150.0112995835metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-150.1710612310metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-150.1592927665metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-15-0.0243132582metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-151786163525.4271400000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-1538.4845000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-160.0114721511metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-160.1753123608metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-160.1717147059metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-16-0.0131200325metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-161921173960.8347600000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-1638.9260000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-19-0.0043929507metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-190.1762463935metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-190.1656981842metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-19-0.0174553475metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-191952857568.3328600000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-1938.7550000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-200.0066055993metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-200.1734042446metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-200.1723935592metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-20-0.0109650513metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-201940326962.7904800000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-2039.0110000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-210.0122016867metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-210.1773178018metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-210.1856556000metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-210.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-211981834789.6038100000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-2139.4870000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-220.0189429432metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-220.1868330845metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-220.2068935263metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-220.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-222082797894.1776200000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-2240.2350000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-230.0013048341metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-230.1837451838metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-230.2073056564metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-230.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-232110208201.9157100000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-2340.2875000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-26-0.0081787155metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-260.1878078881metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-260.1962272350metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-26-0.0081787155metric_daily——2026-09-09 11:172026-09-09 11:17