PREVIEW / etf_1hour / 2024-11-04
file: by_date/etf_1hour/2024/2024-11-04.parquet size: 590 KB rows: 22,010
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-11-04 04:00:00 | SPY | ETF | 571.87 | 572.0 | 571.35 | 572.0 | 23408.0 |
| 2024-11-04 05:00:00 | SPY | ETF | 571.94 | 572.8 | 571.94 | 572.63 | 5959.0 |
| 2024-11-04 06:00:00 | SPY | ETF | 572.73 | 572.75 | 572.2 | 572.32 | 13054.0 |
| 2024-11-04 07:00:00 | SPY | ETF | 572.33 | 572.599 | 571.0 | 572.0 | 142571.0 |
| 2024-11-04 08:00:00 | SPY | ETF | 572.5 | 573.0 | 571.0599 | 571.63 | 124383.0 |
| 2024-11-04 09:00:00 | SPY | ETF | 571.62 | 571.62 | 569.27 | 571.52 | 2748552.0 |
| 2024-11-04 10:00:00 | SPY | ETF | 571.4701 | 572.5 | 571.21 | 571.63 | 2653254.0 |
| 2024-11-04 11:00:00 | SPY | ETF | 571.64 | 572.19 | 568.27 | 568.85 | 3044079.0 |
| 2024-11-04 12:00:00 | SPY | ETF | 568.8701 | 570.86 | 567.89 | 570.46 | 2406108.0 |
| 2024-11-04 13:00:00 | SPY | ETF | 570.45 | 571.27 | 569.2325 | 570.6627 | 1780215.0 |
| 2024-11-04 14:00:00 | SPY | ETF | 570.67 | 571.21 | 570.1 | 570.5103 | 2230467.0 |
| 2024-11-04 15:00:00 | SPY | ETF | 570.51 | 570.68 | 569.17 | 569.77 | 6259364.0 |
| 2024-11-04 16:00:00 | SPY | ETF | 569.78 | 570.28 | 569.5 | 570.28 | 2376384.0 |
| 2024-11-04 17:00:00 | SPY | ETF | 570.24 | 570.2401 | 569.5704 | 570.23 | 305699.0 |
| 2024-11-04 18:00:00 | SPY | ETF | 570.24 | 570.7 | 569.72 | 569.72 | 92065.0 |
| 2024-11-04 19:00:00 | SPY | ETF | 569.72 | 569.72 | 569.4 | 569.58 | 27969.0 |
| 2024-11-04 04:00:00 | QQQ | ETF | 487.97 | 488.0 | 487.21 | 487.91 | 38189.0 |
| 2024-11-04 05:00:00 | QQQ | ETF | 487.98 | 489.0 | 487.98 | 488.6 | 21540.0 |
| 2024-11-04 06:00:00 | QQQ | ETF | 488.75 | 488.75 | 488.0 | 488.32 | 22624.0 |
| 2024-11-04 07:00:00 | QQQ | ETF | 488.3 | 488.61 | 486.42 | 487.92 | 134788.0 |
| 2024-11-04 08:00:00 | QQQ | ETF | 488.09 | 489.86 | 486.46 | 487.51 | 176128.0 |
| 2024-11-04 09:00:00 | QQQ | ETF | 487.42 | 487.42 | 484.2545 | 487.1563 | 2396888.0 |
| 2024-11-04 10:00:00 | QQQ | ETF | 487.13 | 488.95 | 486.8 | 488.4 | 1994406.0 |
| 2024-11-04 11:00:00 | QQQ | ETF | 488.41 | 489.38 | 485.22 | 485.81 | 2190067.0 |
| 2024-11-04 12:00:00 | QQQ | ETF | 485.84 | 487.46 | 484.685 | 487.01 | 2156490.0 |
| 2024-11-04 13:00:00 | QQQ | ETF | 487.01 | 488.15 | 486.0 | 487.49 | 1562141.0 |
| 2024-11-04 14:00:00 | QQQ | ETF | 487.52 | 487.9899 | 486.91 | 487.22 | 1147904.0 |
| 2024-11-04 15:00:00 | QQQ | ETF | 487.16 | 487.31 | 485.63 | 485.96 | 3539685.0 |
| 2024-11-04 16:00:00 | QQQ | ETF | 485.97 | 486.65 | 485.64 | 486.65 | 729774.0 |
| 2024-11-04 17:00:00 | QQQ | ETF | 486.6 | 486.65 | 486.25 | 486.44 | 45277.0 |
| 2024-11-04 18:00:00 | QQQ | ETF | 486.5 | 487.0 | 485.9504 | 486.02 | 74500.0 |
| 2024-11-04 19:00:00 | QQQ | ETF | 486.0 | 486.01 | 485.65 | 485.78 | 31927.0 |
| 2024-11-04 04:00:00 | IWM | ETF | 218.11 | 218.67 | 217.95 | 218.67 | 17571.0 |
| 2024-11-04 05:00:00 | IWM | ETF | 219.02 | 219.49 | 219.0 | 219.49 | 10160.0 |
| 2024-11-04 06:00:00 | IWM | ETF | 219.56 | 219.58 | 219.17 | 219.26 | 24614.0 |
| 2024-11-04 07:00:00 | IWM | ETF | 219.25 | 219.3 | 218.4 | 218.8 | 81053.0 |
| 2024-11-04 08:00:00 | IWM | ETF | 219.3486 | 219.5296 | 218.35 | 218.85 | 68989.0 |
| 2024-11-04 09:00:00 | IWM | ETF | 218.82 | 219.61 | 217.8401 | 219.43 | 2195697.0 |
| 2024-11-04 10:00:00 | IWM | ETF | 219.41 | 221.63 | 219.27 | 221.21 | 2705794.0 |
| 2024-11-04 11:00:00 | IWM | ETF | 221.22 | 221.74 | 220.06 | 220.2301 | 2231103.0 |
| 2024-11-04 12:00:00 | IWM | ETF | 220.24 | 221.43 | 219.97 | 221.21 | 1328985.0 |
| 2024-11-04 13:00:00 | IWM | ETF | 221.2 | 221.22 | 220.5 | 220.7855 | 1086971.0 |
| 2024-11-04 14:00:00 | IWM | ETF | 220.8 | 220.93 | 220.13 | 220.18 | 1102485.0 |
| 2024-11-04 15:00:00 | IWM | ETF | 220.19 | 220.57 | 219.89 | 220.09 | 2626735.0 |
| 2024-11-04 16:00:00 | IWM | ETF | 220.09 | 220.2385 | 219.87 | 219.95 | 1142725.0 |
| 2024-11-04 17:00:00 | IWM | ETF | 220.04 | 220.15 | 219.97 | 220.14 | 27084.0 |
| 2024-11-04 18:00:00 | IWM | ETF | 220.28 | 220.28 | 219.85 | 219.89 | 31027.0 |
| 2024-11-04 19:00:00 | IWM | ETF | 219.85 | 219.8896 | 219.74 | 219.8001 | 21594.0 |
| 2024-11-04 04:00:00 | DIA | ETF | 420.34 | 420.36 | 420.34 | 420.35 | 600.0 |
| 2024-11-04 05:00:00 | DIA | ETF | 421.13 | 421.13 | 421.13 | 421.13 | 820.0 |
> showing 50 of 22,010 rows — these rows as CSV