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 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_1dINTC2016-09-010.0036221789metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-010.0971689661metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-010.1272020710metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-010.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-01478188956.1534350000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-0129.1874918233metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-020.0016657413metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-020.0935680600metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-020.1283305678metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-020.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-02479642883.3187980000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-0229.2361106325metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-060.0135809313metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-060.0963692659metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-060.1428991230metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-060.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-06484106418.7457210000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-0629.6331642414metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-07-0.0030079300metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-070.0980044824metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-070.1389267306metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-07-0.0030079300metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-07483765496.8416400000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-0729.5440297578metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-08-0.0005485464metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-080.0965265801metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-080.1378340661metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-08-0.0035548264metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-08495439283.1771310000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-0829.5278234880metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-09-0.0274423710metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-090.1338500045metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-090.1062968425metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-09-0.0308996445metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-09509636136.5273270000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-0928.7175100004metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-120.0180586907metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-120.1457192139metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-120.1258243047metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-12-0.0133989609metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-12519475410.8936800000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-1229.2361106325metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-13-0.0130266075metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-130.1538364574metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaINTC2016-09-130.1108106806metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dINTC2016-09-13-0.0262510254metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dINTC2016-09-13530937538.7069740000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-1328.8552632933metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dINTC2016-09-140.0002808200metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dINTC2016-09-140.1508110981metric_daily——2026-09-09 11:172026-09-09 11:17