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
metric_daily696,350 rowsrestricted — hover for the licence
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_idtext | entity_idtext | as_of_date ↓date | valuenumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|
| put_wall_distance_pct | IWM | 2026-09-17 | -0.0015064990 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | IWM | 2026-09-16 | 0.0038038884 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | IWM | 2026-09-15 | -0.0004909869 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | IWM | 2026-09-14 | -0.0101073252 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | IWM | 2026-09-11 | -0.0134653328 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | IWM | 2026-09-10 | 0.0079944387 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | IWM | 2026-09-09 | -0.0022020369 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | IWM | 2026-09-08 | -0.0158482370 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| put_wall_distance_pct | IWM | 2026-09-04 | -0.0203033681 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-09-03 | -0.0175818964 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-09-02 | -0.0136389919 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-09-01 | -0.0019616616 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-31 | -0.0133705304 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-28 | -0.0025359256 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-27 | -0.0160434942 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-26 | -0.0131468906 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-25 | -0.0141362831 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-24 | -0.0099674464 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-21 | -0.0165355381 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-20 | -0.0089696644 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-19 | -0.0222723054 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-18 | -0.0174199780 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-17 | -0.0297967506 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-14 | -0.0330722082 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-13 | -0.0280065898 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-12 | -0.0254699217 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-11 | -0.0199009934 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-10 | -0.0166011067 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-07 | -0.0217535482 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-06 | -0.0108968986 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-05 | -0.0159121994 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-04 | -0.0553843094 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-08-03 | -0.0378772534 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-31 | -0.0212912088 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-30 | -0.0088519772 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-29 | -0.0123713484 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-28 | -0.0285305246 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-27 | -0.0099347923 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-24 | -0.0211903699 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-23 | -0.0071553288 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-22 | -0.0129003710 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-21 | -0.0220543603 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-20 | -0.0079025692 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-17 | -0.0307441164 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-16 | -0.0189113299 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-15 | -0.0195084018 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-14 | -0.0153135717 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-13 | -0.0118577075 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-10 | -0.0202371702 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| put_wall_distance_pct | IWM | 2026-07-09 | -0.0243574216 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |