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:metric_id = close_adj×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
close_adjXOM2016-09-0156.3774498277metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-0136.3746751267metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLV2016-09-0161.3871637256metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-0117.8467154400metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-0141.5942087743metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLK2016-09-0121.2173066968metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-0149.3724923648metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLF2016-09-0116.5124162815metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-0122.7535000132metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-0130.7302350067metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-0122.2355721187metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-01185.1761323717metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0133.1871463452metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-0130.4358320165metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjQQQ2016-09-01108.7749135218metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-0123.4433333333metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-0135.4515686859metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjNVDA2016-09-011.5509827763metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMU2016-09-0116.2262840223metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMSFT2016-09-0151.1380427588metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMRVL2016-09-0111.9613269233metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjMETA2016-09-01125.0716797506metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjLMT2016-09-01187.1045687577metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjIWM2016-09-01108.7965445571metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjINTC2016-09-0129.1874918233metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjGOOG2016-09-0138.0783337325metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDIA2016-09-01152.3256122169metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjDE2016-09-0171.4134347619metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjCAT2016-09-0165.4057902496metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAVGO2016-09-0113.7665311231metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMZN2016-09-0138.5310000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAMD2016-09-017.3500000000metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjAAPL2016-09-0124.4076175747metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXOM2016-09-0256.7539919846metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLY2016-09-0236.4467755729metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLV2016-09-0261.4548359469metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLU2016-09-0218.0835542525metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLP2016-09-0241.9153405332metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLK2016-09-0221.3118258823metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLI2016-09-0249.6166605569metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLF2016-09-0216.5866748992metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjXLE2016-09-0223.0099806897metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjWDC2016-09-0231.1614667156metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSTX2016-09-0222.3740909601metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSPY2016-09-02186.0109079817metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0233.1538866322metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSMH2016-09-0230.4085026253metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjQQQ2016-09-02109.1289863943metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjPANW2016-09-0224.1966666667metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjORCL2016-09-0235.5290866932metric_daily——2026-09-09 11:172026-09-09 11:17