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 = ORCL×source = metric_daily×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_1dORCL2016-09-01-0.0014556041metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-010.0674808693metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-010.0605165744metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-01-0.0146037826metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-01335379684.4199570000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-0135.4515686859metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-020.0021865889metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-020.0660986436metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-020.0623487778metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-02-0.0124491262metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-02335305102.0154620000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-0235.5290866932metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-060.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-060.0633268129metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-060.0619395308metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-06-0.0124491262metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-06333141168.8923340000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-0635.5290866932metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-070.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-070.0632925917metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-070.0615738086metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-07-0.0124491262metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-07331470375.3865130000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-0735.5290866932metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-08-0.0128484848metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-080.0775461972metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-080.0476874763metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-08-0.0251376586metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-08343343472.1879460000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-0835.0725917611metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-09-0.0169449902metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-090.0963423263metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-090.0297571995metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-09-0.0416566914metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-09348444244.9420870000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-0934.4782870383metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-120.0162378216metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-120.1123056830metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-120.0462532809metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-12-0.0260952837metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-12357310204.1442740000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-1235.0381393134metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-13-0.0122910521metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-130.1186728255metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-130.0332118103metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-13-0.0380655973metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-13368764917.2415720000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-1334.6074837171metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-140.0017421603metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-140.1152636858metric_daily——2026-09-09 11:172026-09-09 11:17