Derived metrics
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.
696,350 rowsexport restricted — no row in this table may be redistributed
Sources in this table
metric_daily696,350 rowsrestricted — hover for the licence
as_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 | SMH | 2026-09-17 | -19821980.5265130000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SMH | 2026-09-16 | -389703810.2873960000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SMH | 2026-09-15 | -445274255.9981350000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SMH | 2026-09-14 | -492178794.1811430000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SMH | 2026-09-11 | 11834945.7144419000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SMH | 2026-09-10 | -162575538.2833250000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SMH | 2026-09-09 | 124881522.2074980000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SMH | 2026-09-08 | 134547390.4366470000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| net_gex | SMH | 2026-09-04 | -18123089.5743377000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-09-03 | -281388711.5526530000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-09-02 | -297087087.6487020000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-09-01 | -408014676.2566300000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-31 | -224082861.1562170000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-28 | -285656232.8197900000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-27 | 299308183.1246540000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-26 | -166078789.7722770000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-25 | -251746844.1723430000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-24 | -349703476.6273740000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-21 | -198315182.5617290000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-20 | -307730321.5832000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-19 | -350804901.0276170000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-18 | -227216222.4576990000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-17 | 156979737.1673230000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-14 | 69007886.6159267000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-13 | 166159411.9377330000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-12 | 113663334.8714760000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-11 | -125915154.6626190000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-10 | -162821015.0250700000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-07 | -13731682.7386703000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-06 | -80686069.4204839000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-05 | -94414655.5447839000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-04 | -104128835.7455550000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-08-03 | -364955376.9125620000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-31 | -383668645.7838910000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-30 | -1487535006.3249600000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-29 | -1636277655.4183500000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-28 | -1594181427.9456400000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-27 | -1647021821.7538600000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-24 | -904199069.2304030000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-23 | -850397680.6813000000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-22 | -647500936.6866390000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-21 | -696851435.1341050000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-20 | -904709348.4964510000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-17 | -765911539.0189830000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-16 | -1228817551.6596900000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-15 | -769921466.8732210000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-14 | -651620158.4290500000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-13 | -826563715.4208930000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-10 | -519438751.0497900000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |
| net_gex | SMH | 2026-07-09 | -719672860.6291960000 | metric_daily | — | — | 2026-09-15 12:17 | 2026-09-15 12:17 |