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×metric_id = realized_vol_21d×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
realized_vol_21dSPY2016-09-010.0515050850metric_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
realized_vol_21dSPY2016-09-060.0466554858metric_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
realized_vol_21dSPY2016-09-080.0473445374metric_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
realized_vol_21dSPY2016-09-120.1079098936metric_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
realized_vol_21dSPY2016-09-140.1173156899metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-150.1226282959metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-160.1228023171metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-190.1223587016metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-200.1223879633metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-210.1293847747metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-220.1312001276metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-230.1313809555metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-260.1342528188metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-270.1361068108metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-280.1361251296metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-290.1395543091metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-09-300.1419331578metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-030.1421856182metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-040.1421775818metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-050.1427016852metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-060.1427537643metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-070.1429964286metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-100.1158315551metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-110.1140668678metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-120.1021358282metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-130.1028926728metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-140.0966062172metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-170.0964288835metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-180.0990014548metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-190.0994038767metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-200.0910929857metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-210.0878580909metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-240.0876443072metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-250.0837236863metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-260.0808324054metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-270.0787557235metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-280.0733149871metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-10-310.0673473282metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-11-010.0707792960metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-11-020.0715101981metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-11-030.0695209255metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-11-040.0690743055metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-11-070.1067663105metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-11-080.1063271138metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-11-090.1031566477metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSPY2016-11-100.1033302407metric_daily——2026-09-09 11:172026-09-09 11:17