PREVIEW / etf_1hour / 2024-08-30
file: by_date/etf_1hour/2024/2024-08-30.parquet size: 544 KB rows: 20,144
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-30 04:00:00 | SPY | ETF | 560.76 | 561.09 | 560.71 | 560.87 | 8630.0 |
| 2024-08-30 05:00:00 | SPY | ETF | 561.0 | 561.0 | 560.71 | 560.96 | 4257.0 |
| 2024-08-30 06:00:00 | SPY | ETF | 561.0 | 561.31 | 560.35 | 561.31 | 9283.0 |
| 2024-08-30 07:00:00 | SPY | ETF | 561.28 | 561.34 | 560.58 | 560.95 | 107376.0 |
| 2024-08-30 08:00:00 | SPY | ETF | 561.3 | 561.62 | 559.39 | 560.39 | 208485.0 |
| 2024-08-30 09:00:00 | SPY | ETF | 560.44 | 561.9295 | 560.25 | 561.7219 | 3373121.0 |
| 2024-08-30 10:00:00 | SPY | ETF | 561.73 | 562.25 | 559.96 | 559.98 | 3537910.0 |
| 2024-08-30 11:00:00 | SPY | ETF | 559.995 | 560.5 | 558.11 | 559.145 | 3717549.0 |
| 2024-08-30 12:00:00 | SPY | ETF | 559.13 | 559.67 | 557.14 | 559.1001 | 3049823.0 |
| 2024-08-30 13:00:00 | SPY | ETF | 559.1 | 559.84 | 558.57 | 558.867 | 1841780.0 |
| 2024-08-30 14:00:00 | SPY | ETF | 558.87 | 560.9395 | 558.6 | 560.7 | 4571940.0 |
| 2024-08-30 15:00:00 | SPY | ETF | 560.7 | 564.2 | 560.155 | 563.57 | 14694991.0 |
| 2024-08-30 16:00:00 | SPY | ETF | 563.55 | 563.86 | 563.03 | 563.351 | 5892108.0 |
| 2024-08-30 17:00:00 | SPY | ETF | 563.341 | 563.86 | 562.6 | 563.5996 | 3577182.0 |
| 2024-08-30 18:00:00 | SPY | ETF | 563.55 | 563.61 | 563.41 | 563.5003 | 12458.0 |
| 2024-08-30 19:00:00 | SPY | ETF | 563.62 | 563.62 | 563.3999 | 563.45 | 13993.0 |
| 2024-08-30 04:00:00 | QQQ | ETF | 474.12 | 474.35 | 473.73 | 474.07 | 33841.0 |
| 2024-08-30 05:00:00 | QQQ | ETF | 474.02 | 474.28 | 473.87 | 474.22 | 22202.0 |
| 2024-08-30 06:00:00 | QQQ | ETF | 474.33 | 474.67 | 473.66 | 474.67 | 57872.0 |
| 2024-08-30 07:00:00 | QQQ | ETF | 474.71 | 474.73 | 474.0 | 474.26 | 120196.0 |
| 2024-08-30 08:00:00 | QQQ | ETF | 474.64 | 475.42 | 472.15 | 474.25 | 395472.0 |
| 2024-08-30 09:00:00 | QQQ | ETF | 474.27 | 476.12 | 473.97 | 475.86 | 2997947.0 |
| 2024-08-30 10:00:00 | QQQ | ETF | 475.8801 | 476.73 | 472.83 | 472.86 | 4826626.0 |
| 2024-08-30 11:00:00 | QQQ | ETF | 472.84 | 473.72 | 471.57 | 472.71 | 3284238.0 |
| 2024-08-30 12:00:00 | QQQ | ETF | 472.72 | 473.2 | 470.51 | 472.74 | 2432430.0 |
| 2024-08-30 13:00:00 | QQQ | ETF | 472.72 | 473.56 | 472.14 | 472.345 | 1954349.0 |
| 2024-08-30 14:00:00 | QQQ | ETF | 472.36 | 474.55 | 472.04 | 474.2 | 2066374.0 |
| 2024-08-30 15:00:00 | QQQ | ETF | 474.18 | 476.9 | 473.46 | 476.39 | 5787909.0 |
| 2024-08-30 16:00:00 | QQQ | ETF | 476.39 | 476.71 | 475.9 | 476.0 | 1348043.0 |
| 2024-08-30 17:00:00 | QQQ | ETF | 475.9501 | 476.1771 | 475.9501 | 476.12 | 22154.0 |
| 2024-08-30 18:00:00 | QQQ | ETF | 476.1 | 476.1698 | 476.09 | 476.1698 | 14516.0 |
| 2024-08-30 19:00:00 | QQQ | ETF | 476.12 | 476.28 | 476.1 | 476.26 | 9790.0 |
| 2024-08-30 04:00:00 | IWM | ETF | 219.39 | 220.29 | 219.39 | 219.96 | 11730.0 |
| 2024-08-30 05:00:00 | IWM | ETF | 219.97 | 220.04 | 219.76 | 219.86 | 4619.0 |
| 2024-08-30 06:00:00 | IWM | ETF | 220.01 | 220.11 | 219.7 | 220.11 | 7929.0 |
| 2024-08-30 07:00:00 | IWM | ETF | 220.07 | 220.29 | 220.06 | 220.08 | 33509.0 |
| 2024-08-30 08:00:00 | IWM | ETF | 220.17 | 220.6496 | 219.32 | 219.98 | 269323.0 |
| 2024-08-30 09:00:00 | IWM | ETF | 219.94 | 220.5 | 219.04 | 219.4 | 2468455.0 |
| 2024-08-30 10:00:00 | IWM | ETF | 219.405 | 220.21 | 219.22 | 219.26 | 2559691.0 |
| 2024-08-30 11:00:00 | IWM | ETF | 219.265 | 219.59 | 218.21 | 218.4 | 2036508.0 |
| 2024-08-30 12:00:00 | IWM | ETF | 218.39 | 218.68 | 217.4 | 218.22 | 1788298.0 |
| 2024-08-30 13:00:00 | IWM | ETF | 218.22 | 218.47 | 217.84 | 218.215 | 1289138.0 |
| 2024-08-30 14:00:00 | IWM | ETF | 218.215 | 219.02 | 218.14 | 218.94 | 1122598.0 |
| 2024-08-30 15:00:00 | IWM | ETF | 218.95 | 220.39 | 218.675 | 220.04 | 4708090.0 |
| 2024-08-30 16:00:00 | IWM | ETF | 220.08 | 220.39 | 219.72 | 219.95 | 2397871.0 |
| 2024-08-30 17:00:00 | IWM | ETF | 219.94 | 220.12 | 219.93 | 220.12 | 10387.0 |
| 2024-08-30 18:00:00 | IWM | ETF | 220.08 | 220.08 | 219.76 | 220.0 | 25845.0 |
| 2024-08-30 19:00:00 | IWM | ETF | 219.82 | 219.98 | 219.8 | 219.88 | 4838.0 |
| 2024-08-30 04:00:00 | DIA | ETF | 414.81 | 414.81 | 414.81 | 414.81 | 200.0 |
| 2024-08-30 05:00:00 | DIA | ETF | 414.81 | 414.81 | 414.81 | 414.81 | 100.0 |
> showing 50 of 20,144 rows — these rows as CSV