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_daily698,194 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 |
|---|
| net_gex | CAT | 2026-06-17 | 90162268.7671925000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-06-18 | 41588963.5806798000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-06-22 | 50272715.9435033000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-06-23 | 43544089.7433811000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-06-24 | 46324385.3245928000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-06-25 | 89126881.1251181000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-06-26 | 25932142.8438131000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-06-29 | 54073965.4879453000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-06-30 | 82707313.2190125000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-01 | 1804483.0523840300 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-02 | 2754494.3505228800 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-06 | 5237907.6730159000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-07 | -22447302.5667897000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-08 | -10853713.8684651000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-09 | -10709832.1771917000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-10 | 21510430.7856379000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-13 | 7108724.3994586600 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-14 | 3967594.5602572300 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-15 | -25131397.6823942000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-16 | -64290900.2563439000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-17 | -16114584.8441762000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-20 | -26307448.2976177000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-21 | -14086886.1155554000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-22 | -7727731.0780670600 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-23 | -8695394.2208629000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-24 | -10291604.3365284000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-27 | -29856570.4612203000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-28 | -43956401.9720968000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-29 | -61247279.5662953000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-30 | -64772412.6656362000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-07-31 | -23882985.1863919000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-03 | -16324277.0239564000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-04 | 52536125.0208618000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-05 | 40362877.9786604000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-06 | 18332555.8311990000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-07 | -8645560.4668136100 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-10 | -17607210.2331592000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-11 | -7447217.1182344900 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-12 | 14144893.7724214000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-13 | 33686222.2577432000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-14 | -15645837.2142812000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-17 | 20967678.7742875000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-18 | -44756639.6883299000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-19 | -90989686.2563102000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-20 | -107467684.2111170000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-21 | -19276808.7603496000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-24 | -35720579.5533484000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-25 | -46800200.4298247000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-26 | -21614809.2382091000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | CAT | 2026-08-27 | -27939738.9349478000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |