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 = STX×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_1dSTX2016-09-01-0.0008891523metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-010.2699779989metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSTX2016-09-010.1617462123metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSTX2016-09-01-0.2801712120metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSTX2016-09-0177125069.2681163000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-0122.2355721187metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSTX2016-09-020.0062296055metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-020.2661218933metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSTX2016-09-020.1686312555metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSTX2016-09-02-0.2756869626metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSTX2016-09-0275648436.1850002000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-0222.3740909601metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSTX2016-09-060.0162146226metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-060.2558765074metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSTX2016-09-060.1872071194metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSTX2016-09-06-0.2639425000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSTX2016-09-0675224240.8370209000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-0622.7368784020metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSTX2016-09-070.0591818973metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-070.3189689826metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSTX2016-09-070.2566115503metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSTX2016-09-07-0.2203812207metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSTX2016-09-0780756419.1945405000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-0724.0824900045metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSTX2016-09-08-0.0054779512metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-080.3196869750metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSTX2016-09-080.2489464792metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSTX2016-09-08-0.2107895553metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSTX2016-09-0882855120.3030464000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-0823.9505672984metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSTX2016-09-09-0.0060589369metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-090.2891150890metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSTX2016-09-090.2407091196metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSTX2016-09-09-0.2144541392metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSTX2016-09-0987138669.5435433000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-0923.8054523216metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSTX2016-09-120.0127459130metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-120.2893401256metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSTX2016-09-120.2556578981metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSTX2016-09-12-0.2044416400metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSTX2016-09-1291874350.0315010000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-1224.1088745457metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSTX2016-09-13-0.0112175103metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-130.2926459808metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSTX2016-09-130.2408662404metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSTX2016-09-13-0.2133658240metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSTX2016-09-1394998834.5098935000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-1323.8384329982metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSTX2016-09-14-0.0019369120metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSTX2016-09-140.2927149799metric_daily——2026-09-09 11:172026-09-09 11:17