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

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_252dDE2026-09-18-0.0205908043metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-17-0.0182424789metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-16-0.0413820754metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-15-0.0205192090metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-14-0.0242135258metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-11-0.0324040265metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-10-0.0292538339metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-09-0.0302991251metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-08-0.0252588170metric_daily——2026-09-18 18:302026-09-18 18:30
drawdown_252dDE2026-09-04-0.0069304237metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-09-03-0.0056703467metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-09-020.0000000000metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-09-010.0000000000metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-31-0.0059805293metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-28-0.0432879434metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-27-0.0549294352metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-26-0.0368980243metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-25-0.0427870709metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-24-0.0154971073metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-21-0.0172729281metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-20-0.0575400435metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-19-0.1187223813metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-18-0.1064434155metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-17-0.0894441055metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-14-0.0758901914metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-13-0.0705323732metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-12-0.0593158642metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-11-0.0620782521metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-10-0.0752375394metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-07-0.0577070010metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-06-0.0667985962metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-05-0.0711091355metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-04-0.0629585735metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-08-03-0.0816426365metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-31-0.1004481231metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-30-0.0901271135metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-29-0.0727028208metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-28-0.0288537080metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-27-0.0513474377metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-24-0.0465815597metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-23-0.0741143707metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-22-0.0781972406metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-21-0.1092361592metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-20-0.1105718193metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-17-0.0935117975metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-16-0.0908860113metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-15-0.1052898909metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-14-0.1130002921metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-13-0.1111182257metric_daily——2026-09-15 12:152026-09-15 12:15
drawdown_252dDE2026-07-10-0.1092665151metric_daily——2026-09-15 12:152026-09-15 12:15