PREVIEW / etf_1hour / 2023-10-30
file: by_date/etf_1hour/2023/2023-10-30.parquet size: 496 KB rows: 18,198
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-30 04:00:00 | SPY | ETF | 412.42 | 413.38 | 412.42 | 412.99 | 41996.0 |
| 2023-10-30 05:00:00 | SPY | ETF | 413.0 | 413.67 | 413.0 | 413.4 | 26154.0 |
| 2023-10-30 06:00:00 | SPY | ETF | 413.5 | 413.55 | 413.05 | 413.29 | 64486.0 |
| 2023-10-30 07:00:00 | SPY | ETF | 413.25 | 413.85 | 413.14 | 413.63 | 258109.0 |
| 2023-10-30 08:00:00 | SPY | ETF | 413.42 | 413.85 | 412.28 | 413.14 | 293430.0 |
| 2023-10-30 09:00:00 | SPY | ETF | 413.14 | 415.345 | 413.08 | 414.9 | 6960810.0 |
| 2023-10-30 10:00:00 | SPY | ETF | 414.895 | 415.03 | 412.22 | 413.02 | 12102608.0 |
| 2023-10-30 11:00:00 | SPY | ETF | 413.03 | 414.05 | 412.43 | 413.985 | 6757663.0 |
| 2023-10-30 12:00:00 | SPY | ETF | 413.97 | 414.2599 | 412.61 | 413.2196 | 5362787.0 |
| 2023-10-30 13:00:00 | SPY | ETF | 413.23 | 415.72 | 412.96 | 415.68 | 7063938.0 |
| 2023-10-30 14:00:00 | SPY | ETF | 415.68 | 416.295 | 415.01 | 415.83 | 7623359.0 |
| 2023-10-30 15:00:00 | SPY | ETF | 415.84 | 416.68 | 415.46 | 415.58 | 18691888.0 |
| 2023-10-30 16:00:00 | SPY | ETF | 415.59 | 415.69 | 412.9081 | 415.43 | 3699774.0 |
| 2023-10-30 17:00:00 | SPY | ETF | 415.36 | 415.45 | 415.21 | 415.36 | 93943.0 |
| 2023-10-30 18:00:00 | SPY | ETF | 415.34 | 415.39 | 415.11 | 415.32 | 66677.0 |
| 2023-10-30 19:00:00 | SPY | ETF | 415.28 | 415.4 | 415.13 | 415.18 | 28682.0 |
| 2023-10-30 04:00:00 | QQQ | ETF | 348.04 | 348.25 | 347.58 | 347.76 | 91824.0 |
| 2023-10-30 05:00:00 | QQQ | ETF | 347.86 | 348.5 | 347.86 | 348.19 | 19291.0 |
| 2023-10-30 06:00:00 | QQQ | ETF | 348.15 | 348.2 | 347.8 | 347.99 | 32488.0 |
| 2023-10-30 07:00:00 | QQQ | ETF | 347.93 | 348.49 | 347.861 | 348.21 | 161965.0 |
| 2023-10-30 08:00:00 | QQQ | ETF | 347.99 | 348.4504 | 345.568 | 347.7 | 363174.0 |
| 2023-10-30 09:00:00 | QQQ | ETF | 347.73 | 350.54 | 347.11 | 349.91 | 6206789.0 |
| 2023-10-30 10:00:00 | QQQ | ETF | 349.915 | 350.1 | 346.45 | 347.3588 | 9489479.0 |
| 2023-10-30 11:00:00 | QQQ | ETF | 347.37 | 348.64 | 346.82 | 348.57 | 4877433.0 |
| 2023-10-30 12:00:00 | QQQ | ETF | 348.56 | 348.66 | 346.55 | 347.01 | 4017080.0 |
| 2023-10-30 13:00:00 | QQQ | ETF | 347.01 | 349.41 | 346.795 | 349.33 | 4123122.0 |
| 2023-10-30 14:00:00 | QQQ | ETF | 349.31 | 349.94 | 348.68 | 349.57 | 4028053.0 |
| 2023-10-30 15:00:00 | QQQ | ETF | 349.58 | 350.44 | 349.005 | 349.15 | 7214457.0 |
| 2023-10-30 16:00:00 | QQQ | ETF | 349.13 | 349.24 | 348.8 | 348.99 | 1588510.0 |
| 2023-10-30 17:00:00 | QQQ | ETF | 348.97 | 349.01 | 348.88 | 348.9 | 68575.0 |
| 2023-10-30 18:00:00 | QQQ | ETF | 348.96 | 349.1 | 348.81 | 348.9 | 53414.0 |
| 2023-10-30 19:00:00 | QQQ | ETF | 348.87 | 348.95 | 348.65 | 348.65 | 45233.0 |
| 2023-10-30 04:00:00 | IWM | ETF | 162.7 | 163.7 | 162.7 | 163.57 | 16028.0 |
| 2023-10-30 05:00:00 | IWM | ETF | 163.61 | 163.88 | 163.6 | 163.74 | 8809.0 |
| 2023-10-30 06:00:00 | IWM | ETF | 163.78 | 163.78 | 163.57 | 163.63 | 17412.0 |
| 2023-10-30 07:00:00 | IWM | ETF | 163.64 | 163.96 | 163.63 | 163.78 | 111512.0 |
| 2023-10-30 08:00:00 | IWM | ETF | 163.9893 | 163.9893 | 163.27 | 163.4 | 71112.0 |
| 2023-10-30 09:00:00 | IWM | ETF | 163.45 | 164.81 | 163.2197 | 163.52 | 4929029.0 |
| 2023-10-30 10:00:00 | IWM | ETF | 163.51 | 163.7599 | 161.94 | 162.26 | 5155849.0 |
| 2023-10-30 11:00:00 | IWM | ETF | 162.26 | 162.93 | 162.25 | 162.7699 | 3413449.0 |
| 2023-10-30 12:00:00 | IWM | ETF | 162.76 | 162.95 | 162.025 | 162.3199 | 2372021.0 |
| 2023-10-30 13:00:00 | IWM | ETF | 162.31 | 163.28 | 162.25 | 163.2699 | 3092242.0 |
| 2023-10-30 14:00:00 | IWM | ETF | 163.26 | 163.54 | 163.0 | 163.21 | 2376577.0 |
| 2023-10-30 15:00:00 | IWM | ETF | 163.22 | 163.91 | 163.06 | 163.14 | 5429300.0 |
| 2023-10-30 16:00:00 | IWM | ETF | 163.13 | 163.22 | 162.94 | 162.95 | 793842.0 |
| 2023-10-30 17:00:00 | IWM | ETF | 162.97 | 162.97 | 162.75 | 162.9 | 59930.0 |
| 2023-10-30 18:00:00 | IWM | ETF | 162.9 | 162.97 | 162.85 | 162.94 | 56216.0 |
| 2023-10-30 19:00:00 | IWM | ETF | 162.89 | 162.99 | 162.85 | 162.88 | 31641.0 |
| 2023-10-30 04:00:00 | DIA | ETF | 325.63 | 325.64 | 325.47 | 325.48 | 1017.0 |
| 2023-10-30 06:00:00 | DIA | ETF | 325.82 | 325.82 | 325.82 | 325.82 | 200.0 |
> showing 50 of 18,198 rows — these rows as CSV