PREVIEW / etf_1hour / 2024-10-28
file: by_date/etf_1hour/2024/2024-10-28.parquet size: 577 KB rows: 21,651
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-10-28 04:00:00 | SPY | ETF | 581.22 | 582.79 | 581.22 | 582.65 | 81611.0 |
| 2024-10-28 05:00:00 | SPY | ETF | 582.58 | 582.79 | 582.35 | 582.79 | 19716.0 |
| 2024-10-28 06:00:00 | SPY | ETF | 582.8 | 582.98 | 582.19 | 582.2 | 30717.0 |
| 2024-10-28 07:00:00 | SPY | ETF | 582.2 | 582.26 | 581.43 | 581.67 | 361718.0 |
| 2024-10-28 08:00:00 | SPY | ETF | 581.91 | 582.58 | 581.02 | 582.42 | 285006.0 |
| 2024-10-28 09:00:00 | SPY | ETF | 582.53 | 582.71 | 581.35 | 581.49 | 3455891.0 |
| 2024-10-28 10:00:00 | SPY | ETF | 581.515 | 582.5 | 581.24 | 581.9201 | 2715246.0 |
| 2024-10-28 11:00:00 | SPY | ETF | 581.96 | 582.05 | 580.68 | 580.92 | 1988126.0 |
| 2024-10-28 12:00:00 | SPY | ETF | 580.9 | 581.72 | 580.57 | 581.02 | 1571602.0 |
| 2024-10-28 13:00:00 | SPY | ETF | 581.01 | 581.87 | 580.6 | 581.68 | 1520470.0 |
| 2024-10-28 14:00:00 | SPY | ETF | 581.69 | 581.84 | 580.8601 | 581.14 | 2362531.0 |
| 2024-10-28 15:00:00 | SPY | ETF | 581.11 | 581.7099 | 580.52 | 580.77 | 5738378.0 |
| 2024-10-28 16:00:00 | SPY | ETF | 580.78 | 581.29 | 580.63 | 580.96 | 2189743.0 |
| 2024-10-28 17:00:00 | SPY | ETF | 580.9787 | 581.1 | 580.95 | 581.09 | 25323.0 |
| 2024-10-28 18:00:00 | SPY | ETF | 581.04 | 581.06 | 580.49 | 580.6 | 40249.0 |
| 2024-10-28 19:00:00 | SPY | ETF | 580.7 | 580.8 | 580.54 | 580.73 | 9864.0 |
| 2024-10-28 04:00:00 | QQQ | ETF | 498.0 | 499.45 | 498.0 | 499.35 | 73065.0 |
| 2024-10-28 05:00:00 | QQQ | ETF | 499.23 | 499.5 | 498.89 | 499.5 | 25989.0 |
| 2024-10-28 06:00:00 | QQQ | ETF | 499.59 | 499.69 | 498.68 | 498.73 | 77545.0 |
| 2024-10-28 07:00:00 | QQQ | ETF | 498.62 | 498.77 | 498.15 | 498.33 | 128506.0 |
| 2024-10-28 08:00:00 | QQQ | ETF | 498.22 | 499.374 | 495.691 | 499.25 | 295264.0 |
| 2024-10-28 09:00:00 | QQQ | ETF | 499.3 | 499.4 | 496.15 | 496.73 | 2229083.0 |
| 2024-10-28 10:00:00 | QQQ | ETF | 496.75 | 498.23 | 496.74 | 497.22 | 1918423.0 |
| 2024-10-28 11:00:00 | QQQ | ETF | 497.3 | 497.32 | 495.94 | 496.2075 | 1790132.0 |
| 2024-10-28 12:00:00 | QQQ | ETF | 496.19 | 497.12 | 495.825 | 496.19 | 1723149.0 |
| 2024-10-28 13:00:00 | QQQ | ETF | 496.17 | 496.88 | 495.6 | 496.75 | 1419519.0 |
| 2024-10-28 14:00:00 | QQQ | ETF | 496.69 | 496.88 | 495.57 | 495.95 | 1698302.0 |
| 2024-10-28 15:00:00 | QQQ | ETF | 495.98 | 496.3667 | 495.1 | 495.4 | 3744575.0 |
| 2024-10-28 16:00:00 | QQQ | ETF | 495.41 | 495.97 | 495.25 | 495.62 | 807875.0 |
| 2024-10-28 17:00:00 | QQQ | ETF | 495.63 | 495.9 | 495.6 | 495.82 | 33373.0 |
| 2024-10-28 18:00:00 | QQQ | ETF | 495.78 | 495.94 | 495.2 | 495.34 | 61330.0 |
| 2024-10-28 19:00:00 | QQQ | ETF | 495.4 | 495.63 | 495.3 | 495.6 | 20027.0 |
| 2024-10-28 04:00:00 | IWM | ETF | 219.58 | 220.59 | 219.58 | 220.5 | 51797.0 |
| 2024-10-28 05:00:00 | IWM | ETF | 220.43 | 220.54 | 220.13 | 220.36 | 12637.0 |
| 2024-10-28 06:00:00 | IWM | ETF | 220.45 | 220.7 | 220.35 | 220.48 | 26494.0 |
| 2024-10-28 07:00:00 | IWM | ETF | 220.45 | 220.46 | 220.01 | 220.17 | 51068.0 |
| 2024-10-28 08:00:00 | IWM | ETF | 220.4511 | 220.62 | 219.68 | 220.54 | 106933.0 |
| 2024-10-28 09:00:00 | IWM | ETF | 220.62 | 222.52 | 220.48 | 221.94 | 2848164.0 |
| 2024-10-28 10:00:00 | IWM | ETF | 221.98 | 222.84 | 221.49 | 222.67 | 2127398.0 |
| 2024-10-28 11:00:00 | IWM | ETF | 222.68 | 222.97 | 221.97 | 221.98 | 1317169.0 |
| 2024-10-28 12:00:00 | IWM | ETF | 221.975 | 222.665 | 221.78 | 222.5 | 1365818.0 |
| 2024-10-28 13:00:00 | IWM | ETF | 222.48 | 222.8 | 222.34 | 222.64 | 1105039.0 |
| 2024-10-28 14:00:00 | IWM | ETF | 222.6405 | 222.69 | 222.19 | 222.44 | 1233702.0 |
| 2024-10-28 15:00:00 | IWM | ETF | 222.43 | 222.86 | 222.26 | 222.49 | 3241933.0 |
| 2024-10-28 16:00:00 | IWM | ETF | 222.46 | 222.61 | 222.24 | 222.44 | 1540200.0 |
| 2024-10-28 17:00:00 | IWM | ETF | 222.52 | 222.65 | 222.33 | 222.55 | 2606.0 |
| 2024-10-28 18:00:00 | IWM | ETF | 222.55 | 222.55 | 222.24 | 222.28 | 11997.0 |
| 2024-10-28 19:00:00 | IWM | ETF | 222.32 | 222.41 | 222.2601 | 222.27 | 9497.0 |
| 2024-10-28 04:00:00 | DIA | ETF | 423.24 | 423.24 | 422.88 | 422.88 | 1332.0 |
| 2024-10-28 05:00:00 | DIA | ETF | 423.18 | 423.35 | 423.15 | 423.35 | 2800.0 |
> showing 50 of 21,651 rows — these rows as CSV