metric_daily730,628 rowsas_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 | SOXX | 2016-09-01 | 40354012.4275366000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-02 | 41164726.0107955000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-06 | 41003160.5142166000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-07 | 45916107.7558345000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-08 | 46312479.8031519000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-09 | 46449179.5793721000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-12 | 48052470.5405787000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-13 | 49003195.4370734000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-14 | 49625783.8754133000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-15 | 49554786.9832406000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-16 | 49828459.0614498000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-19 | 50612686.0247636000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-20 | 50002771.4985327000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-21 | 50856214.7145106000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-22 | 51244385.0807431000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-23 | 51107245.0595243000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-26 | 51432879.3853996000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-27 | 51614081.1447638000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-28 | 51674972.2749756000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-29 | 50834704.3787448000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-09-30 | 50808639.4857429000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-03 | 54500133.1216857000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-04 | 53521885.5764920000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-05 | 58093244.6506390000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-06 | 56400386.3865007000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-07 | 56554781.3866723000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-10 | 54694549.9057964000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-11 | 54363998.7317131000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-12 | 55029340.1359067000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-13 | 56622680.4225630000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-14 | 55967376.5553759000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-17 | 54065430.1803023000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-18 | 53631616.0214745000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-19 | 53839816.9403853000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-20 | 55075768.8801774000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-21 | 55140950.2067678000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-24 | 55006871.3643171000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-25 | 54550480.8248719000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-26 | 54722252.7768859000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-27 | 55619155.8657946000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-28 | 54348234.1810458000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-10-31 | 53575456.8422599000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-11-01 | 50352758.3324437000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-11-02 | 52605238.2071438000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-11-03 | 48717925.6514539000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-11-04 | 46428405.6210751000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-11-07 | 51919437.2991865000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-11-08 | 51933689.5884427000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-11-09 | 53964654.4413085000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| dollar_volume_21d | SOXX | 2016-11-10 | 61993818.0981799000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |