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 = sector_corr_63d×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_datedatevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
sector_corr_63dUS2016-09-01metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-02metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-06metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-07metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-08metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-09metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-12metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-13metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-14metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-15metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-16metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-19metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-20metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-21metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-22metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-23metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-26metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-27metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-28metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-29metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-09-30metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-03metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-04metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-05metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-06metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-07metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-10metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-11metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-12metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-13metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-14metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-17metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-18metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-19metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-20metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-21metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-24metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-25metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-26metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-27metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-28metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-10-31metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-11-01metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-11-02metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-11-03metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-11-04metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-11-07metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-11-08metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-11-09metric_daily2026-09-16 22:442026-09-16 22:44
sector_corr_63dUS2016-11-10metric_daily2026-09-16 22:442026-09-16 22:44