PREVIEW / etf_1hour / 2024-08-26
file: by_date/etf_1hour/2024/2024-08-26.parquet size: 556 KB rows: 20,949
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-08-26 04:00:00 | SPY | ETF | 562.13 | 563.39 | 562.13 | 563.39 | 10810.0 |
| 2024-08-26 05:00:00 | SPY | ETF | 563.4 | 563.4 | 563.07 | 563.24 | 3291.0 |
| 2024-08-26 06:00:00 | SPY | ETF | 563.2 | 563.35 | 562.9 | 563.24 | 11743.0 |
| 2024-08-26 07:00:00 | SPY | ETF | 563.22 | 563.4 | 562.34 | 562.95 | 124256.0 |
| 2024-08-26 08:00:00 | SPY | ETF | 563.37 | 563.41 | 561.81 | 563.2 | 176415.0 |
| 2024-08-26 09:00:00 | SPY | ETF | 563.17 | 563.91 | 562.68 | 563.0 | 4234394.0 |
| 2024-08-26 10:00:00 | SPY | ETF | 563.02 | 563.1701 | 560.16 | 561.11 | 3998973.0 |
| 2024-08-26 11:00:00 | SPY | ETF | 561.1 | 561.33 | 559.78 | 559.995 | 2195583.0 |
| 2024-08-26 12:00:00 | SPY | ETF | 559.98 | 561.66 | 559.72 | 561.5 | 1942544.0 |
| 2024-08-26 13:00:00 | SPY | ETF | 561.48 | 561.71 | 559.2 | 559.5 | 1963586.0 |
| 2024-08-26 14:00:00 | SPY | ETF | 559.51 | 560.91 | 559.05 | 560.84 | 2298690.0 |
| 2024-08-26 15:00:00 | SPY | ETF | 560.82 | 560.89 | 559.85 | 560.73 | 6295736.0 |
| 2024-08-26 16:00:00 | SPY | ETF | 560.73 | 560.79 | 559.8 | 560.01 | 2554192.0 |
| 2024-08-26 17:00:00 | SPY | ETF | 560.01 | 560.23 | 559.84 | 559.93 | 62346.0 |
| 2024-08-26 18:00:00 | SPY | ETF | 559.95 | 560.3 | 559.32 | 559.59 | 62354.0 |
| 2024-08-26 19:00:00 | SPY | ETF | 559.6 | 560.31 | 559.6 | 560.29 | 23294.0 |
| 2024-08-26 04:00:00 | QQQ | ETF | 481.0 | 481.44 | 480.75 | 481.44 | 21176.0 |
| 2024-08-26 05:00:00 | QQQ | ETF | 481.39 | 481.39 | 481.05 | 481.25 | 23624.0 |
| 2024-08-26 06:00:00 | QQQ | ETF | 481.2 | 481.41 | 480.35 | 480.55 | 46691.0 |
| 2024-08-26 07:00:00 | QQQ | ETF | 480.6 | 480.81 | 479.1 | 479.74 | 137749.0 |
| 2024-08-26 08:00:00 | QQQ | ETF | 479.75 | 481.44 | 479.06 | 479.78 | 171915.0 |
| 2024-08-26 09:00:00 | QQQ | ETF | 479.68 | 480.38 | 478.18 | 478.44 | 2467328.0 |
| 2024-08-26 10:00:00 | QQQ | ETF | 478.46 | 478.6287 | 473.24 | 475.54 | 5267272.0 |
| 2024-08-26 11:00:00 | QQQ | ETF | 475.53 | 476.32 | 474.23 | 474.46 | 3013346.0 |
| 2024-08-26 12:00:00 | QQQ | ETF | 474.4 | 476.56 | 474.12 | 475.97 | 1900278.0 |
| 2024-08-26 13:00:00 | QQQ | ETF | 475.97 | 476.15 | 473.7 | 473.96 | 2382055.0 |
| 2024-08-26 14:00:00 | QQQ | ETF | 473.97 | 476.0 | 473.43 | 475.91 | 2233809.0 |
| 2024-08-26 15:00:00 | QQQ | ETF | 475.89 | 476.0917 | 474.48 | 475.33 | 3287766.0 |
| 2024-08-26 16:00:00 | QQQ | ETF | 475.33 | 475.41 | 474.26 | 474.3199 | 1339710.0 |
| 2024-08-26 17:00:00 | QQQ | ETF | 474.3 | 475.34 | 474.27 | 474.39 | 94367.0 |
| 2024-08-26 18:00:00 | QQQ | ETF | 474.54 | 474.85 | 473.66 | 473.97 | 77768.0 |
| 2024-08-26 19:00:00 | QQQ | ETF | 473.9 | 474.95 | 473.9 | 474.8 | 91841.0 |
| 2024-08-26 04:00:00 | IWM | ETF | 220.89 | 221.8 | 220.77 | 221.76 | 26127.0 |
| 2024-08-26 05:00:00 | IWM | ETF | 221.72 | 222.07 | 221.5 | 221.71 | 16748.0 |
| 2024-08-26 06:00:00 | IWM | ETF | 221.79 | 222.46 | 221.69 | 222.33 | 55670.0 |
| 2024-08-26 07:00:00 | IWM | ETF | 222.38 | 222.59 | 221.66 | 222.31 | 154221.0 |
| 2024-08-26 08:00:00 | IWM | ETF | 222.3808 | 222.55 | 220.22 | 222.22 | 157109.0 |
| 2024-08-26 09:00:00 | IWM | ETF | 222.22 | 222.33 | 220.84 | 222.07 | 2878714.0 |
| 2024-08-26 10:00:00 | IWM | ETF | 222.09 | 222.45 | 220.82 | 220.87 | 3664383.0 |
| 2024-08-26 11:00:00 | IWM | ETF | 220.84 | 221.22 | 220.15 | 220.67 | 2049747.0 |
| 2024-08-26 12:00:00 | IWM | ETF | 220.64 | 221.52 | 220.5 | 221.47 | 1403718.0 |
| 2024-08-26 13:00:00 | IWM | ETF | 221.47 | 221.79 | 220.415 | 220.68 | 1693486.0 |
| 2024-08-26 14:00:00 | IWM | ETF | 220.69 | 221.14 | 220.51 | 221.05 | 1239113.0 |
| 2024-08-26 15:00:00 | IWM | ETF | 221.05 | 221.29 | 220.08 | 220.42 | 3644744.0 |
| 2024-08-26 16:00:00 | IWM | ETF | 220.45 | 220.49 | 220.1 | 220.2 | 1045545.0 |
| 2024-08-26 17:00:00 | IWM | ETF | 220.22 | 220.28 | 220.14 | 220.189 | 6142.0 |
| 2024-08-26 18:00:00 | IWM | ETF | 220.22 | 220.53 | 220.12 | 220.23 | 28527.0 |
| 2024-08-26 19:00:00 | IWM | ETF | 220.23 | 220.69 | 220.23 | 220.58 | 52835.0 |
| 2024-08-26 04:00:00 | DIA | ETF | 412.35 | 412.37 | 412.33 | 412.33 | 1101.0 |
| 2024-08-26 05:00:00 | DIA | ETF | 412.39 | 412.39 | 412.16 | 412.23 | 1027.0 |
> showing 50 of 20,949 rows — these rows as CSV