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_at |
|---|
| dollar_volume_21d | XLI | 2016-09-01 | 386157063.2413700000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-02 | 394521347.6646620000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-06 | 403249508.4636580000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-07 | 404852008.5449250000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-08 | 413465582.8760350000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-09 | 445991684.1533040000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-12 | 469997097.7956520000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-13 | 509496464.1532540000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-14 | 520101665.7685260000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-15 | 544855346.7552100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-16 | 561204381.2141180000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-19 | 558131487.9354510000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-20 | 556780497.9987400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-21 | 575930798.5099860000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-22 | 578173354.1617230000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-23 | 584178958.2803440000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-26 | 585988536.0039780000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-27 | 565174859.7122140000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-28 | 564429374.7892010000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-29 | 577384540.1117350000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-09-30 | 581225988.0584600000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-03 | 588786526.0059030000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-04 | 588018841.7736330000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-05 | 581854852.4123830000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-06 | 583651963.1886030000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-07 | 593664085.1154150000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-10 | 568979784.5907650000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-11 | 556556988.5357640000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-12 | 526113269.8771300000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-13 | 523318182.1566620000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-14 | 505056456.2917730000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-17 | 482815246.4705050000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-18 | 476556094.1214660000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-19 | 475242627.4629620000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-20 | 459329764.0664550000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-21 | 460013279.5965270000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-24 | 456205265.9286380000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-25 | 454207423.2773400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-26 | 461290253.0482240000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-27 | 462632013.8053460000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-28 | 462115911.3588990000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-10-31 | 457860739.3490590000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-11-01 | 473072542.4906890000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-11-02 | 479596136.4903100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-11-03 | 491364211.7285660000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-11-04 | 493003692.8136580000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-11-07 | 495834144.3769390000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-11-08 | 503943314.0927120000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-11-09 | 561177812.6949710000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | XLI | 2016-11-10 | 644061445.9168900000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |