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 50 in a heap (the page LIMIT), under a 5s statement timeout.

metric_idtextentity_idtextas_of_datedatevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
ret_1dSNDK2025-02-24metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-02-24metric_daily2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-02-24metric_daily2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-02-24metric_daily2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-02-24metric_daily2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-02-2448.6000000000metric_daily2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-02-25-0.0090534979metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-02-25metric_daily2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-02-25metric_daily2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-02-25metric_daily2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-02-25metric_daily2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-02-2548.1600000000metric_daily2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-02-26-0.0328073090metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-02-26metric_daily2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-02-26metric_daily2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-02-26metric_daily2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-02-26metric_daily2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-02-2646.5800000000metric_daily2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-02-27-0.0304851868metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-02-27metric_daily2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-02-27metric_daily2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-02-27metric_daily2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-02-27metric_daily2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-02-2745.1600000000metric_daily2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-02-280.0374224978metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-02-28metric_daily2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-02-28metric_daily2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-02-28metric_daily2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-02-28metric_daily2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-02-2846.8500000000metric_daily2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-030.0738527215metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-03metric_daily2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-03metric_daily2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-03metric_daily2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-03metric_daily2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-0350.3100000000metric_daily2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-04-0.0322003578metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-04metric_daily2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-04metric_daily2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-04metric_daily2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-04metric_daily2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-0448.6900000000metric_daily2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-05-0.0045183816metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-05metric_daily2026-09-09 11:172026-09-09 11:17
px_vs_200dmaSNDK2025-03-05metric_daily2026-09-09 11:172026-09-09 11:17
drawdown_252dSNDK2025-03-05metric_daily2026-09-09 11:172026-09-09 11:17
dollar_volume_21dSNDK2025-03-05metric_daily2026-09-09 11:172026-09-09 11:17
close_adjSNDK2025-03-0548.4700000000metric_daily2026-09-09 11:172026-09-09 11:17
ret_1dSNDK2025-03-06-0.0406436971metric_daily2026-09-09 11:172026-09-09 11:17
realized_vol_21dSNDK2025-03-06metric_daily2026-09-09 11:172026-09-09 11:17