PREVIEW / etf_1hour / 2024-07-31
file: by_date/etf_1hour/2024/2024-07-31.parquet size: 565 KB rows: 21,149
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-07-31 04:00:00 | SPY | ETF | 544.98 | 547.45 | 544.98 | 546.95 | 98661.0 |
| 2024-07-31 05:00:00 | SPY | ETF | 546.98 | 547.24 | 546.75 | 546.92 | 49946.0 |
| 2024-07-31 06:00:00 | SPY | ETF | 546.91 | 547.47 | 546.83 | 547.47 | 85942.0 |
| 2024-07-31 07:00:00 | SPY | ETF | 547.4 | 547.51 | 546.82 | 547.29 | 452022.0 |
| 2024-07-31 08:00:00 | SPY | ETF | 547.07 | 548.96 | 543.9 | 548.79 | 752560.0 |
| 2024-07-31 09:00:00 | SPY | ETF | 548.82 | 549.38 | 547.5799 | 548.74 | 5106250.0 |
| 2024-07-31 10:00:00 | SPY | ETF | 548.75 | 551.28 | 548.47 | 550.56 | 4700348.0 |
| 2024-07-31 11:00:00 | SPY | ETF | 550.56 | 551.71 | 550.28 | 550.66 | 3239053.0 |
| 2024-07-31 12:00:00 | SPY | ETF | 550.685 | 551.1 | 550.1 | 550.17 | 1936157.0 |
| 2024-07-31 13:00:00 | SPY | ETF | 550.17 | 550.98 | 548.66 | 550.29 | 4043163.0 |
| 2024-07-31 14:00:00 | SPY | ETF | 550.32 | 553.5 | 549.43 | 553.06 | 5557380.0 |
| 2024-07-31 15:00:00 | SPY | ETF | 553.05 | 553.37 | 549.23 | 550.44 | 16664715.0 |
| 2024-07-31 16:00:00 | SPY | ETF | 550.44 | 552.94 | 550.33 | 551.7 | 5980616.0 |
| 2024-07-31 17:00:00 | SPY | ETF | 551.7 | 552.17 | 551.24 | 551.98 | 109829.0 |
| 2024-07-31 18:00:00 | SPY | ETF | 552.06 | 553.08 | 551.98 | 552.89 | 231539.0 |
| 2024-07-31 19:00:00 | SPY | ETF | 553.05 | 553.64 | 552.95 | 553.46 | 151203.0 |
| 2024-07-31 04:00:00 | QQQ | ETF | 463.04 | 464.9 | 462.7 | 464.09 | 218194.0 |
| 2024-07-31 05:00:00 | QQQ | ETF | 464.1 | 464.5 | 463.65 | 463.76 | 50654.0 |
| 2024-07-31 06:00:00 | QQQ | ETF | 463.76 | 464.76 | 463.75 | 464.76 | 125906.0 |
| 2024-07-31 07:00:00 | QQQ | ETF | 464.75 | 465.2 | 464.12 | 465.01 | 347998.0 |
| 2024-07-31 08:00:00 | QQQ | ETF | 464.24 | 467.47 | 457.187 | 467.37 | 837702.0 |
| 2024-07-31 09:00:00 | QQQ | ETF | 467.35 | 468.9 | 466.41 | 468.34 | 7686362.0 |
| 2024-07-31 10:00:00 | QQQ | ETF | 468.37 | 470.83 | 467.93 | 469.82 | 4647429.0 |
| 2024-07-31 11:00:00 | QQQ | ETF | 469.82 | 471.36 | 469.58 | 470.26 | 2514539.0 |
| 2024-07-31 12:00:00 | QQQ | ETF | 470.265 | 470.76 | 469.18 | 469.26 | 1608674.0 |
| 2024-07-31 13:00:00 | QQQ | ETF | 469.3 | 470.5199 | 467.3036 | 469.3 | 2374248.0 |
| 2024-07-31 14:00:00 | QQQ | ETF | 469.31 | 472.73 | 468.54 | 472.36 | 4189504.0 |
| 2024-07-31 15:00:00 | QQQ | ETF | 472.39 | 472.79 | 469.045 | 471.04 | 7517189.0 |
| 2024-07-31 16:00:00 | QQQ | ETF | 471.04 | 474.54 | 470.87 | 473.13 | 2668953.0 |
| 2024-07-31 17:00:00 | QQQ | ETF | 473.1 | 473.5 | 472.72 | 473.38 | 164079.0 |
| 2024-07-31 18:00:00 | QQQ | ETF | 473.36 | 474.52 | 473.13 | 474.26 | 200282.0 |
| 2024-07-31 19:00:00 | QQQ | ETF | 474.32 | 475.55 | 474.32 | 475.3 | 109561.0 |
| 2024-07-31 04:00:00 | IWM | ETF | 224.69 | 224.72 | 224.0 | 224.13 | 24616.0 |
| 2024-07-31 05:00:00 | IWM | ETF | 224.06 | 224.45 | 224.05 | 224.38 | 28986.0 |
| 2024-07-31 06:00:00 | IWM | ETF | 224.4 | 224.5 | 224.18 | 224.22 | 34232.0 |
| 2024-07-31 07:00:00 | IWM | ETF | 224.24 | 224.39 | 223.47 | 224.04 | 108012.0 |
| 2024-07-31 08:00:00 | IWM | ETF | 224.17 | 224.74 | 223.09 | 223.44 | 504012.0 |
| 2024-07-31 09:00:00 | IWM | ETF | 223.3808 | 224.69 | 221.98 | 222.4296 | 5048720.0 |
| 2024-07-31 10:00:00 | IWM | ETF | 222.44 | 224.105 | 222.38 | 224.0 | 3659116.0 |
| 2024-07-31 11:00:00 | IWM | ETF | 224.01 | 224.6399 | 223.45 | 224.44 | 1900947.0 |
| 2024-07-31 12:00:00 | IWM | ETF | 224.48 | 225.2999 | 224.38 | 224.86 | 2327183.0 |
| 2024-07-31 13:00:00 | IWM | ETF | 224.86 | 225.17 | 223.96 | 224.485 | 2443326.0 |
| 2024-07-31 14:00:00 | IWM | ETF | 224.5 | 228.29 | 223.52 | 228.24 | 9121712.0 |
| 2024-07-31 15:00:00 | IWM | ETF | 228.26 | 228.63 | 223.5831 | 223.93 | 15702349.0 |
| 2024-07-31 16:00:00 | IWM | ETF | 223.93 | 224.77 | 223.56 | 224.01 | 2104447.0 |
| 2024-07-31 17:00:00 | IWM | ETF | 224.02 | 224.22 | 223.93 | 224.2 | 43124.0 |
| 2024-07-31 18:00:00 | IWM | ETF | 224.01 | 224.54 | 224.0 | 224.2798 | 56867.0 |
| 2024-07-31 19:00:00 | IWM | ETF | 224.28 | 224.78 | 224.2154 | 224.68 | 25034.0 |
| 2024-07-31 04:00:00 | DIA | ETF | 407.41 | 409.31 | 407.41 | 409.06 | 6939.0 |
| 2024-07-31 05:00:00 | DIA | ETF | 408.9 | 409.18 | 408.9 | 409.1 | 3330.0 |
> showing 50 of 21,149 rows — these rows as CSV