PREVIEW / etf_1hour / 2024-09-30
file: by_date/etf_1hour/2024/2024-09-30.parquet size: 585 KB rows: 22,160
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-30 04:00:00 | SPY | ETF | 571.5 | 571.6 | 570.85 | 571.14 | 26705.0 |
| 2024-09-30 05:00:00 | SPY | ETF | 570.96 | 571.42 | 570.68 | 571.33 | 14392.0 |
| 2024-09-30 06:00:00 | SPY | ETF | 571.25 | 571.42 | 570.75 | 571.0 | 9935.0 |
| 2024-09-30 07:00:00 | SPY | ETF | 570.9 | 570.9 | 569.8 | 570.02 | 152174.0 |
| 2024-09-30 08:00:00 | SPY | ETF | 570.7604 | 572.0 | 569.89 | 570.22 | 122221.0 |
| 2024-09-30 09:00:00 | SPY | ETF | 570.25 | 571.49 | 570.07 | 570.6492 | 2598982.0 |
| 2024-09-30 10:00:00 | SPY | ETF | 570.62 | 571.63 | 570.25 | 571.27 | 2515923.0 |
| 2024-09-30 11:00:00 | SPY | ETF | 571.29 | 571.82 | 570.7311 | 571.565 | 2170464.0 |
| 2024-09-30 12:00:00 | SPY | ETF | 571.57 | 572.26 | 571.5376 | 571.58 | 1980019.0 |
| 2024-09-30 13:00:00 | SPY | ETF | 571.57 | 571.71 | 570.91 | 571.59 | 1910070.0 |
| 2024-09-30 14:00:00 | SPY | ETF | 571.58 | 571.63 | 568.08 | 570.541 | 6987542.0 |
| 2024-09-30 15:00:00 | SPY | ETF | 570.55 | 574.38 | 569.93 | 574.02 | 14692190.0 |
| 2024-09-30 16:00:00 | SPY | ETF | 574.02 | 574.1 | 572.9575 | 572.96 | 7764350.0 |
| 2024-09-30 17:00:00 | SPY | ETF | 572.96 | 573.3 | 572.86 | 573.18 | 294403.0 |
| 2024-09-30 18:00:00 | SPY | ETF | 573.17 | 573.26 | 572.56 | 573.1 | 121517.0 |
| 2024-09-30 19:00:00 | SPY | ETF | 573.05 | 573.27 | 572.84 | 573.24 | 30324.0 |
| 2024-09-30 04:00:00 | QQQ | ETF | 486.86 | 486.89 | 485.7 | 486.08 | 53590.0 |
| 2024-09-30 05:00:00 | QQQ | ETF | 486.03 | 486.48 | 485.56 | 486.28 | 34909.0 |
| 2024-09-30 06:00:00 | QQQ | ETF | 486.34 | 486.7 | 485.95 | 486.28 | 25085.0 |
| 2024-09-30 07:00:00 | QQQ | ETF | 486.15 | 486.23 | 484.38 | 484.62 | 114668.0 |
| 2024-09-30 08:00:00 | QQQ | ETF | 485.15 | 487.32 | 484.4 | 485.6098 | 444400.0 |
| 2024-09-30 09:00:00 | QQQ | ETF | 485.6 | 487.79 | 485.44 | 486.4099 | 2443830.0 |
| 2024-09-30 10:00:00 | QQQ | ETF | 486.43 | 486.8 | 484.59 | 485.808 | 2379513.0 |
| 2024-09-30 11:00:00 | QQQ | ETF | 485.77 | 487.12 | 485.5203 | 486.46 | 1601208.0 |
| 2024-09-30 12:00:00 | QQQ | ETF | 486.47 | 487.58 | 486.4 | 486.5899 | 1404238.0 |
| 2024-09-30 13:00:00 | QQQ | ETF | 486.585 | 486.6975 | 485.56 | 486.4401 | 1479990.0 |
| 2024-09-30 14:00:00 | QQQ | ETF | 486.43 | 486.585 | 482.92 | 485.0511 | 4408076.0 |
| 2024-09-30 15:00:00 | QQQ | ETF | 485.04 | 488.41 | 484.39 | 488.05 | 6540692.0 |
| 2024-09-30 16:00:00 | QQQ | ETF | 488.05 | 488.2 | 487.12 | 487.18 | 1590265.0 |
| 2024-09-30 17:00:00 | QQQ | ETF | 487.17 | 487.45 | 487.07 | 487.4 | 47847.0 |
| 2024-09-30 18:00:00 | QQQ | ETF | 487.25 | 487.33 | 486.71 | 487.13 | 25248.0 |
| 2024-09-30 19:00:00 | QQQ | ETF | 487.15 | 487.5298 | 486.89 | 487.48 | 25644.0 |
| 2024-09-30 04:00:00 | IWM | ETF | 220.31 | 220.37 | 219.31 | 219.48 | 45712.0 |
| 2024-09-30 05:00:00 | IWM | ETF | 219.36 | 219.5 | 218.89 | 219.38 | 21690.0 |
| 2024-09-30 06:00:00 | IWM | ETF | 219.36 | 219.53 | 218.96 | 219.25 | 27315.0 |
| 2024-09-30 07:00:00 | IWM | ETF | 219.23 | 219.31 | 218.75 | 218.91 | 56904.0 |
| 2024-09-30 08:00:00 | IWM | ETF | 218.9 | 220.68 | 218.78 | 219.12 | 66133.0 |
| 2024-09-30 09:00:00 | IWM | ETF | 219.07 | 221.07 | 219.0135 | 220.75 | 2357599.0 |
| 2024-09-30 10:00:00 | IWM | ETF | 220.72 | 221.47 | 220.41 | 220.865 | 1862171.0 |
| 2024-09-30 11:00:00 | IWM | ETF | 220.86 | 221.59 | 220.439 | 220.55 | 1056179.0 |
| 2024-09-30 12:00:00 | IWM | ETF | 220.58 | 221.26 | 220.47 | 221.14 | 726327.0 |
| 2024-09-30 13:00:00 | IWM | ETF | 221.12 | 221.21 | 220.565 | 220.65 | 775588.0 |
| 2024-09-30 14:00:00 | IWM | ETF | 220.62 | 220.67 | 218.58 | 219.79 | 3004380.0 |
| 2024-09-30 15:00:00 | IWM | ETF | 219.76 | 221.235 | 219.35 | 220.95 | 4456721.0 |
| 2024-09-30 16:00:00 | IWM | ETF | 220.89 | 220.96 | 220.5 | 220.74 | 2650120.0 |
| 2024-09-30 17:00:00 | IWM | ETF | 220.64 | 220.7 | 220.31 | 220.5501 | 53079.0 |
| 2024-09-30 18:00:00 | IWM | ETF | 220.62 | 220.83 | 220.38 | 220.6 | 21578.0 |
| 2024-09-30 19:00:00 | IWM | ETF | 220.62 | 220.66 | 220.44 | 220.61 | 5512.0 |
| 2024-09-30 04:00:00 | DIA | ETF | 422.68 | 422.68 | 422.68 | 422.68 | 250.0 |
| 2024-09-30 06:00:00 | DIA | ETF | 422.63 | 422.63 | 422.63 | 422.63 | 500.0 |
> showing 50 of 22,160 rows — these rows as CSV