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.
Simplify Analyticsmetric_daily701,610 rowsrestricted — hover for the licenceas_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 | XOM | 2026-09-24 | -0.0131984705 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLY | 2026-09-24 | -0.0255620015 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLV | 2026-09-24 | -0.0110084182 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLU | 2026-09-24 | 0.0162601626 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLP | 2026-09-24 | -0.0452876377 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLK | 2026-09-24 | -0.0139181347 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLI | 2026-09-24 | 0.0069300480 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLF | 2026-09-24 | 0.0269576380 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLE | 2026-09-24 | -0.0415335463 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | WDC | 2026-09-24 | 0.0215185095 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | STX | 2026-09-24 | -0.0286117980 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | SPY | 2026-09-24 | -0.0093589510 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | SPCX | 2026-09-24 | 0.0133081132 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | SOXX | 2026-09-24 | -0.1167170138 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | SNDK | 2026-09-24 | -0.0305767498 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | SMH | 2026-09-24 | -0.0508226204 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | QQQ | 2026-09-24 | -0.0149777358 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | PLTR | 2026-09-24 | -0.0134482580 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | PANW | 2026-09-24 | -0.0767336890 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | ORCL | 2026-09-24 | 0.0032965458 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | NVDA | 2026-09-24 | -0.0203936237 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | MU | 2026-09-24 | -0.0097452176 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | MSFT | 2026-09-24 | 0.0041572109 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | MRVL | 2026-09-24 | -0.0345626569 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | META | 2026-09-24 | -0.0354814234 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | LMT | 2026-09-24 | -0.0070651136 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | IWM | 2026-09-24 | -0.0058936306 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | INTC | 2026-09-24 | -0.0580108329 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | GOOG | 2026-09-24 | 0.0029202678 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | DIA | 2026-09-24 | -0.0052274323 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | DELL | 2026-09-24 | 0.0074250961 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | DE | 2026-09-24 | -0.0646674533 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | CRWD | 2026-09-24 | -0.0372395733 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | CRSR | 2026-09-24 | -0.0774907749 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | CAT | 2026-09-24 | -0.0065197144 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | AVGO | 2026-09-24 | -0.0010275146 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | AMZN | 2026-09-24 | 0.0024861657 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | AMD | 2026-09-24 | -0.0464990624 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | AAPL | 2026-09-24 | -0.0027387473 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XOM | 2026-09-23 | -0.1006636482 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLY | 2026-09-23 | -0.0284681428 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLV | 2026-09-23 | -0.0047393365 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLU | 2026-09-23 | 0.0062893082 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLP | 2026-09-23 | -0.0537425695 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLK | 2026-09-23 | -0.0529333470 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLI | 2026-09-23 | -0.0005878895 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLF | 2026-09-23 | 0.0267693436 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | XLE | 2026-09-23 | -0.0379990380 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | WDC | 2026-09-23 | -0.1133441702 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| put_wall_distance_pct | STX | 2026-09-23 | -0.1124196307 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |