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 = AMD×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_1dAMD2016-09-01-0.0067567568metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-010.4370949985metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-010.9758064516metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMD2016-09-01-0.0417209909metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMD2016-09-01183384860.4526190000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-017.3500000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMD2016-09-020.0217687075metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-020.4345648195metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-021.0039224581metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMD2016-09-02-0.0208604954metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMD2016-09-02183109799.5754760000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-027.5100000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMD2016-09-06-0.0226364847metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-060.4433548414metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-060.9450149056metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMD2016-09-06-0.0430247718metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMD2016-09-06185499153.1959520000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-067.3400000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMD2016-09-07-0.0681198910metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-070.5104305313metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-070.8013035750metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMD2016-09-07-0.1082138201metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMD2016-09-07197472967.1978570000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-076.8400000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMD2016-09-08-0.0899122807metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-080.6001009035metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-080.6307444447metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMD2016-09-08-0.1883963494metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMD2016-09-08219121689.9442860000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-086.2250000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMD2016-09-09-0.0522088353metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-090.6231616078metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-090.5381908008metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMD2016-09-09-0.2307692308metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMD2016-09-09258131992.5742860000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-095.9000000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMD2016-09-120.0067796610metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-120.6211116125metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-120.5413858200metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMD2016-09-12-0.2255541069metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMD2016-09-12276050290.1133330000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-125.9400000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMD2016-09-13-0.0336700337metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-130.6210730546metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaAMD2016-09-130.4830221097metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dAMD2016-09-13-0.2516297262metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dAMD2016-09-13281779584.7161900000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-135.7400000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dAMD2016-09-140.0522648084metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dAMD2016-09-140.6401699392metric_daily——2026-09-09 11:172026-09-09 11:17