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 100 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 |
|---|---|---|---|---|---|---|---|---|
| close_adj | MSFT | 2026-07-09 | 383.6378022341 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-07-08 | 382.6197187752 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-07-07 | 388.1093844851 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-07-06 | 386.0133303050 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-07-02 | 389.7562841981 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-07-01 | 383.5579525511 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-30 | 372.3191096612 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-29 | 367.8774710413 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-26 | 372.2692036093 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-25 | 352.1670459004 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-24 | 364.7733146125 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-23 | 373.2373810163 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-22 | 366.6497821643 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-18 | 378.6871218847 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-17 | 378.1980425760 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| close_adj | MSFT | 2026-06-16 | 393.0900084657 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-15 | 399.0088662220 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-12 | 390.0058144577 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-11 | 389.6065660424 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-10 | 396.6133757304 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-09 | 402.6520080114 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-08 | 410.9663562594 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-05 | 415.8870929776 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-04 | 427.2457103921 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-03 | 426.5370444550 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-02 | 440.4807953583 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-06-01 | 459.6547005017 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-29 | 449.3940162293 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-28 | 426.1877020916 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-27 | 411.8946088249 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-26 | 415.2482955132 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-22 | 417.7835229502 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-21 | 418.3025458900 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-20 | 419.3605541905 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-19 | 415.7352456424 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-18 | 421.8305446298 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-15 | 420.2170831332 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-14 | 407.7774941866 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-13 | 403.5745265842 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-12 | 406.1241941345 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-11 | 410.9944575411 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-08 | 413.4445287027 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-07 | 419.0717246633 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-06 | 412.2892105940 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-05 | 409.7196237659 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-04 | 411.9505828725 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-05-01 | 412.7672732597 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-04-30 | 406.1341537733 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-04-29 | 422.7468314057 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |
| close_adj | MSFT | 2026-04-28 | 427.5174984237 | metric_daily | — | — | 2026-09-13 12:18 | 2026-09-13 12:18 |