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×

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_21dSOXX2026-09-180.3651415781metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-170.3615837131metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-160.3758734078metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-150.3807760627metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-140.3799565463metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-110.3317434375metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-100.3356247670metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-090.3234697920metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-080.3346610995metric_daily——2026-09-18 18:302026-09-18 18:30
realized_vol_21dSOXX2026-09-040.3373853745metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-09-030.3115276414metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-09-020.3177892454metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-09-010.4030591163metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-310.3963912219metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-280.3961391508metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-270.4742053084metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-260.5147283405metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-250.5439232299metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-240.5455376014metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-210.5587661051metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-200.5590480437metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-190.5590418520metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-180.5871909495metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-170.5572518655metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-140.5597160751metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-130.5829100821metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-120.5873373482metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-110.5887761770metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-100.6089703455metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-070.6038313304metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-060.6129750214metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-050.6169238289metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-040.6376906867metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-08-030.5947635837metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-310.6190057432metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-300.6482525313metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-290.5833105948metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-280.5915404425metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-270.5993749496metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-240.6197193544metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-230.6037674371metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-220.6576910966metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-210.6654688884metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-200.6800362459metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-170.6827236752metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-160.7073631414metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-150.7242293908metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-140.7230694321metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-130.7757763652metric_daily——2026-09-15 12:152026-09-15 12:15
realized_vol_21dSOXX2026-07-100.7677512296metric_daily——2026-09-15 12:152026-09-15 12:15