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_at |
|---|
| dollar_volume_21d | AAPL | 2016-09-01 | 2607080146.4284900000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-02 | 2606456124.8860400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-06 | 2542700245.9466100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-07 | 2610313006.7172500000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-08 | 2729204116.1546200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-09 | 2825404679.2208400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-12 | 2904214841.8828400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-13 | 3108648209.0238600000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-14 | 3532227396.4923000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-15 | 3827372477.8865300000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-16 | 4106640066.9440200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-19 | 4234825384.1129300000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-20 | 4284723856.3395900000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-21 | 4340758740.4475400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-22 | 4395111991.3322200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-23 | 4541363271.6871100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-26 | 4570684468.6481000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-27 | 4562561775.5393100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-28 | 4593500728.3871200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-29 | 4654057745.3762400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-09-30 | 4696113105.3884300000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-03 | 4678342205.5932500000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-04 | 4698938479.4379500000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-05 | 4678476717.0558200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-06 | 4621286899.7166300000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-07 | 4498691808.7841400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-10 | 4472720131.0589400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-11 | 4589123454.2568200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-12 | 4488872633.2423100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-13 | 4121256354.1546500000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-14 | 3847774575.8464700000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-17 | 3568843560.9052900000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-18 | 3461836957.7124000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-19 | 3393303842.6673400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-20 | 3338245254.8885600000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-21 | 3300896086.1891700000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-24 | 3163866537.7684900000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-25 | 3264905865.3468800000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-26 | 3476673210.8160700000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-27 | 3501896638.2868400000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-28 | 3514085611.4505200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-10-31 | 3465604279.7848000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-11-01 | 3572074113.8318100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-11-02 | 3563417733.3059500000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-11-03 | 3587284803.3386100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-11-04 | 3591460156.0178100000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-11-07 | 3627835668.8783200000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-11-08 | 3562597812.3098500000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-11-09 | 3525450100.5939300000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | AAPL | 2016-11-10 | 3602973126.8363500000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |