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 = SNDK×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_200dmaSNDK2025-03-06—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-06—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-06—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-0646.5000000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-070.0967741935metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-07—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-07—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-07—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-07—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-0751.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-100.0392156863metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-10—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-10—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-10—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-10—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-1053.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-11-0.0158490566metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-11—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-11—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-11—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-11—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-1152.1600000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-12-0.0329754601metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-12—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-12—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-12—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-12—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-1250.4400000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-13-0.0396510706metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-13—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-13—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-13—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-13—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-1348.4400000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-140.1317093311metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-14—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-14—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-14—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-14—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-1454.8200000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-170.0151404597metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-17—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-17—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-17—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-17—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-1755.6500000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-180.0138364780metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-18—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-18—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-18—metric_daily——2026-09-09 11:172026-09-09 11:17