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 = XLP×metric_id = drawdown_252d×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 100 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_252dXLP2026-07-09-0.0640047399metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-07-08-0.0506173077metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-07-07-0.0453298345metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-07-06-0.0538797912metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-07-02-0.0438673419metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-07-01-0.0628797456metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-30-0.0654672325metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-29-0.0508423066metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-26-0.0470173260metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-25-0.0556797821metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-24-0.0500548106metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-23-0.0581547696metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-22-0.0754796818metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-18-0.0693393279metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-17-0.0650938170metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dXLP2026-06-16-0.0437545387metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-15-0.0449835024metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-12-0.0411848874metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-11-0.0473297058metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-10-0.0448717784metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-09-0.0604014103metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-08-0.0719089792metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-05-0.0677751923metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-04-0.0834165482metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-03-0.0820758605metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-02-0.0857627515metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-06-01-0.0835282721metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-29-0.0736965628metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-28-0.0567145193metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-27-0.0550386597metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-26-0.0656524369metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-22-0.0525807324metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-21-0.0541448680metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-20-0.0445366065metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-19-0.0381683402metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-18-0.0402910957metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-15-0.0543683159metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-14-0.0505697009metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-13-0.0534745241metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-12-0.0566027953metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-11-0.0685572601metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-08-0.0595076185metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-07-0.0617420979metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-06-0.0588372747metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-05-0.0608483062metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-04-0.0666579526metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-05-01-0.0596193425metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-04-30-0.0580552069metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-04-29-0.0735848388metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dXLP2026-04-28-0.0717972553metric_daily——2026-09-13 12:182026-09-13 12:18