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 | DIA | 2016-09-01 | 356852409.2425460000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-02 | 359112674.2076760000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-06 | 344368957.1190160000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-07 | 342431706.3869620000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-08 | 344814936.6615660000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-09 | 391804928.3929290000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-12 | 426755209.8150710000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-13 | 461667036.3622580000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-14 | 471488935.0289070000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-15 | 488343543.5914090000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-16 | 487093854.3854780000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-19 | 484428473.3494210000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-20 | 481413442.6675270000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-21 | 490841678.2084370000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-22 | 495655013.4013130000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-23 | 494497117.5376180000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-26 | 498550334.1499180000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-27 | 500608415.4071920000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-28 | 530725283.7809420000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-29 | 541309794.7563660000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-09-30 | 560780460.2651600000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-03 | 553298097.2678980000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-04 | 554115979.2761570000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-05 | 551510936.4316120000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-06 | 555405139.0891990000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-07 | 557350659.5458450000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-10 | 512181880.1658360000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-11 | 489476053.9991910000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-12 | 449957907.7445580000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-13 | 453401010.4255210000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-14 | 444084551.8250430000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-17 | 436618933.9309610000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-18 | 432789643.0590220000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-19 | 429315124.7128450000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-20 | 413802186.2344860000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-21 | 437112803.9011910000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-24 | 438274332.3525200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-25 | 443470253.7063530000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-26 | 455372787.9583240000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-27 | 423559300.8996390000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-28 | 426111637.5379890000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-10-31 | 403177154.6661750000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-11-01 | 414652674.3799040000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-11-02 | 419691790.7750300000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-11-03 | 420502448.9859850000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-11-04 | 434070460.1796420000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-11-07 | 440405752.5039340000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-11-08 | 451731331.7364760000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-11-09 | 484938883.1987250000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | DIA | 2016-11-10 | 536225662.3075710000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |