PREVIEW / etf_1hour / 2024-07-19
file: by_date/etf_1hour/2024/2024-07-19.parquet size: 516 KB rows: 19,459
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-19 04:00:00 | SPY | ETF | 551.62 | 552.4 | 551.07 | 552.02 | 25900.0 |
| 2024-07-19 05:00:00 | SPY | ETF | 552.14 | 552.72 | 551.56 | 552.34 | 30366.0 |
| 2024-07-19 06:00:00 | SPY | ETF | 552.6 | 553.44 | 552.6 | 552.81 | 34535.0 |
| 2024-07-19 07:00:00 | SPY | ETF | 552.76 | 553.78 | 552.65 | 553.55 | 196710.0 |
| 2024-07-19 08:00:00 | SPY | ETF | 552.98 | 554.33 | 551.11 | 553.89 | 234244.0 |
| 2024-07-19 09:00:00 | SPY | ETF | 553.94 | 554.08 | 551.8 | 552.99 | 3780863.0 |
| 2024-07-19 10:00:00 | SPY | ETF | 552.985 | 553.295 | 550.66 | 551.12 | 3710257.0 |
| 2024-07-19 11:00:00 | SPY | ETF | 551.16 | 551.99 | 549.2172 | 551.0644 | 4325843.0 |
| 2024-07-19 12:00:00 | SPY | ETF | 551.03 | 551.49 | 548.92 | 549.3599 | 3388053.0 |
| 2024-07-19 13:00:00 | SPY | ETF | 549.355 | 549.44 | 547.91 | 549.42 | 3492881.0 |
| 2024-07-19 14:00:00 | SPY | ETF | 549.4 | 549.716 | 548.02 | 549.12 | 3746670.0 |
| 2024-07-19 15:00:00 | SPY | ETF | 549.13 | 550.46 | 548.14 | 548.93 | 10586616.0 |
| 2024-07-19 16:00:00 | SPY | ETF | 548.95 | 549.56 | 548.32 | 548.92 | 3554797.0 |
| 2024-07-19 17:00:00 | SPY | ETF | 548.81 | 548.99 | 548.5 | 548.5 | 121212.0 |
| 2024-07-19 18:00:00 | SPY | ETF | 548.64 | 548.86 | 548.64 | 548.79 | 22906.0 |
| 2024-07-19 19:00:00 | SPY | ETF | 548.82 | 549.05 | 548.6 | 549.05 | 41344.0 |
| 2024-07-19 04:00:00 | QQQ | ETF | 477.46 | 478.97 | 477.19 | 478.51 | 173404.0 |
| 2024-07-19 05:00:00 | QQQ | ETF | 478.33 | 479.07 | 477.73 | 478.77 | 132273.0 |
| 2024-07-19 06:00:00 | QQQ | ETF | 478.68 | 480.04 | 478.68 | 479.19 | 150337.0 |
| 2024-07-19 07:00:00 | QQQ | ETF | 479.21 | 480.88 | 479.09 | 480.43 | 211267.0 |
| 2024-07-19 08:00:00 | QQQ | ETF | 480.2 | 481.76 | 476.8 | 480.92 | 329495.0 |
| 2024-07-19 09:00:00 | QQQ | ETF | 480.89 | 481.69 | 478.34 | 479.5091 | 4089814.0 |
| 2024-07-19 10:00:00 | QQQ | ETF | 479.52 | 480.28 | 476.8974 | 478.105 | 4073478.0 |
| 2024-07-19 11:00:00 | QQQ | ETF | 478.13 | 479.28 | 475.19 | 477.87 | 3679281.0 |
| 2024-07-19 12:00:00 | QQQ | ETF | 477.83 | 478.09 | 474.73 | 475.75 | 2860590.0 |
| 2024-07-19 13:00:00 | QQQ | ETF | 475.76 | 475.8 | 473.94 | 475.58 | 2605653.0 |
| 2024-07-19 14:00:00 | QQQ | ETF | 475.57 | 476.16 | 474.34 | 475.56 | 2049942.0 |
| 2024-07-19 15:00:00 | QQQ | ETF | 475.5525 | 477.07 | 474.64 | 475.24 | 5643669.0 |
| 2024-07-19 16:00:00 | QQQ | ETF | 475.23 | 475.85 | 474.84 | 475.0313 | 2477925.0 |
| 2024-07-19 17:00:00 | QQQ | ETF | 475.06 | 475.24 | 474.91 | 474.95 | 216240.0 |
| 2024-07-19 18:00:00 | QQQ | ETF | 474.97 | 475.05 | 474.87 | 475.05 | 19918.0 |
| 2024-07-19 19:00:00 | QQQ | ETF | 475.01 | 475.16 | 474.91 | 475.0 | 28399.0 |
| 2024-07-19 04:00:00 | IWM | ETF | 217.55 | 218.18 | 216.96 | 216.98 | 45271.0 |
| 2024-07-19 05:00:00 | IWM | ETF | 216.98 | 217.09 | 216.62 | 216.71 | 40845.0 |
| 2024-07-19 06:00:00 | IWM | ETF | 216.67 | 218.28 | 216.67 | 217.85 | 117295.0 |
| 2024-07-19 07:00:00 | IWM | ETF | 217.77 | 218.42 | 217.77 | 218.28 | 165389.0 |
| 2024-07-19 08:00:00 | IWM | ETF | 217.8096 | 218.86 | 216.69 | 218.72 | 268788.0 |
| 2024-07-19 09:00:00 | IWM | ETF | 218.65 | 218.73 | 216.62 | 218.45 | 4067013.0 |
| 2024-07-19 10:00:00 | IWM | ETF | 218.44 | 218.59 | 216.6185 | 216.94 | 3656981.0 |
| 2024-07-19 11:00:00 | IWM | ETF | 216.94 | 217.27 | 215.85 | 217.27 | 3591991.0 |
| 2024-07-19 12:00:00 | IWM | ETF | 217.26 | 217.76 | 216.69 | 217.145 | 2789122.0 |
| 2024-07-19 13:00:00 | IWM | ETF | 217.14 | 217.38 | 216.44 | 217.37 | 2107905.0 |
| 2024-07-19 14:00:00 | IWM | ETF | 217.36 | 217.375 | 216.22 | 216.6499 | 2265104.0 |
| 2024-07-19 15:00:00 | IWM | ETF | 216.66 | 217.46 | 216.335 | 216.79 | 4977744.0 |
| 2024-07-19 16:00:00 | IWM | ETF | 216.84 | 216.95 | 216.46 | 216.91 | 1041952.0 |
| 2024-07-19 17:00:00 | IWM | ETF | 216.85 | 216.85 | 216.56 | 216.77 | 118021.0 |
| 2024-07-19 18:00:00 | IWM | ETF | 216.6641 | 216.93 | 216.6641 | 216.9 | 15229.0 |
| 2024-07-19 19:00:00 | IWM | ETF | 216.84 | 216.84 | 216.6 | 216.8 | 7020.0 |
| 2024-07-19 04:00:00 | DIA | ETF | 406.28 | 406.28 | 405.6 | 405.97 | 1100.0 |
| 2024-07-19 05:00:00 | DIA | ETF | 405.57 | 405.8 | 405.5 | 405.8 | 951.0 |
> showing 50 of 19,459 rows — these rows as CSV