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 = XLY×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_21dXLY2016-09-010.0709030700metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-020.0712099574metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-060.0607830727metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-070.0598378284metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-080.0661243519metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-090.1047947060metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-120.1112027841metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-130.1195437358metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-140.1189287531metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-150.1225354395metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-160.1225240871metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-190.1225103901metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-200.1225454976metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-210.1286051542metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-220.1302006120metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-230.1295628296metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-260.1341163346metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-270.1395595812metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-280.1393264772metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-290.1391537504metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-09-300.1420889526metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-030.1418962754metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-040.1420983972metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-050.1427891908metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-060.1428113463metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-070.1404876069metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-100.1101437709metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-110.1086599191metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-120.0970025925metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-130.0981757535metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-140.0951942130metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-170.0992892042metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-180.1019890125metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-190.1030332766metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-200.0975277541metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-210.0981925995metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-240.1010115724metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-250.1019989992metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-260.0965049863metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-270.0995489223metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-280.0985214300metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-10-310.0933576609metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-11-010.0955234168metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-11-020.0966189609metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-11-030.0943872145metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-11-040.0938945329metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-11-070.1273549590metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-11-080.1282017638metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-11-090.1213367774metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dXLY2016-11-100.1208996521metric_daily——2026-09-09 11:172026-09-09 11:17