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 = INTC×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_200dmaINTC2016-09-140.1107747433metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-14-0.0259775772metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-14524853562.6410740000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-1428.8633664282metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-150.0263896687metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-150.1730570212metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-150.1396176245metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-15-0.0002734482metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-15537362158.0105320000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-1529.6250611066metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-160.0303610503metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-160.1968816361metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-160.1735877636metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-160.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-16621141915.8043980000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-1630.5245090778metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-19-0.0135386249metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-190.2050425215metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-190.1571245339metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-19-0.0135386249metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-19643215607.2434480000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-1930.1112491991metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-20-0.0005382131metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-200.2046299515metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-200.1557931708metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-20-0.0140695514metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-20656427546.1080520000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-2030.0950429294metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-210.0083467959metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-210.2055939785metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-210.1648286927metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-21-0.0058401911metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-21666725203.8164560000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-2130.3462401105metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-220.0026702270metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-220.2055039925metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-220.1673171166metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-22-0.0031855588metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-22666357308.3235630000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-2230.4272714593metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-23-0.0095872170metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-230.2072239194metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-230.1555339567metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-23-0.0127422352metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-23670110545.5121730000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-2330.1355586037metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-26-0.0145200323metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-260.2153084469metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-260.1382787069metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-26-0.0270772498metric_daily——2026-09-09 11:172026-09-09 11:17