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 = IWM×metric_id = close_adj×

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_datedatevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
close_adjIWM2026-09-18284.1000000000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-17285.4300000000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-16283.9200000000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-15285.1400000000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-14287.1595640000metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-11288.1370096348metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-10286.9501113640metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-09289.8824482684metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-08293.9019440932metric_daily2026-09-18 18:302026-09-18 18:30
close_adjIWM2026-09-04296.0100000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-09-03295.1900000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-09-02294.0100000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-09-01290.5700000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-31293.9300000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-28295.7500000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-27299.8100000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-26298.9300000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-25299.2300000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-24297.9700000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-21299.9600000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-20297.6700000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-19301.7200000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-18300.2300000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-17304.0600000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-14305.0900000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-13303.5000000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-12302.7100000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-11300.9900000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-10299.9800000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-07301.5600000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-06298.2500000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-05299.7700000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-04301.7100000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-08-03296.2200000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-31291.2000000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-30292.5900000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-29288.5700000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-28293.3700000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-27292.9100000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-24291.1700000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-23292.0900000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-22293.7900000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-21296.5400000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-20292.3100000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-17294.0400000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-16295.5900000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-15295.7700000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-14294.5100000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-13293.4800000000metric_daily2026-09-15 12:152026-09-15 12:15
close_adjIWM2026-07-10295.9900000000metric_daily2026-09-15 12:152026-09-15 12:15