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 | AMZN | 2026-10-02 | 8574299878.6981000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-10-01 | 8470478616.0676200000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-09-30 | 8470032265.9223800000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-09-29 | 8550787702.9123800000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-09-28 | 8808652585.9638100000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-09-25 | 8873739703.2338100000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-09-24 | 8749727838.8404800000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-09-23 | 8679657067.2100000000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-09-22 | 8512114814.6033300000 | metric_daily | — | — | 2026-10-02 18:30 | 2026-10-02 18:30 |
| dollar_volume_21d | AMZN | 2026-09-21 | 8453316738.5681000000 | metric_daily | — | — | 2026-10-01 18:30 | 2026-10-01 18:30 |
| dollar_volume_21d | AMZN | 2026-09-18 | 8303789040.7719000000 | metric_daily | — | — | 2026-09-28 18:30 | 2026-09-28 18:30 |
| dollar_volume_21d | AMZN | 2026-09-17 | 8129550023.2733300000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | AMZN | 2026-09-16 | 8185038174.0071400000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | AMZN | 2026-09-15 | 8347789293.1195200000 | metric_daily | — | — | 2026-09-25 18:30 | 2026-09-25 18:30 |
| dollar_volume_21d | AMZN | 2026-09-14 | 8259508492.9938100000 | metric_daily | — | — | 2026-09-24 18:30 | 2026-09-24 18:30 |
| dollar_volume_21d | AMZN | 2026-09-11 | 8266573562.8219100000 | metric_daily | — | — | 2026-09-21 18:30 | 2026-09-21 18:30 |
| dollar_volume_21d | AMZN | 2026-09-10 | 8330749173.3104800000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | AMZN | 2026-09-09 | 8445870082.9457100000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | AMZN | 2026-09-08 | 8533046369.3852400000 | metric_daily | — | — | 2026-09-18 18:30 | 2026-09-18 18:30 |
| dollar_volume_21d | AMZN | 2026-09-04 | 8615898009.1519100000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-09-03 | 8635033450.8252400000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-09-02 | 8889304745.3347600000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-09-01 | 9519142150.8004800000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-31 | 10362790774.2719000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-28 | 11461650086.4262000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-27 | 11975095124.5876000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-26 | 12021893362.3390000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-25 | 12244505312.7667000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-24 | 12312524088.0624000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-21 | 12349259671.5605000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-20 | 12437436935.0433000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-19 | 12483728163.5871000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-18 | 12357917956.8938000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-17 | 12333870909.2671000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-14 | 12300623109.9371000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-13 | 12499351250.0805000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-12 | 12642459671.5324000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-11 | 12616211430.9333000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-10 | 12610573680.8405000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-07 | 12507207281.1429000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-06 | 12512725550.2019000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-05 | 12459062231.6019000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-04 | 12348579192.8086000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-08-03 | 11892752808.2057000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-07-31 | 11222415167.1281000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-07-30 | 10172985656.5814000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-07-29 | 9782584570.2995200000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-07-28 | 10184958789.2195000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-07-27 | 12447599007.0876000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |
| dollar_volume_21d | AMZN | 2026-07-24 | 12903604718.6462000000 | metric_daily | — | — | 2026-09-15 12:15 | 2026-09-15 12:15 |