metric_daily730,628 rowsas_of_date leads no index, so this sort reads every matching row and keeps only the top 450 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 |
|---|---|---|---|---|---|---|---|---|
| drawdown_252d |
| XLP |
| 2016-09-20 |
| -0.0460012908 |
| metric_daily |
| — |
| — |
| 2026-09-09 11:17 |
| 2026-09-09 11:17 |
| drawdown_252d | XLK | 2016-09-20 | -0.0089214673 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLI | 2016-09-20 | -0.0314733057 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-20 | -0.0273909133 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLE | 2016-09-20 | -0.0628619003 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | WDC | 2016-09-20 | -0.3478544438 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | STX | 2016-09-20 | -0.2110963917 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-20 | -0.0209587840 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SOXX | 2016-09-20 | -0.0105685131 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SMH | 2016-09-20 | -0.0041903622 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | QQQ | 2016-09-20 | -0.0053171372 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-20 | -0.2246047329 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | ORCL | 2016-09-20 | -0.0646396936 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | NVDA | 2016-09-20 | -0.0091094707 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MU | 2016-09-20 | -0.1169102296 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MSFT | 2016-09-20 | -0.0233797490 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MRVL | 2016-09-20 | -0.0322828593 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | META | 2016-09-20 | -0.0183899275 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | LMT | 2016-09-20 | -0.0915000218 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | IWM | 2016-09-20 | -0.0259947373 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | INTC | 2016-09-20 | -0.0140695514 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | GOOG | 2016-09-20 | -0.0171242913 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | DIA | 2016-09-20 | -0.0239989092 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | DE | 2016-09-20 | -0.0637983880 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | CAT | 2016-09-20 | -0.0321052008 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | AVGO | 2016-09-20 | -0.0488310253 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | AMZN | 2016-09-20 | -0.0109650513 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | AMD | 2016-09-20 | -0.1955671447 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | AAPL | 2016-09-20 | -0.0536164174 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XOM | 2016-09-21 | -0.1167961860 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLY | 2016-09-21 | -0.0314971027 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLV | 2016-09-21 | -0.0344699062 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLU | 2016-09-21 | -0.0354434257 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLP | 2016-09-21 | -0.0407635091 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLK | 2016-09-21 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLI | 2016-09-21 | -0.0188795656 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLF | 2016-09-21 | -0.0213498631 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | XLE | 2016-09-21 | -0.0411559222 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | WDC | 2016-09-21 | -0.3273625493 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | STX | 2016-09-21 | -0.1853398990 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SPY | 2016-09-21 | -0.0099490016 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SOXX | 2016-09-21 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | SMH | 2016-09-21 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | QQQ | 2016-09-21 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | PANW | 2016-09-21 | -0.2269298336 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | ORCL | 2016-09-21 | -0.0541058176 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | NVDA | 2016-09-21 | 0.0000000000 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MU | 2016-09-21 | -0.0782881002 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MSFT | 2016-09-21 | -0.0070483067 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |
| drawdown_252d | MRVL | 2016-09-21 | -0.0069177556 | metric_daily | — | — | 2026-09-09 11:17 | 2026-09-09 11:17 |