PREVIEW / etf_1hour / 2024-08-29
file: by_date/etf_1hour/2024/2024-08-29.parquet size: 545 KB rows: 20,375
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-29 04:00:00 | SPY | ETF | 557.22 | 558.83 | 557.22 | 558.62 | 80848.0 |
| 2024-08-29 05:00:00 | SPY | ETF | 558.63 | 560.06 | 558.61 | 559.91 | 36821.0 |
| 2024-08-29 06:00:00 | SPY | ETF | 559.9 | 560.2 | 559.09 | 559.34 | 61167.0 |
| 2024-08-29 07:00:00 | SPY | ETF | 559.26 | 560.21 | 558.77 | 559.75 | 299383.0 |
| 2024-08-29 08:00:00 | SPY | ETF | 559.08 | 560.82 | 556.38 | 559.83 | 482406.0 |
| 2024-08-29 09:00:00 | SPY | ETF | 559.84 | 561.28 | 559.37 | 561.1 | 4331591.0 |
| 2024-08-29 10:00:00 | SPY | ETF | 561.1 | 562.8 | 560.1 | 562.12 | 4154850.0 |
| 2024-08-29 11:00:00 | SPY | ETF | 562.09 | 563.19 | 561.47 | 562.48 | 2162662.0 |
| 2024-08-29 12:00:00 | SPY | ETF | 562.48 | 563.68 | 562.42 | 563.11 | 2292071.0 |
| 2024-08-29 13:00:00 | SPY | ETF | 563.12 | 563.12 | 561.96 | 562.85 | 1736870.0 |
| 2024-08-29 14:00:00 | SPY | ETF | 562.8 | 562.84 | 557.18 | 558.493 | 5040424.0 |
| 2024-08-29 15:00:00 | SPY | ETF | 558.48 | 559.95 | 557.53 | 558.315 | 6925979.0 |
| 2024-08-29 16:00:00 | SPY | ETF | 558.32 | 559.37 | 558.32 | 559.11 | 2167601.0 |
| 2024-08-29 17:00:00 | SPY | ETF | 559.1 | 559.4 | 559.02 | 559.21 | 46205.0 |
| 2024-08-29 18:00:00 | SPY | ETF | 559.3 | 559.5 | 558.6 | 558.929 | 29355.0 |
| 2024-08-29 19:00:00 | SPY | ETF | 558.8 | 559.03 | 558.75 | 558.86 | 17599.0 |
| 2024-08-29 04:00:00 | QQQ | ETF | 469.72 | 471.42 | 468.38 | 471.17 | 137255.0 |
| 2024-08-29 05:00:00 | QQQ | ETF | 471.18 | 473.36 | 471.09 | 472.99 | 143775.0 |
| 2024-08-29 06:00:00 | QQQ | ETF | 473.09 | 473.61 | 471.76 | 472.07 | 91940.0 |
| 2024-08-29 07:00:00 | QQQ | ETF | 472.01 | 473.09 | 471.34 | 472.5 | 242411.0 |
| 2024-08-29 08:00:00 | QQQ | ETF | 471.92 | 473.56 | 467.9 | 472.56 | 518969.0 |
| 2024-08-29 09:00:00 | QQQ | ETF | 472.61 | 476.95 | 472.43 | 476.82 | 5628812.0 |
| 2024-08-29 10:00:00 | QQQ | ETF | 476.82 | 477.93 | 474.06 | 476.72 | 4902119.0 |
| 2024-08-29 11:00:00 | QQQ | ETF | 476.79 | 477.81 | 475.56 | 476.5201 | 2280769.0 |
| 2024-08-29 12:00:00 | QQQ | ETF | 476.52 | 477.88 | 476.38 | 476.99 | 2074394.0 |
| 2024-08-29 13:00:00 | QQQ | ETF | 477.0 | 477.01 | 475.18 | 476.55 | 2879579.0 |
| 2024-08-29 14:00:00 | QQQ | ETF | 476.55 | 476.55 | 469.53 | 470.95 | 6116302.0 |
| 2024-08-29 15:00:00 | QQQ | ETF | 470.92 | 472.47 | 469.372 | 470.68 | 5863030.0 |
| 2024-08-29 16:00:00 | QQQ | ETF | 470.69 | 472.18 | 470.66 | 472.04 | 1078887.0 |
| 2024-08-29 17:00:00 | QQQ | ETF | 471.99 | 472.14 | 470.66 | 472.0 | 201028.0 |
| 2024-08-29 18:00:00 | QQQ | ETF | 472.08 | 472.33 | 471.15 | 471.7 | 84835.0 |
| 2024-08-29 19:00:00 | QQQ | ETF | 471.59 | 471.93 | 471.4816 | 471.61 | 30826.0 |
| 2024-08-29 04:00:00 | IWM | ETF | 218.34 | 218.34 | 217.9 | 218.3 | 22724.0 |
| 2024-08-29 05:00:00 | IWM | ETF | 218.29 | 218.75 | 218.29 | 218.52 | 11800.0 |
| 2024-08-29 06:00:00 | IWM | ETF | 218.54 | 218.79 | 218.24 | 218.3 | 15633.0 |
| 2024-08-29 07:00:00 | IWM | ETF | 218.34 | 218.61 | 218.13 | 218.4 | 91086.0 |
| 2024-08-29 08:00:00 | IWM | ETF | 218.24 | 219.43 | 218.08 | 218.75 | 259847.0 |
| 2024-08-29 09:00:00 | IWM | ETF | 218.75 | 219.1 | 217.15 | 218.35 | 3020016.0 |
| 2024-08-29 10:00:00 | IWM | ETF | 218.34 | 220.12 | 218.33 | 218.97 | 2978443.0 |
| 2024-08-29 11:00:00 | IWM | ETF | 218.96 | 220.085 | 218.87 | 220.02 | 1565328.0 |
| 2024-08-29 12:00:00 | IWM | ETF | 220.02 | 220.49 | 220.01 | 220.355 | 1739560.0 |
| 2024-08-29 13:00:00 | IWM | ETF | 220.35 | 220.98 | 219.94 | 220.89 | 1496917.0 |
| 2024-08-29 14:00:00 | IWM | ETF | 220.89 | 220.89 | 218.78 | 219.28 | 3507853.0 |
| 2024-08-29 15:00:00 | IWM | ETF | 219.27 | 219.9 | 218.58 | 218.74 | 3915151.0 |
| 2024-08-29 16:00:00 | IWM | ETF | 218.81 | 219.31 | 218.76 | 219.25 | 668195.0 |
| 2024-08-29 17:00:00 | IWM | ETF | 219.27 | 219.64 | 218.81 | 219.64 | 19748.0 |
| 2024-08-29 18:00:00 | IWM | ETF | 219.32 | 219.4 | 219.03 | 219.03 | 30168.0 |
| 2024-08-29 19:00:00 | IWM | ETF | 219.04 | 219.28 | 219.0 | 219.14 | 14409.0 |
| 2024-08-29 04:00:00 | DIA | ETF | 411.55 | 413.16 | 411.55 | 413.16 | 580.0 |
| 2024-08-29 05:00:00 | DIA | ETF | 413.3 | 413.52 | 413.3 | 413.35 | 1342.0 |
> showing 50 of 20,375 rows — these rows as CSV