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 |
|---|---|---|---|---|---|---|---|---|
| dollar_volume_21d | SOXX | 2026-09-18 | 3652869686.6416100000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-17 | 3706333140.0199500000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-16 | 3795172012.5778400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-15 | 3752906838.9683300000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-14 | 3724534790.8060500000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-11 | 3622123447.8673700000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-10 | 3684201634.5518400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-09 | 3708062153.1017400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-08 | 3767461272.8844100000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | SOXX | 2026-09-04 | 3683810877.5452400000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-09-03 | 3649328019.3776200000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-09-02 | 3739037573.1347600000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-09-01 | 3881623490.7352400000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-31 | 3938903003.2490500000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-28 | 4102164805.4166700000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-27 | 4316967706.1609500000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-26 | 4507298456.7471400000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-25 | 4750021302.8842900000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-24 | 4923425855.2242900000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-21 | 5009431430.9914300000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-20 | 5030111529.2681000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-19 | 5039998261.7657100000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-18 | 5097071896.2909500000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-17 | 5007244297.3895200000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-14 | 5241340495.5314300000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-13 | 5389669714.1181000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-12 | 5503560582.2666700000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-11 | 5501895371.8228600000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-10 | 5538339920.4557100000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-07 | 5479670690.9314300000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-06 | 5621252129.8614300000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-05 | 5619716581.6690500000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-04 | 5698622960.6642900000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-08-03 | 5650366807.3138100000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-31 | 5836850112.6509500000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-30 | 5806651830.8861900000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-29 | 5695301576.9933300000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-28 | 5601514190.4481000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-27 | 5562219542.3204800000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-24 | 5611869687.2071400000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-23 | 5601413064.8114300000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-22 | 5791074879.5719100000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-21 | 5868003150.1995200000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-20 | 5897051396.9466700000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-17 | 5989544018.6738100000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-16 | 5917955745.6576200000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-15 | 5901183905.9647600000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-14 | 5913787446.1036400000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-13 | 6057894633.5303800000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | SOXX | 2026-07-10 | 6268612121.4060000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |