PREVIEW / etf_1hour / 2024-08-15
file: by_date/etf_1hour/2024/2024-08-15.parquet size: 560 KB rows: 20,760
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-08-15 04:00:00 | SPY | ETF | 545.37 | 545.44 | 544.11 | 544.64 | 18567.0 |
| 2024-08-15 05:00:00 | SPY | ETF | 544.82 | 544.95 | 544.69 | 544.91 | 8795.0 |
| 2024-08-15 06:00:00 | SPY | ETF | 544.99 | 545.05 | 543.94 | 543.95 | 22915.0 |
| 2024-08-15 07:00:00 | SPY | ETF | 543.92 | 545.38 | 543.5 | 545.21 | 223067.0 |
| 2024-08-15 08:00:00 | SPY | ETF | 544.3 | 549.71 | 543.69 | 549.045 | 1350555.0 |
| 2024-08-15 09:00:00 | SPY | ETF | 549.07 | 550.29 | 548.6 | 550.17 | 5996512.0 |
| 2024-08-15 10:00:00 | SPY | ETF | 550.17 | 551.25 | 548.88 | 550.9331 | 6405542.0 |
| 2024-08-15 11:00:00 | SPY | ETF | 550.92 | 552.13 | 550.7882 | 551.61 | 3760362.0 |
| 2024-08-15 12:00:00 | SPY | ETF | 551.61 | 552.71 | 551.261 | 551.93 | 3661791.0 |
| 2024-08-15 13:00:00 | SPY | ETF | 551.94 | 552.68 | 551.445 | 552.645 | 2483755.0 |
| 2024-08-15 14:00:00 | SPY | ETF | 552.65 | 553.09 | 552.45 | 552.92 | 3265923.0 |
| 2024-08-15 15:00:00 | SPY | ETF | 552.92 | 553.36 | 551.91 | 553.0678 | 13809439.0 |
| 2024-08-15 16:00:00 | SPY | ETF | 553.07 | 553.24 | 552.5 | 552.85 | 3975178.0 |
| 2024-08-15 17:00:00 | SPY | ETF | 552.8 | 553.07 | 552.78 | 552.95 | 62017.0 |
| 2024-08-15 18:00:00 | SPY | ETF | 552.96 | 553.74 | 552.82 | 553.5 | 81919.0 |
| 2024-08-15 19:00:00 | SPY | ETF | 553.55 | 554.0 | 553.45 | 553.55 | 68375.0 |
| 2024-08-15 04:00:00 | QQQ | ETF | 465.03 | 465.03 | 463.31 | 463.82 | 25980.0 |
| 2024-08-15 05:00:00 | QQQ | ETF | 463.97 | 464.36 | 463.91 | 464.28 | 24703.0 |
| 2024-08-15 06:00:00 | QQQ | ETF | 464.4 | 464.4 | 463.02 | 463.02 | 45599.0 |
| 2024-08-15 07:00:00 | QQQ | ETF | 463.01 | 464.7 | 462.9 | 464.22 | 155150.0 |
| 2024-08-15 08:00:00 | QQQ | ETF | 464.29 | 469.15 | 463.02 | 468.42 | 1190731.0 |
| 2024-08-15 09:00:00 | QQQ | ETF | 468.49 | 471.4 | 467.933 | 471.38 | 5255228.0 |
| 2024-08-15 10:00:00 | QQQ | ETF | 471.37 | 472.69 | 470.03 | 471.865 | 5666729.0 |
| 2024-08-15 11:00:00 | QQQ | ETF | 471.83 | 473.4475 | 471.635 | 472.94 | 2682682.0 |
| 2024-08-15 12:00:00 | QQQ | ETF | 472.95 | 473.99 | 472.63 | 473.225 | 2479216.0 |
| 2024-08-15 13:00:00 | QQQ | ETF | 473.23 | 474.37 | 472.8 | 474.33 | 1847773.0 |
| 2024-08-15 14:00:00 | QQQ | ETF | 474.34 | 474.53 | 473.89 | 474.34 | 1933049.0 |
| 2024-08-15 15:00:00 | QQQ | ETF | 474.3 | 474.82 | 473.36 | 474.49 | 6231689.0 |
| 2024-08-15 16:00:00 | QQQ | ETF | 474.48 | 474.53 | 473.81 | 474.0 | 2902048.0 |
| 2024-08-15 17:00:00 | QQQ | ETF | 474.0 | 474.42 | 473.87 | 473.97 | 91440.0 |
| 2024-08-15 18:00:00 | QQQ | ETF | 474.02 | 474.95 | 473.91 | 474.8197 | 66220.0 |
| 2024-08-15 19:00:00 | QQQ | ETF | 474.79 | 475.66 | 474.79 | 475.0 | 90724.0 |
| 2024-08-15 04:00:00 | IWM | ETF | 207.1 | 207.1 | 206.17 | 206.24 | 16377.0 |
| 2024-08-15 05:00:00 | IWM | ETF | 206.3 | 206.47 | 206.18 | 206.18 | 6881.0 |
| 2024-08-15 06:00:00 | IWM | ETF | 206.37 | 206.37 | 205.79 | 205.92 | 44052.0 |
| 2024-08-15 07:00:00 | IWM | ETF | 205.89 | 206.92 | 205.72 | 206.64 | 164286.0 |
| 2024-08-15 08:00:00 | IWM | ETF | 206.66 | 211.55 | 205.8308 | 211.11 | 1663213.0 |
| 2024-08-15 09:00:00 | IWM | ETF | 211.2 | 212.09 | 210.168 | 210.32 | 6001418.0 |
| 2024-08-15 10:00:00 | IWM | ETF | 210.32 | 211.86 | 209.91 | 211.78 | 4611392.0 |
| 2024-08-15 11:00:00 | IWM | ETF | 211.77 | 212.615 | 211.75 | 211.92 | 3488592.0 |
| 2024-08-15 12:00:00 | IWM | ETF | 211.91 | 212.98 | 211.88 | 212.65 | 3317133.0 |
| 2024-08-15 13:00:00 | IWM | ETF | 212.66 | 213.0897 | 212.38 | 212.79 | 2275574.0 |
| 2024-08-15 14:00:00 | IWM | ETF | 212.8 | 213.1 | 212.44 | 212.94 | 2660322.0 |
| 2024-08-15 15:00:00 | IWM | ETF | 212.94 | 212.94 | 211.51 | 212.04 | 6796496.0 |
| 2024-08-15 16:00:00 | IWM | ETF | 212.02 | 212.28 | 211.78 | 212.22 | 1508325.0 |
| 2024-08-15 17:00:00 | IWM | ETF | 212.2 | 212.28 | 212.04 | 212.15 | 31068.0 |
| 2024-08-15 18:00:00 | IWM | ETF | 212.14 | 212.55 | 212.14 | 212.49 | 17547.0 |
| 2024-08-15 19:00:00 | IWM | ETF | 212.48 | 212.79 | 212.48 | 212.6 | 66262.0 |
| 2024-08-15 04:00:00 | DIA | ETF | 401.36 | 401.36 | 401.02 | 401.05 | 2344.0 |
| 2024-08-15 06:00:00 | DIA | ETF | 401.17 | 401.17 | 401.08 | 401.08 | 406.0 |
> showing 50 of 20,760 rows — these rows as CSV