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 | STX | 2016-09-01 | 77125069.2681163000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-02 | 75648436.1850002000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-06 | 75224240.8370209000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-07 | 80756419.1945405000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-08 | 82855120.3030464000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-09 | 87138669.5435433000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-12 | 91874350.0315010000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-13 | 94998834.5098935000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-14 | 95968991.3442879000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-15 | 97595015.1201964000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-16 | 104338295.8391370000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-19 | 107656672.5883760000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-20 | 107937400.6642880000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-21 | 109397540.9260920000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-22 | 109816990.3993340000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-23 | 109977407.3297570000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-26 | 113803166.8884550000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-27 | 115846212.4478980000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-28 | 117709485.2303930000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-29 | 119476022.8180690000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-09-30 | 118593348.3083380000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-03 | 118706646.6449760000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-04 | 120197057.8990150000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-05 | 118780439.2872410000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-06 | 112938496.0179710000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-07 | 111579726.3217380000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-10 | 108244501.3741040000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-11 | 117404942.0245860000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-12 | 117853327.3406360000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-13 | 121448433.6285740000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-14 | 122670032.6541770000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-17 | 117507983.2942880000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-18 | 118038372.9593400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-19 | 126153870.2174850000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-20 | 127652197.4849570000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-21 | 129588956.8486830000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-24 | 129932733.7518480000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-25 | 128068375.0724360000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-26 | 125932020.6586550000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-27 | 127352650.8617220000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-28 | 125895570.6513320000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-10-31 | 124587154.2913170000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-11-01 | 124548609.4264110000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-11-02 | 125839971.7960490000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-11-03 | 126615974.7340520000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-11-04 | 125422959.9640200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-11-07 | 126433046.7947310000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-11-08 | 123963174.9976700000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-11-09 | 114594478.4354100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | STX | 2016-11-10 | 115964381.0656670000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |