PREVIEW / etf_1hour / 2024-09-04
file: by_date/etf_1hour/2024/2024-09-04.parquet size: 553 KB rows: 20,822
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-04 04:00:00 | SPY | ETF | 550.13 | 550.72 | 549.85 | 550.18 | 26685.0 |
| 2024-09-04 05:00:00 | SPY | ETF | 550.17 | 550.9 | 550.0 | 550.47 | 17315.0 |
| 2024-09-04 06:00:00 | SPY | ETF | 550.69 | 550.69 | 549.75 | 549.75 | 8583.0 |
| 2024-09-04 07:00:00 | SPY | ETF | 549.79 | 550.34 | 549.46 | 549.85 | 100298.0 |
| 2024-09-04 08:00:00 | SPY | ETF | 549.6 | 550.78 | 548.66 | 550.6 | 222528.0 |
| 2024-09-04 09:00:00 | SPY | ETF | 550.51 | 552.555 | 550.03 | 552.49 | 3739233.0 |
| 2024-09-04 10:00:00 | SPY | ETF | 552.54 | 554.0 | 550.025 | 553.98 | 7129088.0 |
| 2024-09-04 11:00:00 | SPY | ETF | 553.97 | 554.43 | 551.34 | 551.8499 | 3466267.0 |
| 2024-09-04 12:00:00 | SPY | ETF | 551.82 | 553.09 | 551.07 | 552.34 | 2309376.0 |
| 2024-09-04 13:00:00 | SPY | ETF | 552.315 | 552.34 | 550.6811 | 550.95 | 2359114.0 |
| 2024-09-04 14:00:00 | SPY | ETF | 550.96 | 551.74 | 550.02 | 550.07 | 3114226.0 |
| 2024-09-04 15:00:00 | SPY | ETF | 550.07 | 551.96 | 549.46 | 550.84 | 8704589.0 |
| 2024-09-04 16:00:00 | SPY | ETF | 550.82 | 551.1458 | 549.88 | 550.72 | 4288767.0 |
| 2024-09-04 17:00:00 | SPY | ETF | 550.77 | 550.81 | 550.63 | 550.75 | 22701.0 |
| 2024-09-04 18:00:00 | SPY | ETF | 550.75 | 551.1602 | 550.75 | 551.01 | 39159.0 |
| 2024-09-04 19:00:00 | SPY | ETF | 550.95 | 550.95 | 549.52 | 550.28 | 96757.0 |
| 2024-09-04 04:00:00 | QQQ | ETF | 459.19 | 459.9 | 458.66 | 459.38 | 104796.0 |
| 2024-09-04 05:00:00 | QQQ | ETF | 459.4 | 460.23 | 459.17 | 459.8 | 37334.0 |
| 2024-09-04 06:00:00 | QQQ | ETF | 459.83 | 459.84 | 458.23 | 458.28 | 48964.0 |
| 2024-09-04 07:00:00 | QQQ | ETF | 458.33 | 458.83 | 457.9 | 458.64 | 123402.0 |
| 2024-09-04 08:00:00 | QQQ | ETF | 458.0 | 462.156 | 457.75 | 459.5 | 311211.0 |
| 2024-09-04 09:00:00 | QQQ | ETF | 459.41 | 461.44 | 458.24 | 461.01 | 3689543.0 |
| 2024-09-04 10:00:00 | QQQ | ETF | 460.94 | 463.99 | 457.73 | 463.9 | 5587810.0 |
| 2024-09-04 11:00:00 | QQQ | ETF | 463.84 | 464.45 | 461.14 | 461.8563 | 3830828.0 |
| 2024-09-04 12:00:00 | QQQ | ETF | 461.85 | 463.75 | 461.13 | 463.24 | 2051059.0 |
| 2024-09-04 13:00:00 | QQQ | ETF | 463.235 | 463.26 | 461.57 | 461.76 | 1733610.0 |
| 2024-09-04 14:00:00 | QQQ | ETF | 461.8 | 462.39 | 460.03 | 460.13 | 2383847.0 |
| 2024-09-04 15:00:00 | QQQ | ETF | 460.11 | 462.12 | 459.39 | 460.62 | 4328659.0 |
| 2024-09-04 16:00:00 | QQQ | ETF | 460.61 | 460.86 | 459.82 | 460.7996 | 1363062.0 |
| 2024-09-04 17:00:00 | QQQ | ETF | 460.78 | 460.88 | 460.443 | 460.84 | 22131.0 |
| 2024-09-04 18:00:00 | QQQ | ETF | 460.92 | 461.29 | 460.75 | 461.03 | 36223.0 |
| 2024-09-04 19:00:00 | QQQ | ETF | 461.01 | 461.08 | 459.07 | 459.96 | 74846.0 |
| 2024-09-04 04:00:00 | IWM | ETF | 212.42 | 213.17 | 212.42 | 212.58 | 18174.0 |
| 2024-09-04 05:00:00 | IWM | ETF | 212.53 | 213.0 | 212.37 | 212.72 | 12816.0 |
| 2024-09-04 06:00:00 | IWM | ETF | 212.8 | 212.8 | 212.22 | 212.41 | 27277.0 |
| 2024-09-04 07:00:00 | IWM | ETF | 212.42 | 212.78 | 212.27 | 212.28 | 136239.0 |
| 2024-09-04 08:00:00 | IWM | ETF | 212.29 | 212.99 | 212.11 | 212.99 | 243711.0 |
| 2024-09-04 09:00:00 | IWM | ETF | 212.92 | 213.67 | 212.17 | 213.495 | 2552869.0 |
| 2024-09-04 10:00:00 | IWM | ETF | 213.495 | 215.28 | 211.7 | 215.19 | 4742241.0 |
| 2024-09-04 11:00:00 | IWM | ETF | 215.195 | 215.37 | 213.53 | 213.65 | 1681526.0 |
| 2024-09-04 12:00:00 | IWM | ETF | 213.64 | 214.41 | 213.3 | 213.94 | 1015004.0 |
| 2024-09-04 13:00:00 | IWM | ETF | 213.91 | 213.97 | 212.91 | 213.065 | 1138519.0 |
| 2024-09-04 14:00:00 | IWM | ETF | 213.065 | 213.33 | 212.4 | 212.4 | 2150332.0 |
| 2024-09-04 15:00:00 | IWM | ETF | 212.405 | 213.26 | 212.22 | 212.96 | 3271318.0 |
| 2024-09-04 16:00:00 | IWM | ETF | 212.99 | 212.99 | 212.4 | 212.66 | 903686.0 |
| 2024-09-04 17:00:00 | IWM | ETF | 212.61 | 212.99 | 212.438 | 212.58 | 230226.0 |
| 2024-09-04 18:00:00 | IWM | ETF | 212.68 | 212.8871 | 212.63 | 212.751 | 28563.0 |
| 2024-09-04 19:00:00 | IWM | ETF | 212.75 | 212.77 | 212.33 | 212.59 | 12385.0 |
| 2024-09-04 07:00:00 | DIA | ETF | 409.41 | 409.66 | 409.41 | 409.66 | 1000.0 |
| 2024-09-04 08:00:00 | DIA | ETF | 409.35 | 409.8104 | 409.01 | 409.8104 | 2510.0 |
> showing 50 of 20,822 rows — these rows as CSV