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 = META×source = metric_daily×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_1dMETA2016-09-010.0003964478metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-010.0986121957metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-010.1237291026metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMETA2016-09-01-0.0029239766metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMETA2016-09-011835737681.2329500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-01125.0716797506metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMETA2016-09-020.0026947769metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-020.0854081950metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-020.1256855350metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMETA2016-09-02-0.0002370792metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMETA2016-09-021784444374.0743400000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-02125.4087200226metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMETA2016-09-060.0254525334metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-060.1197089568metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-060.1532103971metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMETA2016-09-060.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMETA2016-09-061826129069.2950500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-06128.6006896572metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMETA2016-09-070.0101749788metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-070.1231485115metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-070.1636621304metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMETA2016-09-070.0000000000metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMETA2016-09-071909208640.4842500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-07129.9091989484metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMETA2016-09-08-0.0059519267metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-080.1257296640metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-080.1555586701metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMETA2016-09-08-0.0059519267metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMETA2016-09-081889778877.6312700000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-08129.1359889127metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMETA2016-09-09-0.0243340754metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-090.1551384490metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-090.1264325235metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMETA2016-09-09-0.0301411675metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMETA2016-09-091989475211.5854200000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-09125.9935840240metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMETA2016-09-120.0125098348metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-120.1602266131metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-120.1393652968metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMETA2016-09-12-0.0180083937metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMETA2016-09-122049424939.1776500000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-12127.5697429429metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMETA2016-09-13-0.0115005051metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-130.1663806472metric_daily——2026-09-09 11:172026-09-09 11:17
px_vs_200dmaMETA2016-09-130.1251761819metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dMETA2016-09-13-0.0293017932metric_daily——2026-09-09 11:172026-09-09 11:17
dollar_volume_21dMETA2016-09-132085934066.4352000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-13126.1026264649metric_daily——2026-09-09 11:172026-09-09 11:17
ret_1dMETA2016-09-140.0044021696metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dMETA2016-09-140.1636236919metric_daily——2026-09-09 11:172026-09-09 11:17