PREVIEW / etf_1hour / 2024-09-13
file: by_date/etf_1hour/2024/2024-09-13.parquet size: 540 KB rows: 20,365
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-09-13 04:00:00 | SPY | ETF | 559.38 | 560.0 | 559.32 | 559.78 | 41427.0 |
| 2024-09-13 05:00:00 | SPY | ETF | 559.93 | 560.6 | 559.86 | 560.38 | 13872.0 |
| 2024-09-13 06:00:00 | SPY | ETF | 560.31 | 560.53 | 560.25 | 560.4 | 12507.0 |
| 2024-09-13 07:00:00 | SPY | ETF | 560.51 | 560.68 | 559.82 | 560.28 | 281937.0 |
| 2024-09-13 08:00:00 | SPY | ETF | 560.5113 | 560.5117 | 559.23 | 560.3 | 128091.0 |
| 2024-09-13 09:00:00 | SPY | ETF | 560.22 | 561.28 | 559.45 | 560.9301 | 3350674.0 |
| 2024-09-13 10:00:00 | SPY | ETF | 560.99 | 562.57 | 559.93 | 561.86 | 4868321.0 |
| 2024-09-13 11:00:00 | SPY | ETF | 561.85 | 562.8 | 561.51 | 562.66 | 2850785.0 |
| 2024-09-13 12:00:00 | SPY | ETF | 562.65 | 562.94 | 561.33 | 562.19 | 2485044.0 |
| 2024-09-13 13:00:00 | SPY | ETF | 562.19 | 563.03 | 562.14 | 562.57 | 2092406.0 |
| 2024-09-13 14:00:00 | SPY | ETF | 562.57 | 562.98 | 561.11 | 561.44 | 3224555.0 |
| 2024-09-13 15:00:00 | SPY | ETF | 561.43 | 562.34 | 561.02 | 561.94 | 5677207.0 |
| 2024-09-13 16:00:00 | SPY | ETF | 561.95 | 562.11 | 561.49 | 561.63 | 3518031.0 |
| 2024-09-13 17:00:00 | SPY | ETF | 561.5785 | 561.9334 | 561.53 | 561.75 | 457577.0 |
| 2024-09-13 18:00:00 | SPY | ETF | 561.75 | 561.85 | 561.58 | 561.7 | 48037.0 |
| 2024-09-13 19:00:00 | SPY | ETF | 561.69 | 561.7599 | 561.45 | 561.65 | 20889.0 |
| 2024-09-13 04:00:00 | QQQ | ETF | 473.12 | 473.79 | 472.89 | 473.56 | 35398.0 |
| 2024-09-13 05:00:00 | QQQ | ETF | 473.64 | 474.08 | 473.44 | 473.81 | 29836.0 |
| 2024-09-13 06:00:00 | QQQ | ETF | 473.77 | 474.02 | 473.59 | 473.94 | 19533.0 |
| 2024-09-13 07:00:00 | QQQ | ETF | 473.89 | 473.99 | 473.25 | 473.61 | 106216.0 |
| 2024-09-13 08:00:00 | QQQ | ETF | 473.86 | 474.25 | 472.59 | 473.42 | 152924.0 |
| 2024-09-13 09:00:00 | QQQ | ETF | 473.41 | 474.69 | 472.25 | 473.81 | 2758839.0 |
| 2024-09-13 10:00:00 | QQQ | ETF | 473.89 | 475.5 | 472.5982 | 475.01 | 4755384.0 |
| 2024-09-13 11:00:00 | QQQ | ETF | 475.0225 | 475.72 | 474.6513 | 475.52 | 2722188.0 |
| 2024-09-13 12:00:00 | QQQ | ETF | 475.49 | 476.13 | 474.15 | 475.685 | 2408648.0 |
| 2024-09-13 13:00:00 | QQQ | ETF | 475.69 | 476.53 | 475.56 | 476.14 | 2116566.0 |
| 2024-09-13 14:00:00 | QQQ | ETF | 476.14 | 476.44 | 474.58 | 474.98 | 2492048.0 |
| 2024-09-13 15:00:00 | QQQ | ETF | 474.97 | 475.91 | 474.5 | 475.34 | 4284288.0 |
| 2024-09-13 16:00:00 | QQQ | ETF | 475.33 | 475.38 | 474.72 | 474.769 | 1086555.0 |
| 2024-09-13 17:00:00 | QQQ | ETF | 474.75 | 475.12 | 474.75 | 474.9 | 14489.0 |
| 2024-09-13 18:00:00 | QQQ | ETF | 474.9 | 474.9316 | 474.7 | 474.7318 | 44393.0 |
| 2024-09-13 19:00:00 | QQQ | ETF | 474.7 | 474.95 | 474.63 | 474.66 | 19070.0 |
| 2024-09-13 04:00:00 | IWM | ETF | 212.43 | 212.8 | 212.31 | 212.76 | 9501.0 |
| 2024-09-13 05:00:00 | IWM | ETF | 212.9 | 213.63 | 212.78 | 213.49 | 30313.0 |
| 2024-09-13 06:00:00 | IWM | ETF | 213.59 | 213.68 | 213.15 | 213.31 | 70399.0 |
| 2024-09-13 07:00:00 | IWM | ETF | 213.4 | 213.9 | 213.06 | 213.9 | 103725.0 |
| 2024-09-13 08:00:00 | IWM | ETF | 213.16 | 214.06 | 212.09 | 213.53 | 163813.0 |
| 2024-09-13 09:00:00 | IWM | ETF | 213.6 | 215.39 | 213.5701 | 215.2 | 4485312.0 |
| 2024-09-13 10:00:00 | IWM | ETF | 215.22 | 216.54 | 214.525 | 216.16 | 4835532.0 |
| 2024-09-13 11:00:00 | IWM | ETF | 216.14 | 217.03 | 215.48 | 216.97 | 3452120.0 |
| 2024-09-13 12:00:00 | IWM | ETF | 216.96 | 217.25 | 216.45 | 216.77 | 3082381.0 |
| 2024-09-13 13:00:00 | IWM | ETF | 216.76 | 217.08 | 216.24 | 216.35 | 1632676.0 |
| 2024-09-13 14:00:00 | IWM | ETF | 216.345 | 216.605 | 215.71 | 216.12 | 2689973.0 |
| 2024-09-13 15:00:00 | IWM | ETF | 216.11 | 217.0 | 215.64 | 216.86 | 5896290.0 |
| 2024-09-13 16:00:00 | IWM | ETF | 216.83 | 217.19 | 216.73 | 216.73 | 1860165.0 |
| 2024-09-13 17:00:00 | IWM | ETF | 216.85 | 217.05 | 216.76 | 216.85 | 86873.0 |
| 2024-09-13 18:00:00 | IWM | ETF | 216.95 | 216.95 | 216.72 | 216.89 | 11741.0 |
| 2024-09-13 19:00:00 | IWM | ETF | 216.92 | 217.017 | 216.85 | 216.9123 | 12200.0 |
| 2024-09-13 04:00:00 | DIA | ETF | 412.18 | 412.38 | 412.18 | 412.38 | 500.0 |
| 2024-09-13 05:00:00 | DIA | ETF | 412.34 | 412.91 | 412.34 | 412.91 | 1155.0 |
> showing 50 of 20,365 rows — these rows as CSV