PREVIEW / etf_1hour / 2024-09-16
file: by_date/etf_1hour/2024/2024-09-16.parquet size: 544 KB rows: 20,705
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-16 04:00:00 | SPY | ETF | 562.21 | 562.6 | 562.12 | 562.56 | 14116.0 |
| 2024-09-16 05:00:00 | SPY | ETF | 562.52 | 562.74 | 562.3 | 562.3 | 6172.0 |
| 2024-09-16 06:00:00 | SPY | ETF | 562.34 | 562.34 | 561.71 | 562.11 | 16035.0 |
| 2024-09-16 07:00:00 | SPY | ETF | 562.14 | 562.18 | 561.52 | 561.71 | 77690.0 |
| 2024-09-16 08:00:00 | SPY | ETF | 562.14 | 562.3 | 561.34 | 561.53 | 200939.0 |
| 2024-09-16 09:00:00 | SPY | ETF | 561.55 | 562.92 | 560.82 | 562.48 | 3663160.0 |
| 2024-09-16 10:00:00 | SPY | ETF | 562.47 | 562.82 | 559.9 | 560.7298 | 4214212.0 |
| 2024-09-16 11:00:00 | SPY | ETF | 560.72 | 561.54 | 560.16 | 561.27 | 2659328.0 |
| 2024-09-16 12:00:00 | SPY | ETF | 561.275 | 561.61 | 560.34 | 561.5699 | 2682175.0 |
| 2024-09-16 13:00:00 | SPY | ETF | 561.57 | 562.55 | 561.2 | 562.5005 | 1923050.0 |
| 2024-09-16 14:00:00 | SPY | ETF | 562.505 | 562.72 | 561.84 | 562.6975 | 2439427.0 |
| 2024-09-16 15:00:00 | SPY | ETF | 562.68 | 563.11 | 561.96 | 562.86 | 4734863.0 |
| 2024-09-16 16:00:00 | SPY | ETF | 562.86 | 562.92 | 562.33 | 562.34 | 1298279.0 |
| 2024-09-16 17:00:00 | SPY | ETF | 562.4351 | 562.4351 | 562.0 | 562.11 | 92978.0 |
| 2024-09-16 18:00:00 | SPY | ETF | 562.23 | 562.88 | 562.23 | 562.66 | 64537.0 |
| 2024-09-16 19:00:00 | SPY | ETF | 562.81 | 562.81 | 562.43 | 562.44 | 30039.0 |
| 2024-09-16 04:00:00 | QQQ | ETF | 474.68 | 475.75 | 474.68 | 475.38 | 29515.0 |
| 2024-09-16 05:00:00 | QQQ | ETF | 475.42 | 475.64 | 475.02 | 475.17 | 19052.0 |
| 2024-09-16 06:00:00 | QQQ | ETF | 475.14 | 475.14 | 473.93 | 474.52 | 24665.0 |
| 2024-09-16 07:00:00 | QQQ | ETF | 474.57 | 474.58 | 473.4 | 473.67 | 108394.0 |
| 2024-09-16 08:00:00 | QQQ | ETF | 474.35 | 475.6704 | 472.95 | 473.19 | 183792.0 |
| 2024-09-16 09:00:00 | QQQ | ETF | 473.21 | 473.8599 | 470.5301 | 473.0007 | 3268889.0 |
| 2024-09-16 10:00:00 | QQQ | ETF | 473.02 | 473.82 | 469.89 | 470.89 | 3836271.0 |
| 2024-09-16 11:00:00 | QQQ | ETF | 470.87 | 472.56 | 469.98 | 471.57 | 2278199.0 |
| 2024-09-16 12:00:00 | QQQ | ETF | 471.56 | 472.03 | 470.2 | 471.98 | 1597004.0 |
| 2024-09-16 13:00:00 | QQQ | ETF | 471.99 | 473.2 | 471.3 | 472.995 | 1332639.0 |
| 2024-09-16 14:00:00 | QQQ | ETF | 473.01 | 473.26 | 472.199 | 473.1401 | 1248939.0 |
| 2024-09-16 15:00:00 | QQQ | ETF | 473.15 | 473.55 | 472.42 | 473.22 | 2097833.0 |
| 2024-09-16 16:00:00 | QQQ | ETF | 473.23 | 473.28 | 472.73 | 472.73 | 518020.0 |
| 2024-09-16 17:00:00 | QQQ | ETF | 472.82 | 473.24 | 472.66 | 472.85 | 61270.0 |
| 2024-09-16 18:00:00 | QQQ | ETF | 472.83 | 473.81 | 472.83 | 473.5099 | 71770.0 |
| 2024-09-16 19:00:00 | QQQ | ETF | 473.65 | 473.71 | 473.24 | 473.24 | 29483.0 |
| 2024-09-16 04:00:00 | IWM | ETF | 218.0 | 218.2 | 217.81 | 218.2 | 11132.0 |
| 2024-09-16 05:00:00 | IWM | ETF | 218.3 | 218.88 | 217.94 | 217.94 | 17838.0 |
| 2024-09-16 06:00:00 | IWM | ETF | 218.02 | 218.56 | 217.84 | 218.55 | 30529.0 |
| 2024-09-16 07:00:00 | IWM | ETF | 218.54 | 218.56 | 218.05 | 218.2 | 101031.0 |
| 2024-09-16 08:00:00 | IWM | ETF | 218.5416 | 218.5416 | 217.22 | 217.43 | 363180.0 |
| 2024-09-16 09:00:00 | IWM | ETF | 217.49 | 218.285 | 216.33 | 217.81 | 3756594.0 |
| 2024-09-16 10:00:00 | IWM | ETF | 217.8257 | 218.18 | 216.14 | 216.67 | 3137392.0 |
| 2024-09-16 11:00:00 | IWM | ETF | 216.65 | 217.26 | 216.34 | 217.1099 | 1570112.0 |
| 2024-09-16 12:00:00 | IWM | ETF | 217.1 | 217.63 | 216.63 | 217.511 | 1409813.0 |
| 2024-09-16 13:00:00 | IWM | ETF | 217.51 | 217.6999 | 217.18 | 217.575 | 1030029.0 |
| 2024-09-16 14:00:00 | IWM | ETF | 217.59 | 217.885 | 217.3 | 217.88 | 1287265.0 |
| 2024-09-16 15:00:00 | IWM | ETF | 217.87 | 217.919 | 217.25 | 217.66 | 3232603.0 |
| 2024-09-16 16:00:00 | IWM | ETF | 217.61 | 217.74 | 217.51 | 217.54 | 1047183.0 |
| 2024-09-16 17:00:00 | IWM | ETF | 217.51 | 217.61 | 217.39 | 217.39 | 381446.0 |
| 2024-09-16 18:00:00 | IWM | ETF | 217.5 | 217.69 | 217.44 | 217.543 | 12278.0 |
| 2024-09-16 19:00:00 | IWM | ETF | 217.55 | 217.61 | 217.3895 | 217.5 | 16437.0 |
| 2024-09-16 04:00:00 | DIA | ETF | 415.2 | 415.2 | 415.2 | 415.2 | 200.0 |
| 2024-09-16 06:00:00 | DIA | ETF | 415.7 | 415.99 | 415.7 | 415.99 | 700.0 |
> showing 50 of 20,705 rows — these rows as CSV