PREVIEW / etf_1hour / 2024-11-01
file: by_date/etf_1hour/2024/2024-11-01.parquet size: 580 KB rows: 21,473
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-11-01 04:00:00 | SPY | ETF | 570.19 | 570.94 | 570.19 | 570.52 | 43092.0 |
| 2024-11-01 05:00:00 | SPY | ETF | 570.59 | 571.0 | 570.55 | 570.78 | 16203.0 |
| 2024-11-01 06:00:00 | SPY | ETF | 570.88 | 571.59 | 570.88 | 571.43 | 269125.0 |
| 2024-11-01 07:00:00 | SPY | ETF | 571.42 | 571.65 | 570.8 | 571.37 | 337112.0 |
| 2024-11-01 08:00:00 | SPY | ETF | 571.4 | 572.17 | 569.37 | 571.8 | 934992.0 |
| 2024-11-01 09:00:00 | SPY | ETF | 571.83 | 573.3599 | 570.68 | 573.12 | 4071138.0 |
| 2024-11-01 10:00:00 | SPY | ETF | 573.13 | 575.55 | 572.64 | 574.435 | 5633589.0 |
| 2024-11-01 11:00:00 | SPY | ETF | 574.42 | 575.3 | 573.36 | 573.65 | 3135273.0 |
| 2024-11-01 12:00:00 | SPY | ETF | 573.63 | 574.3099 | 572.66 | 573.0 | 1854604.0 |
| 2024-11-01 13:00:00 | SPY | ETF | 573.03 | 573.8669 | 571.6 | 571.6499 | 2828330.0 |
| 2024-11-01 14:00:00 | SPY | ETF | 571.64 | 572.46 | 571.14 | 572.17 | 2267719.0 |
| 2024-11-01 15:00:00 | SPY | ETF | 572.15 | 572.94 | 570.62 | 571.02 | 7781251.0 |
| 2024-11-01 16:00:00 | SPY | ETF | 571.0 | 571.85 | 570.96 | 571.26 | 1624747.0 |
| 2024-11-01 17:00:00 | SPY | ETF | 571.25 | 571.77 | 571.04 | 571.41 | 192894.0 |
| 2024-11-01 18:00:00 | SPY | ETF | 571.5 | 571.82 | 571.02 | 571.09 | 51184.0 |
| 2024-11-01 19:00:00 | SPY | ETF | 571.2 | 571.5 | 570.75 | 571.3 | 52266.0 |
| 2024-11-01 04:00:00 | QQQ | ETF | 486.05 | 486.5 | 485.81 | 486.11 | 37953.0 |
| 2024-11-01 05:00:00 | QQQ | ETF | 486.13 | 486.53 | 485.96 | 486.13 | 37468.0 |
| 2024-11-01 06:00:00 | QQQ | ETF | 486.0 | 486.7 | 486.0 | 486.56 | 65366.0 |
| 2024-11-01 07:00:00 | QQQ | ETF | 486.52 | 486.97 | 486.11 | 486.46 | 152236.0 |
| 2024-11-01 08:00:00 | QQQ | ETF | 486.48 | 487.35 | 485.25 | 486.56 | 575146.0 |
| 2024-11-01 09:00:00 | QQQ | ETF | 486.58 | 488.09 | 485.2 | 487.87 | 3153605.0 |
| 2024-11-01 10:00:00 | QQQ | ETF | 487.89 | 490.48 | 487.06 | 489.53 | 4816554.0 |
| 2024-11-01 11:00:00 | QQQ | ETF | 489.4991 | 490.7507 | 488.88 | 489.22 | 2428307.0 |
| 2024-11-01 12:00:00 | QQQ | ETF | 489.18 | 489.95 | 488.465 | 488.9209 | 1261148.0 |
| 2024-11-01 13:00:00 | QQQ | ETF | 488.95 | 489.91 | 487.62 | 487.66 | 2743934.0 |
| 2024-11-01 14:00:00 | QQQ | ETF | 487.65 | 488.17 | 486.94 | 487.84 | 2253630.0 |
| 2024-11-01 15:00:00 | QQQ | ETF | 487.83 | 488.73 | 486.8 | 487.4 | 4912513.0 |
| 2024-11-01 16:00:00 | QQQ | ETF | 487.38 | 488.27 | 487.36 | 487.95 | 1191093.0 |
| 2024-11-01 17:00:00 | QQQ | ETF | 487.91 | 488.6 | 487.43 | 488.45 | 109924.0 |
| 2024-11-01 18:00:00 | QQQ | ETF | 488.4982 | 488.7 | 488.31 | 488.31 | 17381.0 |
| 2024-11-01 19:00:00 | QQQ | ETF | 488.27 | 488.37 | 488.01 | 488.2 | 6402.0 |
| 2024-11-01 04:00:00 | IWM | ETF | 217.48 | 218.06 | 217.46 | 217.5 | 31576.0 |
| 2024-11-01 05:00:00 | IWM | ETF | 217.6 | 217.92 | 217.57 | 217.89 | 5396.0 |
| 2024-11-01 06:00:00 | IWM | ETF | 217.95 | 218.28 | 217.95 | 218.23 | 106810.0 |
| 2024-11-01 07:00:00 | IWM | ETF | 218.2 | 218.69 | 218.05 | 218.37 | 108027.0 |
| 2024-11-01 08:00:00 | IWM | ETF | 218.41 | 219.8 | 217.45 | 219.73 | 760376.0 |
| 2024-11-01 09:00:00 | IWM | ETF | 219.69 | 220.43 | 217.76 | 220.35 | 2447711.0 |
| 2024-11-01 10:00:00 | IWM | ETF | 220.37 | 220.97 | 219.25 | 219.77 | 3486694.0 |
| 2024-11-01 11:00:00 | IWM | ETF | 219.775 | 220.35 | 219.329 | 219.708 | 1807104.0 |
| 2024-11-01 12:00:00 | IWM | ETF | 219.6976 | 220.12 | 218.834 | 218.88 | 1138395.0 |
| 2024-11-01 13:00:00 | IWM | ETF | 218.89 | 219.39 | 218.39 | 218.54 | 1743768.0 |
| 2024-11-01 14:00:00 | IWM | ETF | 218.52 | 219.24 | 218.34 | 219.16 | 935414.0 |
| 2024-11-01 15:00:00 | IWM | ETF | 219.15 | 219.28 | 218.55 | 219.0 | 2783805.0 |
| 2024-11-01 16:00:00 | IWM | ETF | 218.98 | 219.26 | 218.9 | 219.01 | 1045273.0 |
| 2024-11-01 17:00:00 | IWM | ETF | 219.0 | 219.2488 | 218.86 | 218.97 | 115584.0 |
| 2024-11-01 18:00:00 | IWM | ETF | 219.09 | 219.19 | 218.91 | 218.97 | 8641.0 |
| 2024-11-01 19:00:00 | IWM | ETF | 218.98 | 219.02 | 218.64 | 218.98 | 4855.0 |
| 2024-11-01 04:00:00 | DIA | ETF | 418.28 | 418.58 | 418.22 | 418.54 | 2822.0 |
| 2024-11-01 05:00:00 | DIA | ETF | 418.71 | 418.85 | 418.71 | 418.85 | 414.0 |
> showing 50 of 21,473 rows — these rows as CSV