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 = LMT×metric_id = drawdown_252d×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
drawdown_252dLMT2016-09-01-0.0796753174metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-02-0.0807708970metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-06-0.0819798125metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-07-0.0881377257metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-08-0.0871554819metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-09-0.1010957884metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-12-0.0978468281metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-13-0.1030980547metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-14-0.1030980547metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-15-0.0967512484metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-16-0.1029469402metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-19-0.0899888775metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-20-0.0915000218metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-21-0.0788819666metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-22-0.0683039562metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-23-0.0712506877metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-26-0.0724218245metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-27-0.0714395807metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-28-0.0715906951metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-29-0.0844732007metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-09-30-0.0943711961metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-03-0.0911222358metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-04-0.1042691915metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-05-0.1061581220metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-06-0.1132605004metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-07-0.1177561548metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-10-0.1186628414metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-11-0.1241029610metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-12-0.1231584958metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-13-0.1197961996metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-14-0.1213829012metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-17-0.1206273290metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-18-0.1205517718metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-19-0.1222895878metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-20-0.1241785182metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-21-0.1291275159metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-24-0.1229318241metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-25-0.0583304035metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-26-0.0551947790metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-27-0.0610882420metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-28-0.0630905082metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-10-31-0.0692106428metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-11-01-0.0744996480metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-11-02-0.0740085261metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-11-03-0.0982246142metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-11-04-0.1073670374metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-11-07-0.0960712335metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-11-08-0.0963734623metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-11-09-0.0424633880metric_daily——2026-09-09 11:172026-09-09 11:17
drawdown_252dLMT2016-11-10-0.0280697381metric_daily——2026-09-09 11:172026-09-09 11:17