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 150 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
dollar_volume_21dSNDK2025-03-18—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-1856.4200000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-19-0.0015951790metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-19—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-19—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-19—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-19—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-1956.3300000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-20-0.0021303036metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-20—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-20—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-20—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-20—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-2056.2100000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-21-0.0400284647metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-21—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-21—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-21—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-21—metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-2153.9600000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-24-0.0179762787metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-24—metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-24—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-24—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-24320061933.4166670000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-2452.9900000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-25-0.0149084733metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-250.7527863892metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-25—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-25—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-25249380735.9880950000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-2552.2000000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-260.0080459770metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-260.7512548819metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-26—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-26—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-26233691032.9042860000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-2652.6200000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-270.0049410870metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-270.7384319911metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-27—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-27—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-27219157670.7404760000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-2752.8800000000metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-28-0.0739409985metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-280.7804121599metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-28—metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-28—metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-28207647394.7485710000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-2848.9700000000metric_daily——2026-09-09 11:172026-09-09 11:17