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_daily700,356 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 | AAPL | 2026-06-17 | 883409111.3298890000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-06-18 | 675514473.8541250000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-06-22 | 675808880.6748980000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-06-23 | 488508784.3442510000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-06-24 | 466485713.8146450000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-06-25 | 68673817.5601774000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-06-26 | 378609113.2079040000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-06-29 | 337109374.0719130000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-06-30 | 685875113.0222250000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-01 | 951887688.4728670000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-02 | 1064302630.3453600000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-06 | 1175955360.4994700000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-07 | 1134646783.1208700000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-08 | 1200900764.7450900000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-09 | 1423473803.1525500000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-10 | 1156412206.8864700000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-13 | 1356812090.0998700000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-14 | 1198266158.7372100000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-15 | 1498254068.8375700000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-16 | 1343214888.8688500000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-17 | 721999643.1195300000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-20 | 555312432.2492110000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-21 | 701868559.9352650000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-22 | 694485668.7085550000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-23 | 539891122.5120530000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-24 | 822078015.6595460000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-27 | 858852002.7613370000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-28 | 969790415.3499170000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-29 | 737260721.5194280000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-30 | 558724645.6393630000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-07-31 | 133496534.1116610000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-03 | 239859669.5164310000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-04 | 706341360.5885240000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-05 | 751857409.9684860000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-06 | 1009126648.2860300000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-07 | 817781216.4853640000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-10 | 481374744.1297120000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-11 | 314183405.4363180000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-12 | 214580701.8842890000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-13 | 579752812.0631260000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-14 | 496331377.0132420000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-17 | 483634080.1589330000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-18 | 846475563.4811890000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-19 | 958027490.6634610000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-20 | 711222449.7732840000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-21 | 479314749.9614600000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-24 | 585999936.3125650000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-25 | 657420491.6515110000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-26 | 820885817.8680100000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | AAPL | 2026-08-27 | 946792971.0297740000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |