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 = SPY×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_1dSPY2016-09-010.0000459748metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-010.0515050850metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-010.0645684061metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSPY2016-09-01-0.0077593547metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSPY2016-09-0112363568426.8648000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-01185.1761323717metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSPY2016-09-020.0045080087metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-020.0535158544metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-020.0689431012metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSPY2016-09-02-0.0032863253metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSPY2016-09-0212656992046.9269000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-02186.0109079817metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSPY2016-09-060.0030224116metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-060.0466554858metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-060.0718153540metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSPY2016-09-06-0.0002738464metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSPY2016-09-0612524515343.2484000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-06186.5731095026metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSPY2016-09-07-0.0000913300metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-070.0465811962metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-070.0713550878metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSPY2016-09-07-0.0003651513metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSPY2016-09-0712851639840.6576000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-07186.5560697889metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSPY2016-09-08-0.0022830008metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-080.0473445374metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-080.0685804781metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSPY2016-09-08-0.0026473185metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSPY2016-09-0813054863862.2120000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-08186.1301621270metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSPY2016-09-09-0.0239348136metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-090.0956423007metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-090.0428108592metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSPY2016-09-09-0.0265187690metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSPY2016-09-0914460368154.5143000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-09181.6751713912metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSPY2016-09-120.0143473228metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-120.1079098936metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-120.0575043835metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSPY2016-09-12-0.0125519195metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSPY2016-09-1215292553056.3578000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-12184.2817237263metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSPY2016-09-13-0.0143755203metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-130.1181730914metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSPY2016-09-130.0421166154metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSPY2016-09-13-0.0267469994metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSPY2016-09-1316330552359.0246000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-13181.6325780696metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSPY2016-09-14-0.0003751911metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-140.1173156899metric_daily——2026-09-09 11:172026-09-09 11:17