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 = SOXX×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_21dSOXX2016-09-010.0973328804metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-020.0957201814metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-060.0899010156metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-070.0953642159metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-080.0931209472metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-090.1561807252metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-120.1688412295metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-130.1711907174metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-140.1671208583metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-150.1836089047metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-160.1835734475metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-190.1822476513metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-200.1809118398metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-210.1869110969metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-220.1865564753metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-230.1878739290metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-260.1909164729metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-270.1995846734metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-280.1992949444metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-290.2030892141metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-09-300.2090714804metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-030.2100442945metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-040.2103381548metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-050.2109274722metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-060.2085759766metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-070.2085153338metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-100.1597287024metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-110.1718611003metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-120.1685523007metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-130.1734470447metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-140.1562337109metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-170.1574740028metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-180.1623106242metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-190.1621865786metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-200.1569032959metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-210.1568566826metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-240.1641255211metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-250.1591801994metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-260.1493508668metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-270.1505734931metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-280.1461248816metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-10-310.1358687177metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-11-010.1372860215metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-11-020.1386636689metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-11-030.1353618714metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-11-040.1337143180metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-11-070.1695984717metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-11-080.1690148722metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-11-090.1524801048metric_daily——2026-09-09 11:172026-09-09 11:17
realized_vol_21dSOXX2016-11-100.1704404069metric_daily——2026-09-09 11:172026-09-09 11:17