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_attimestamp with time zone |
|---|
| net_gex | XLY | 2026-06-17 | -83262098.8521831000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-06-18 | -46637863.1154156000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-06-22 | -48844969.4900396000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-06-23 | -59620211.6694391000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-06-24 | -58619132.0341796000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-06-25 | -58311703.6772980000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-06-26 | -50108626.6710099000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-06-29 | -40896467.2467056000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-06-30 | -44285492.5358520000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-01 | -36776801.2767546000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-02 | -38164881.7064655000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-06 | -40530496.5089880000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-07 | -38212078.8863253000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-08 | -51838032.1895182000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-09 | -38781832.9789445000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-10 | -47190641.6694993000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-13 | -57963805.8322022000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-14 | -58274939.5089135000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-15 | -61409499.4361419000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-16 | -57113889.2994996000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-17 | -50872484.5866746000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-20 | -52283940.2352956000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-21 | -51013395.8687963000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-22 | -64520782.2841162000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-23 | -70753805.8885372000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-24 | -66307462.0348789000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-27 | -66088018.0352743000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-28 | -61896959.8425391000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-29 | -66216523.1681228000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-30 | -46896113.7249700000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-07-31 | -47719019.1542838000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-03 | -36778429.1744789000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-04 | -30241588.1269455000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-05 | -30084415.0046176000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-06 | -36346119.4050137000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-07 | -26295735.7421279000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-10 | -32238446.2231476000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-11 | -34937003.8060059000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-12 | -49984084.3175326000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-13 | -40743561.7601573000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-14 | -53419630.9039690000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-17 | -53883903.1805692000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-18 | -56929234.0315195000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-19 | -32970620.3401391000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-20 | -89758497.3699543000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-21 | -69989030.1237344000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-24 | -65800394.1436440000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-25 | -73336858.5705616000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-26 | -77272284.1451896000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | XLY | 2026-08-27 | -92501596.6632278000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |