PREVIEW / etf_1hour / 2024-01-10
file: by_date/etf_1hour/2024/2024-01-10.parquet size: 524 KB rows: 19,176
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-01-10 04:00:00 | SPY | ETF | 473.91 | 474.98 | 473.91 | 474.69 | 22257.0 |
| 2024-01-10 05:00:00 | SPY | ETF | 474.68 | 474.73 | 474.18 | 474.28 | 5717.0 |
| 2024-01-10 06:00:00 | SPY | ETF | 474.34 | 474.39 | 473.54 | 473.78 | 24028.0 |
| 2024-01-10 07:00:00 | SPY | ETF | 473.82 | 474.26 | 473.81 | 473.91 | 186659.0 |
| 2024-01-10 08:00:00 | SPY | ETF | 473.8 | 474.8696 | 473.23 | 473.61 | 180268.0 |
| 2024-01-10 09:00:00 | SPY | ETF | 473.59 | 475.34 | 473.4 | 474.71 | 5619940.0 |
| 2024-01-10 10:00:00 | SPY | ETF | 474.71 | 475.2503 | 473.87 | 475.22 | 5321542.0 |
| 2024-01-10 11:00:00 | SPY | ETF | 475.23 | 475.275 | 474.425 | 474.92 | 4416553.0 |
| 2024-01-10 12:00:00 | SPY | ETF | 474.93 | 475.475 | 474.6 | 475.3897 | 3765434.0 |
| 2024-01-10 13:00:00 | SPY | ETF | 475.39 | 475.9299 | 474.8101 | 475.753 | 5240086.0 |
| 2024-01-10 14:00:00 | SPY | ETF | 475.76 | 477.2801 | 475.675 | 477.25 | 6623595.0 |
| 2024-01-10 15:00:00 | SPY | ETF | 477.25 | 477.4481 | 475.18 | 476.52 | 14901837.0 |
| 2024-01-10 16:00:00 | SPY | ETF | 476.52 | 476.72 | 475.2887 | 476.65 | 5111838.0 |
| 2024-01-10 17:00:00 | SPY | ETF | 476.67 | 476.72 | 476.56 | 476.66 | 54955.0 |
| 2024-01-10 18:00:00 | SPY | ETF | 476.6 | 476.85 | 476.44 | 476.76 | 27450.0 |
| 2024-01-10 19:00:00 | SPY | ETF | 476.73 | 477.21 | 476.63 | 477.08 | 58507.0 |
| 2024-01-10 04:00:00 | QQQ | ETF | 406.46 | 407.62 | 406.36 | 407.44 | 43505.0 |
| 2024-01-10 05:00:00 | QQQ | ETF | 407.43 | 407.51 | 406.8 | 406.83 | 25855.0 |
| 2024-01-10 06:00:00 | QQQ | ETF | 406.84 | 407.15 | 405.97 | 406.24 | 66826.0 |
| 2024-01-10 07:00:00 | QQQ | ETF | 406.28 | 406.69 | 406.08 | 406.08 | 103946.0 |
| 2024-01-10 08:00:00 | QQQ | ETF | 406.2402 | 407.0304 | 405.4 | 405.52 | 242659.0 |
| 2024-01-10 09:00:00 | QQQ | ETF | 405.5 | 406.9 | 405.34 | 406.03 | 3625943.0 |
| 2024-01-10 10:00:00 | QQQ | ETF | 406.02 | 407.375 | 405.17 | 407.325 | 4189650.0 |
| 2024-01-10 11:00:00 | QQQ | ETF | 407.34 | 407.4584 | 406.44 | 407.03 | 2300221.0 |
| 2024-01-10 12:00:00 | QQQ | ETF | 407.04 | 407.87 | 406.79 | 407.79 | 1721070.0 |
| 2024-01-10 13:00:00 | QQQ | ETF | 407.8 | 408.29 | 407.2 | 408.12 | 2637074.0 |
| 2024-01-10 14:00:00 | QQQ | ETF | 408.125 | 409.4899 | 408.06 | 409.46 | 3152078.0 |
| 2024-01-10 15:00:00 | QQQ | ETF | 409.46 | 409.515 | 407.35 | 408.53 | 6378587.0 |
| 2024-01-10 16:00:00 | QQQ | ETF | 408.53 | 408.93 | 408.25 | 408.9 | 1149185.0 |
| 2024-01-10 17:00:00 | QQQ | ETF | 408.9 | 408.96 | 408.5 | 408.88 | 119230.0 |
| 2024-01-10 18:00:00 | QQQ | ETF | 408.88 | 409.15 | 408.65 | 409.0 | 49419.0 |
| 2024-01-10 19:00:00 | QQQ | ETF | 408.98 | 409.59 | 408.96 | 409.31 | 70358.0 |
| 2024-01-10 04:00:00 | IWM | ETF | 194.83 | 195.53 | 194.79 | 195.28 | 21995.0 |
| 2024-01-10 05:00:00 | IWM | ETF | 195.25 | 195.25 | 194.92 | 195.08 | 5345.0 |
| 2024-01-10 06:00:00 | IWM | ETF | 195.07 | 195.19 | 194.58 | 194.7 | 10235.0 |
| 2024-01-10 07:00:00 | IWM | ETF | 194.73 | 195.2 | 194.72 | 194.96 | 115634.0 |
| 2024-01-10 08:00:00 | IWM | ETF | 194.7896 | 195.4096 | 194.5 | 194.55 | 52846.0 |
| 2024-01-10 09:00:00 | IWM | ETF | 194.5 | 195.05 | 193.81 | 193.92 | 2897075.0 |
| 2024-01-10 10:00:00 | IWM | ETF | 193.91 | 194.675 | 193.08 | 194.54 | 5765013.0 |
| 2024-01-10 11:00:00 | IWM | ETF | 194.54 | 194.68 | 194.06 | 194.575 | 2009725.0 |
| 2024-01-10 12:00:00 | IWM | ETF | 194.58 | 194.72 | 194.3275 | 194.345 | 1615923.0 |
| 2024-01-10 13:00:00 | IWM | ETF | 194.34 | 195.02 | 194.085 | 194.93 | 2805620.0 |
| 2024-01-10 14:00:00 | IWM | ETF | 194.92 | 195.33 | 194.82 | 195.295 | 2227441.0 |
| 2024-01-10 15:00:00 | IWM | ETF | 195.29 | 195.375 | 194.18 | 195.04 | 7421596.0 |
| 2024-01-10 16:00:00 | IWM | ETF | 195.08 | 195.23 | 194.99 | 195.16 | 1195339.0 |
| 2024-01-10 17:00:00 | IWM | ETF | 195.17 | 195.35 | 195.05 | 195.16 | 134102.0 |
| 2024-01-10 18:00:00 | IWM | ETF | 195.09 | 195.42 | 194.99 | 195.3299 | 69734.0 |
| 2024-01-10 19:00:00 | IWM | ETF | 195.35 | 195.84 | 195.31 | 195.76 | 51931.0 |
| 2024-01-10 04:00:00 | DIA | ETF | 375.5 | 375.5 | 375.5 | 375.5 | 157.0 |
| 2024-01-10 05:00:00 | DIA | ETF | 375.35 | 375.35 | 375.33 | 375.33 | 2300.0 |
> showing 50 of 19,176 rows — these rows as CSV