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 = 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_adjSOXX2016-09-0133.1871463452metric_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_adjSOXX2016-09-0633.0782963754metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0732.8273367228metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0832.7698881276metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-0931.6057981729metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-1232.1954021759metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-1331.9111828104metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-1432.1923785657metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-1532.9361866926metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-1632.9452575234metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-1932.9845644569metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-2032.8364075536metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-2133.2899490944metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-2233.3987990642metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-2333.0571311035metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-2632.7313007209metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-2733.2960522918metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-2833.3628508647metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-2933.7727511984metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-09-3034.3071397816metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-0334.0763810752metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-0433.9883284110metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-0534.2373049100metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-0634.4377006287metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-0734.3860835496metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-1034.2130145198metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-1133.4964480105metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-1233.3841049561metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-1332.9893861162metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-1433.2383626152metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-1733.0652935854metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-1833.4478672302metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-1933.3081974869metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-2033.5419924920metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-2133.4569761265metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-2434.0703084777metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-2534.0399454900metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-2633.9913647097metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-2733.8334771738metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-2833.6300451563metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-10-3133.8122230824metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-11-0133.5116295044metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-11-0233.2899796943metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-11-0333.2322900177metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-11-0433.0227854027metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-11-0733.9518928257metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-11-0834.0217276974metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-11-0933.8608038627metric_daily——2026-09-09 11:172026-09-09 11:17
close_adjSOXX2016-11-1033.1290558596metric_daily——2026-09-09 11:172026-09-09 11:17