PREVIEW / etf_1hour / 2024-10-07
file: by_date/etf_1hour/2024/2024-10-07.parquet size: 575 KB rows: 21,908
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-10-07 04:00:00 | SPY | ETF | 571.78 | 571.78 | 570.57 | 570.57 | 33926.0 |
| 2024-10-07 05:00:00 | SPY | ETF | 570.42 | 570.47 | 569.42 | 570.0 | 41221.0 |
| 2024-10-07 06:00:00 | SPY | ETF | 570.1 | 570.5 | 569.73 | 570.41 | 65677.0 |
| 2024-10-07 07:00:00 | SPY | ETF | 570.42 | 570.74 | 570.0 | 570.66 | 170550.0 |
| 2024-10-07 08:00:00 | SPY | ETF | 570.02 | 572.55 | 570.0 | 570.88 | 142116.0 |
| 2024-10-07 09:00:00 | SPY | ETF | 570.959 | 571.65 | 570.53 | 570.72 | 3396815.0 |
| 2024-10-07 10:00:00 | SPY | ETF | 570.72 | 571.9599 | 570.66 | 571.29 | 3385797.0 |
| 2024-10-07 11:00:00 | SPY | ETF | 571.25 | 571.7799 | 570.62 | 571.13 | 2452592.0 |
| 2024-10-07 12:00:00 | SPY | ETF | 571.13 | 571.18 | 570.12 | 570.61 | 2263028.0 |
| 2024-10-07 13:00:00 | SPY | ETF | 570.62 | 570.98 | 569.8253 | 570.43 | 1947690.0 |
| 2024-10-07 14:00:00 | SPY | ETF | 570.4201 | 570.47 | 566.63 | 566.8499 | 4661143.0 |
| 2024-10-07 15:00:00 | SPY | ETF | 566.83 | 568.6798 | 566.67 | 567.81 | 10810572.0 |
| 2024-10-07 16:00:00 | SPY | ETF | 567.83 | 568.46 | 567.77 | 568.05 | 2099393.0 |
| 2024-10-07 17:00:00 | SPY | ETF | 568.03 | 568.2 | 567.8 | 568.17 | 252386.0 |
| 2024-10-07 18:00:00 | SPY | ETF | 568.18 | 568.41 | 565.8 | 566.87 | 114492.0 |
| 2024-10-07 19:00:00 | SPY | ETF | 567.22 | 567.9411 | 567.18 | 567.7 | 31507.0 |
| 2024-10-07 04:00:00 | QQQ | ETF | 486.28 | 486.28 | 484.8 | 484.8 | 34027.0 |
| 2024-10-07 05:00:00 | QQQ | ETF | 484.8 | 484.8 | 483.56 | 484.3 | 61463.0 |
| 2024-10-07 06:00:00 | QQQ | ETF | 484.3 | 484.58 | 483.9 | 484.46 | 19884.0 |
| 2024-10-07 07:00:00 | QQQ | ETF | 484.56 | 484.9 | 484.09 | 484.75 | 101150.0 |
| 2024-10-07 08:00:00 | QQQ | ETF | 484.46 | 487.685 | 483.6604 | 485.0896 | 197010.0 |
| 2024-10-07 09:00:00 | QQQ | ETF | 485.15 | 486.04 | 484.25 | 484.76 | 2112453.0 |
| 2024-10-07 10:00:00 | QQQ | ETF | 484.76 | 486.57 | 484.6001 | 486.05 | 2315665.0 |
| 2024-10-07 11:00:00 | QQQ | ETF | 486.01 | 486.28 | 484.97 | 485.72 | 1462564.0 |
| 2024-10-07 12:00:00 | QQQ | ETF | 485.73 | 486.1 | 484.71 | 485.3599 | 1341917.0 |
| 2024-10-07 13:00:00 | QQQ | ETF | 485.37 | 486.0 | 484.85 | 485.6899 | 1114264.0 |
| 2024-10-07 14:00:00 | QQQ | ETF | 485.65 | 485.7692 | 481.19 | 481.36 | 3576365.0 |
| 2024-10-07 15:00:00 | QQQ | ETF | 481.36 | 482.79 | 480.87 | 482.06 | 4721999.0 |
| 2024-10-07 16:00:00 | QQQ | ETF | 482.06 | 482.86 | 482.0263 | 482.51 | 1425936.0 |
| 2024-10-07 17:00:00 | QQQ | ETF | 482.46 | 482.62 | 482.27 | 482.62 | 27595.0 |
| 2024-10-07 18:00:00 | QQQ | ETF | 482.7 | 482.79 | 479.81 | 481.34 | 194997.0 |
| 2024-10-07 19:00:00 | QQQ | ETF | 481.25 | 482.1 | 481.03 | 481.8034 | 56624.0 |
| 2024-10-07 04:00:00 | IWM | ETF | 218.35 | 218.54 | 217.97 | 217.98 | 23734.0 |
| 2024-10-07 05:00:00 | IWM | ETF | 217.9 | 217.93 | 217.4 | 217.72 | 21547.0 |
| 2024-10-07 06:00:00 | IWM | ETF | 217.75 | 218.25 | 217.6 | 217.97 | 76286.0 |
| 2024-10-07 07:00:00 | IWM | ETF | 217.98 | 218.44 | 217.72 | 218.4 | 121170.0 |
| 2024-10-07 08:00:00 | IWM | ETF | 218.1311 | 219.3 | 217.7 | 218.58 | 98608.0 |
| 2024-10-07 09:00:00 | IWM | ETF | 218.57 | 218.81 | 217.29 | 217.38 | 1988750.0 |
| 2024-10-07 10:00:00 | IWM | ETF | 217.4 | 218.33 | 217.24 | 217.62 | 1557616.0 |
| 2024-10-07 11:00:00 | IWM | ETF | 217.62 | 218.0763 | 217.25 | 217.438 | 940029.0 |
| 2024-10-07 12:00:00 | IWM | ETF | 217.43 | 217.85 | 217.17 | 217.77 | 752610.0 |
| 2024-10-07 13:00:00 | IWM | ETF | 217.795 | 217.862 | 217.13 | 217.36 | 574246.0 |
| 2024-10-07 14:00:00 | IWM | ETF | 217.38 | 217.39 | 215.87 | 216.1001 | 1671497.0 |
| 2024-10-07 15:00:00 | IWM | ETF | 216.1 | 217.63 | 216.04 | 217.45 | 2502656.0 |
| 2024-10-07 16:00:00 | IWM | ETF | 217.43 | 217.77 | 217.43 | 217.66 | 957813.0 |
| 2024-10-07 17:00:00 | IWM | ETF | 217.67 | 217.67 | 217.46 | 217.57 | 20405.0 |
| 2024-10-07 18:00:00 | IWM | ETF | 217.62 | 217.83 | 216.49 | 217.31 | 40479.0 |
| 2024-10-07 19:00:00 | IWM | ETF | 217.26 | 217.62 | 217.21 | 217.59 | 18510.0 |
| 2024-10-07 04:00:00 | DIA | ETF | 422.3 | 422.3 | 422.04 | 422.04 | 1050.0 |
| 2024-10-07 05:00:00 | DIA | ETF | 421.87 | 421.87 | 421.46 | 421.57 | 2261.0 |
> showing 50 of 21,908 rows — these rows as CSV