PREVIEW / etf_1hour / 2024-09-17
file: by_date/etf_1hour/2024/2024-09-17.parquet size: 555 KB rows: 20,712
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-09-17 04:00:00 | SPY | ETF | 563.3 | 564.34 | 563.3 | 564.27 | 26961.0 |
| 2024-09-17 05:00:00 | SPY | ETF | 564.16 | 564.99 | 564.16 | 564.78 | 33355.0 |
| 2024-09-17 06:00:00 | SPY | ETF | 564.73 | 565.0 | 564.38 | 564.45 | 17475.0 |
| 2024-09-17 07:00:00 | SPY | ETF | 564.42 | 565.41 | 564.06 | 565.22 | 186248.0 |
| 2024-09-17 08:00:00 | SPY | ETF | 564.39 | 565.58 | 562.31 | 565.32 | 367616.0 |
| 2024-09-17 09:00:00 | SPY | ETF | 565.33 | 565.57 | 564.07 | 564.49 | 3406453.0 |
| 2024-09-17 10:00:00 | SPY | ETF | 564.51 | 566.58 | 564.27 | 565.135 | 4792184.0 |
| 2024-09-17 11:00:00 | SPY | ETF | 565.16 | 565.965 | 564.77 | 564.99 | 2789551.0 |
| 2024-09-17 12:00:00 | SPY | ETF | 564.97 | 565.19 | 560.98 | 561.825 | 4693414.0 |
| 2024-09-17 13:00:00 | SPY | ETF | 561.83 | 563.0796 | 560.795 | 562.62 | 2943824.0 |
| 2024-09-17 14:00:00 | SPY | ETF | 562.63 | 563.18 | 561.33 | 562.025 | 3128494.0 |
| 2024-09-17 15:00:00 | SPY | ETF | 562.02 | 563.17 | 561.33 | 563.1 | 7034891.0 |
| 2024-09-17 16:00:00 | SPY | ETF | 563.12 | 563.53 | 562.909 | 563.14 | 3356984.0 |
| 2024-09-17 17:00:00 | SPY | ETF | 563.1 | 563.15 | 562.98 | 563.02 | 110818.0 |
| 2024-09-17 18:00:00 | SPY | ETF | 563.07 | 563.33 | 562.96 | 563.22 | 84994.0 |
| 2024-09-17 19:00:00 | SPY | ETF | 563.15 | 563.53 | 563.05 | 563.46 | 43775.0 |
| 2024-09-17 04:00:00 | QQQ | ETF | 474.12 | 475.23 | 474.12 | 475.0 | 54153.0 |
| 2024-09-17 05:00:00 | QQQ | ETF | 475.07 | 476.05 | 475.01 | 475.73 | 66242.0 |
| 2024-09-17 06:00:00 | QQQ | ETF | 475.76 | 476.05 | 475.17 | 475.27 | 25549.0 |
| 2024-09-17 07:00:00 | QQQ | ETF | 475.22 | 476.39 | 475.0 | 476.19 | 87862.0 |
| 2024-09-17 08:00:00 | QQQ | ETF | 475.2209 | 476.77 | 472.9 | 476.35 | 394941.0 |
| 2024-09-17 09:00:00 | QQQ | ETF | 476.32 | 477.05 | 474.23 | 475.42 | 2913844.0 |
| 2024-09-17 10:00:00 | QQQ | ETF | 475.46 | 477.6 | 474.97 | 475.66 | 3497087.0 |
| 2024-09-17 11:00:00 | QQQ | ETF | 475.69 | 476.74 | 474.96 | 475.758 | 1999969.0 |
| 2024-09-17 12:00:00 | QQQ | ETF | 475.77 | 476.0199 | 471.53 | 472.41 | 3608311.0 |
| 2024-09-17 13:00:00 | QQQ | ETF | 472.45 | 473.8399 | 470.97 | 473.04 | 2487283.0 |
| 2024-09-17 14:00:00 | QQQ | ETF | 473.02 | 473.49 | 471.8 | 472.48 | 1750836.0 |
| 2024-09-17 15:00:00 | QQQ | ETF | 472.415 | 473.55 | 472.05 | 473.51 | 3229027.0 |
| 2024-09-17 16:00:00 | QQQ | ETF | 473.51 | 473.96 | 473.26 | 473.61 | 1795306.0 |
| 2024-09-17 17:00:00 | QQQ | ETF | 473.62 | 473.62 | 473.47 | 473.47 | 19187.0 |
| 2024-09-17 18:00:00 | QQQ | ETF | 473.6 | 473.85 | 473.48 | 473.63 | 19045.0 |
| 2024-09-17 19:00:00 | QQQ | ETF | 473.603 | 474.13 | 473.49 | 474.01 | 39356.0 |
| 2024-09-17 04:00:00 | IWM | ETF | 217.75 | 218.21 | 217.75 | 218.21 | 15299.0 |
| 2024-09-17 05:00:00 | IWM | ETF | 218.15 | 218.47 | 218.12 | 218.42 | 12971.0 |
| 2024-09-17 06:00:00 | IWM | ETF | 218.4 | 218.54 | 218.07 | 218.13 | 11223.0 |
| 2024-09-17 07:00:00 | IWM | ETF | 218.09 | 219.36 | 217.97 | 219.19 | 57627.0 |
| 2024-09-17 08:00:00 | IWM | ETF | 218.0804 | 219.1 | 217.44 | 218.99 | 348414.0 |
| 2024-09-17 09:00:00 | IWM | ETF | 218.9694 | 219.83 | 218.78 | 218.9 | 2249983.0 |
| 2024-09-17 10:00:00 | IWM | ETF | 218.88 | 221.29 | 218.76 | 220.73 | 4277214.0 |
| 2024-09-17 11:00:00 | IWM | ETF | 220.75 | 221.8 | 220.68 | 220.8336 | 3107533.0 |
| 2024-09-17 12:00:00 | IWM | ETF | 220.84 | 221.01 | 218.72 | 218.8193 | 2744629.0 |
| 2024-09-17 13:00:00 | IWM | ETF | 218.83 | 219.82 | 218.47 | 219.6 | 2310605.0 |
| 2024-09-17 14:00:00 | IWM | ETF | 219.6 | 219.91 | 219.09 | 219.5383 | 2008543.0 |
| 2024-09-17 15:00:00 | IWM | ETF | 219.52 | 219.77 | 218.72 | 219.35 | 4944159.0 |
| 2024-09-17 16:00:00 | IWM | ETF | 219.41 | 219.61 | 219.26 | 219.44 | 1785387.0 |
| 2024-09-17 17:00:00 | IWM | ETF | 219.411 | 219.58 | 219.28 | 219.41 | 29892.0 |
| 2024-09-17 18:00:00 | IWM | ETF | 219.36 | 219.6 | 219.32 | 219.55 | 23574.0 |
| 2024-09-17 19:00:00 | IWM | ETF | 219.48 | 219.71 | 219.4 | 219.68 | 11600.0 |
| 2024-09-17 04:00:00 | DIA | ETF | 417.91 | 417.91 | 417.89 | 417.89 | 1300.0 |
| 2024-09-17 05:00:00 | DIA | ETF | 418.06 | 418.39 | 418.06 | 418.39 | 298.0 |
> showing 50 of 20,712 rows — these rows as CSV