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 = ORCL×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_200dmaORCL2016-09-140.0348098292metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-14-0.0363897534metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-14366269751.0540880000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-1434.6677755006metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-150.0151552795metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-150.1285571959metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-150.0501773258metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-15-0.0217859708metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-15384484278.3237880000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-1535.1931753281metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-16-0.0474791973metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-160.2075325109metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-160.0002979034metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-16-0.0682307876metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-16448726885.5799820000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-1633.5222316145metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-190.0079650565metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-190.2107572603metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-190.0081393083metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-19-0.0608091932metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-19466170642.8488190000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-1933.7892380842metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-20-0.0040785113metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-200.2094770397metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-200.0038092909metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-20-0.0646396936metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-20470152092.7049510000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-2033.6514282934metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-210.0112618377metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-210.2148988140metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-210.0150099725metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-21-0.0541058176metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-21471340956.8896240000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-2134.0304052181metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-220.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-220.2127030946metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-220.0148621277metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-22-0.0541058176metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-22468929628.7616330000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-2234.0304052181metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-23-0.0070868135metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-230.2114283286metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-230.0075479506metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-23-0.0608091932metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-23474924800.1123270000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-2333.7892380842metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-26-0.0050981392metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-260.2114112415metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-260.0022965995metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-26-0.0655973186metric_daily——2026-09-09 11:172026-09-09 11:17