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 150 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
dollar_volume_21dORCL2016-09-26477922240.9015970000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-2633.6169758457metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-270.0069177556metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-270.2127957683metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-270.0090298218metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-27-0.0591333493metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-27479463471.6081130000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-2733.8495298677metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-280.0035623410metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-280.2134293215metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-280.0122792152metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-28-0.0557816615metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-28477037409.7210600000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-2833.9701134347metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-29-0.0081135903metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-290.2142648593metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-290.0038211380metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-29-0.0634426622metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-29479558984.0423380000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-2933.6944938530metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-09-300.0040899796metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-09-300.2154810653metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-09-300.0077318820metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-09-30-0.0596121618metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-09-30483890132.6200440000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-3033.8323036438metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-10-03-0.0073828921metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-10-030.2161988484metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-10-030.0002245251metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-10-03-0.0665549437metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-10-03482543500.9880000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-10-0333.5825233980metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-10-04-0.0030777122metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-10-040.2155333762metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-10-04-0.0031559540metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-10-04-0.0694278190metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-10-04481949812.2548000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-10-0433.4791660549metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-10-050.0072034988metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-10-050.2181148683metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-10-050.0036109565metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-10-05-0.0627244434metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-10-05481171411.6343570000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-10-0533.7203331888metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dORCL2016-10-06-0.0071519796metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dORCL2016-10-060.2185326218metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaORCL2016-10-06-0.0039328404metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dORCL2016-10-06-0.0694278190metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dORCL2016-10-06479156186.9327450000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-10-0633.4791660549metric_daily——2026-09-09 11:172026-09-09 11:17