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 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_1dAMZN2016-09-010.0018981746metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-010.0828189457metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-010.1690854851metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-01-0.0025111318metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-011495849713.0471400000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-0138.5310000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-020.0023617347metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-020.0788971656metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-020.1706997691metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-02-0.0001553277metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-021460964861.2528600000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-0238.6220000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-060.0212702605metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-060.1046028159metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-060.1944664227metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-060.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-061502056277.5090500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-0639.4435000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-07-0.0055649220metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-070.1073664930metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-070.1867123554metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-07-0.0055649220metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-071520126315.7109500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-0739.2240000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-08-0.0005353865metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-080.1074265945metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-080.1850407610metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-08-0.0060973291metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-081527298838.4942900000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-0839.2030000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-09-0.0305078693metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-090.1531794243metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-090.1481835607metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-09-0.0364191819metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-091622688935.2257100000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-0938.0070000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-120.0149314600metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-120.1618013343metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-120.1644451864metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-12-0.0220315134metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-121663306726.2428600000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-1238.5745000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-13-0.0135841035metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-130.1683821665metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMZN2016-09-130.1478851023metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMZN2016-09-13-0.0353163386metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMZN2016-09-131718758234.9171400000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-1338.0505000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMZN2016-09-140.0001051235metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMZN2016-09-140.1675573742metric_daily——2026-09-09 11:172026-09-09 11:17