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 = STX×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_date ↓datevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
close_adjSTX2026-09-18858.7900000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-17803.1300000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-16783.1800000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-15771.8100000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-14805.5500000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-11830.1700000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-10862.3300000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-09885.9200000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-08904.3800000000metric_daily——2026-09-18 18:302026-09-18 18:30
close_adjSTX2026-09-04849.2800000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-09-03798.6100000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-09-02808.5400000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-09-01816.6400000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-31828.3800000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-28829.7600000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-27847.2000000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-26846.3700000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-25821.6700000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-24794.6500000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-21850.0000000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-20850.2400000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-19832.5600000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-18903.6800000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-17994.7900000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-14973.4400000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-13921.3700000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-12878.2100000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-11820.5200000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-10800.9900000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-07812.7600000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-06852.9500000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-05837.6600000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-04845.3500000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-08-03831.0600000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-31856.1300000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-30851.6800000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-29764.4300000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-28747.3000000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-27816.9900000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-24851.6900000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-23913.3600000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-22908.1000000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-21891.8300000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-20802.4500000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-17787.6600000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-16745.4900000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-15828.3000000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-14878.3100000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-13860.6600000000metric_daily——2026-09-15 12:152026-09-15 12:15
close_adjSTX2026-07-10910.3400000000metric_daily——2026-09-15 12:152026-09-15 12:15