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_at |
|---|
| net_gex | SPCX | 2026-09-23 | -56115910.6977204000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | SPCX | 2026-09-22 | 68056846.4874316000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | SPCX | 2026-09-21 | 10326445.7072655000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | SPCX | 2026-09-18 | 25359962.5467783000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | SPCX | 2026-09-17 | 319388843.9105810000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | SPCX | 2026-09-16 | 191321131.0975740000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | SPCX | 2026-09-15 | 3663046.5012569800 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | SPCX | 2026-09-14 | 82183258.8134639000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| net_gex | SPCX | 2026-09-11 | 98022562.7927216000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| net_gex | SPCX | 2026-09-10 | 42066320.7982129000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SPCX | 2026-09-09 | -25670453.0822905000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SPCX | 2026-09-08 | 75863472.5693409000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SPCX | 2026-09-04 | 22198277.6789512000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-09-03 | 199428799.9927910000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-09-02 | 29508807.4294195000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-09-01 | 73852944.3724258000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-31 | 68502410.0327546000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-28 | 39377395.0130832000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-27 | 125737360.5033220000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-26 | 57271268.4103179000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-25 | 18541934.0332965000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-24 | -23542519.6053141000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-21 | -26053714.3504252000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-20 | -94225403.5768364000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-19 | -25574775.2929982000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-18 | 34277873.2132201000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-17 | 64399004.5460515000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-14 | 12899299.1599889000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-13 | 82843328.0037501000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-12 | 125471941.5074200000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-11 | 29014608.6818905000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-10 | 51236517.4187690000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-07 | 9860641.0532055900 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-06 | -100873460.4705150000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-05 | -104385680.9735430000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-04 | -15278261.3662523000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-08-03 | -41809865.8726518000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-31 | -52945605.8141549000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-30 | -63893652.6954369000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-29 | -62303531.9830531000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-28 | -54214405.3374068000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-27 | -61607821.5744277000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-24 | -61971164.2524237000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-23 | -84081804.2513979000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-22 | -84896270.5663023000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-21 | -67050033.5907452000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-20 | -77980444.2400816000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-17 | -74732210.7273677000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-16 | -116766629.8296450000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SPCX | 2026-07-15 | -116930853.3118800000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |