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 = 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_252dSOXX2026-07-09-0.1119219554metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-07-08-0.1419520313metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-07-07-0.1577380498metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-07-06-0.1122120273metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-07-02-0.1354025129metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-07-01-0.0844414589metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-30-0.0217553930metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-29-0.0620753882metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-26-0.0993419948metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-25-0.0455107556metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-24-0.0816934093metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-23-0.0788079571metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-220.0000000000metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-180.0000000000metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-17-0.0456997374metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dSOXX2026-06-16-0.0592091654metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-150.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-12-0.0315586019metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-11-0.0466963358metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-10-0.1204684252metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-09-0.0869607588metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-08-0.0718392672metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-05-0.1232945686metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-04-0.0210498960metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-030.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-020.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-06-010.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-29-0.0017716501metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-28-0.0010875476metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-27-0.0107176060metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-260.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-220.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-21-0.0151099932metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-20-0.0233688715metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-19-0.0676101809metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-18-0.0692431864metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-15-0.0454989113metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-14-0.0051242586metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-13-0.0083902695metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-12-0.0314775884metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-110.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-080.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-07-0.0286266696metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-060.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-050.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-04-0.0079227053metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-05-010.0000000000metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-04-30-0.0003466205metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-04-29-0.0251516464metric_daily——2026-09-13 12:182026-09-13 12:18
drawdown_252dSOXX2026-04-28-0.0495883882metric_daily——2026-09-13 12:182026-09-13 12:18