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 = XLP×metric_id = realized_vol_21d×

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_21dXLP2026-09-180.1338063747metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-170.1393430028metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-160.1449068083metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-150.1542644560metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-140.1523661891metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-110.1506378637metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-100.1510977061metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-090.1511982498metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-080.1463752669metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dXLP2026-09-040.1447223870metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-09-030.1422828952metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-09-020.1418356210metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-09-010.1429101902metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-310.1427462365metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-280.1424758190metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-270.1599103778metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-260.1538534940metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-250.1687449384metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-240.1700498250metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-210.1645823630metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-200.1712748485metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-190.1629664493metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-180.1630448285metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-170.1593381730metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-140.1505693532metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-130.1788521783metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-120.1756088718metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-110.1823208756metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-100.1828809671metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-070.1861692863metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-060.1935350899metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-050.1943933555metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-040.1966741368metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-08-030.1994270554metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-310.2111611442metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-300.2100902607metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-290.2024415865metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-280.2032955245metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-270.1941559533metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-240.1887916240metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-230.1871459838metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-220.1912402720metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-210.1929297115metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-200.1903814916metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-170.2064497511metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-160.2046975570metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-150.1790515766metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-140.1808202819metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-130.1745799656metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dXLP2026-07-100.1829951763metric_daily——2026-09-15 12:152026-09-15 12:15