PREVIEW / etf_1hour / 2024-01-12
file: by_date/etf_1hour/2024/2024-01-12.parquet size: 521 KB rows: 19,105
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-01-12 04:00:00 | SPY | ETF | 476.12 | 477.09 | 475.82 | 476.36 | 25668.0 |
| 2024-01-12 05:00:00 | SPY | ETF | 476.24 | 476.6 | 475.99 | 476.19 | 4574.0 |
| 2024-01-12 06:00:00 | SPY | ETF | 476.4 | 476.4 | 474.17 | 474.92 | 205253.0 |
| 2024-01-12 07:00:00 | SPY | ETF | 474.95 | 475.57 | 474.75 | 475.15 | 276105.0 |
| 2024-01-12 08:00:00 | SPY | ETF | 475.17 | 476.85 | 474.3196 | 476.43 | 854130.0 |
| 2024-01-12 09:00:00 | SPY | ETF | 476.43 | 478.6 | 476.29 | 477.12 | 6297536.0 |
| 2024-01-12 10:00:00 | SPY | ETF | 477.14 | 477.5 | 475.23 | 475.8 | 9742074.0 |
| 2024-01-12 11:00:00 | SPY | ETF | 475.81 | 476.82 | 475.405 | 475.67 | 5714556.0 |
| 2024-01-12 12:00:00 | SPY | ETF | 475.68 | 476.49 | 475.365 | 476.13 | 3974830.0 |
| 2024-01-12 13:00:00 | SPY | ETF | 476.13 | 477.02 | 476.13 | 476.931 | 3718795.0 |
| 2024-01-12 14:00:00 | SPY | ETF | 476.93 | 477.34 | 476.15 | 476.2501 | 4605967.0 |
| 2024-01-12 15:00:00 | SPY | ETF | 476.26 | 476.9 | 475.76 | 476.665 | 9679692.0 |
| 2024-01-12 16:00:00 | SPY | ETF | 476.66 | 477.1452 | 475.97 | 476.15 | 1918996.0 |
| 2024-01-12 17:00:00 | SPY | ETF | 476.12 | 476.33 | 475.95 | 476.0 | 55367.0 |
| 2024-01-12 18:00:00 | SPY | ETF | 476.0 | 476.0 | 475.6 | 475.75 | 85283.0 |
| 2024-01-12 19:00:00 | SPY | ETF | 475.78 | 475.86 | 475.65 | 475.65 | 22509.0 |
| 2024-01-12 04:00:00 | QQQ | ETF | 409.31 | 409.64 | 408.46 | 408.49 | 50832.0 |
| 2024-01-12 05:00:00 | QQQ | ETF | 408.61 | 408.88 | 408.11 | 408.46 | 82884.0 |
| 2024-01-12 06:00:00 | QQQ | ETF | 408.51 | 408.63 | 407.02 | 407.72 | 91549.0 |
| 2024-01-12 07:00:00 | QQQ | ETF | 407.73 | 408.34 | 407.5 | 408.05 | 101002.0 |
| 2024-01-12 08:00:00 | QQQ | ETF | 407.8611 | 409.7092 | 407.65 | 409.36 | 524684.0 |
| 2024-01-12 09:00:00 | QQQ | ETF | 409.41 | 411.25 | 409.21 | 409.905 | 4355451.0 |
| 2024-01-12 10:00:00 | QQQ | ETF | 409.94 | 410.35 | 408.15 | 408.905 | 5932088.0 |
| 2024-01-12 11:00:00 | QQQ | ETF | 408.91 | 410.13 | 408.36 | 408.515 | 3589434.0 |
| 2024-01-12 12:00:00 | QQQ | ETF | 408.54 | 409.39 | 408.26 | 409.12 | 2484518.0 |
| 2024-01-12 13:00:00 | QQQ | ETF | 409.14 | 409.85 | 409.122 | 409.74 | 1985736.0 |
| 2024-01-12 14:00:00 | QQQ | ETF | 409.74 | 410.08 | 408.88 | 409.06 | 2394224.0 |
| 2024-01-12 15:00:00 | QQQ | ETF | 409.06 | 409.75 | 408.61 | 409.56 | 5964948.0 |
| 2024-01-12 16:00:00 | QQQ | ETF | 409.57 | 409.57 | 408.99 | 409.18 | 849042.0 |
| 2024-01-12 17:00:00 | QQQ | ETF | 409.13 | 409.59 | 409.0 | 409.0 | 3160623.0 |
| 2024-01-12 18:00:00 | QQQ | ETF | 409.2 | 409.25 | 408.93 | 409.0006 | 14396.0 |
| 2024-01-12 19:00:00 | QQQ | ETF | 408.98 | 409.02 | 408.75 | 408.75 | 6541.0 |
| 2024-01-12 04:00:00 | IWM | ETF | 193.98 | 194.39 | 193.8 | 193.8 | 35252.0 |
| 2024-01-12 05:00:00 | IWM | ETF | 193.83 | 194.1 | 193.57 | 193.71 | 13481.0 |
| 2024-01-12 06:00:00 | IWM | ETF | 193.78 | 193.83 | 192.64 | 193.23 | 71133.0 |
| 2024-01-12 07:00:00 | IWM | ETF | 193.21 | 193.83 | 193.19 | 193.47 | 82728.0 |
| 2024-01-12 08:00:00 | IWM | ETF | 193.51 | 195.08 | 192.654 | 194.77 | 777648.0 |
| 2024-01-12 09:00:00 | IWM | ETF | 194.81 | 197.1 | 194.65 | 195.345 | 6358757.0 |
| 2024-01-12 10:00:00 | IWM | ETF | 195.38 | 195.49 | 193.015 | 193.27 | 7451248.0 |
| 2024-01-12 11:00:00 | IWM | ETF | 193.26 | 193.825 | 192.64 | 192.85 | 4683471.0 |
| 2024-01-12 12:00:00 | IWM | ETF | 192.85 | 193.28 | 192.7 | 193.05 | 1921986.0 |
| 2024-01-12 13:00:00 | IWM | ETF | 193.05 | 193.585 | 192.985 | 193.515 | 2229466.0 |
| 2024-01-12 14:00:00 | IWM | ETF | 193.51 | 193.7303 | 193.06 | 193.12 | 2294953.0 |
| 2024-01-12 15:00:00 | IWM | ETF | 193.115 | 193.375 | 192.72 | 193.28 | 4603677.0 |
| 2024-01-12 16:00:00 | IWM | ETF | 193.23 | 193.3 | 192.88 | 193.11 | 404009.0 |
| 2024-01-12 17:00:00 | IWM | ETF | 193.09 | 193.2 | 192.71 | 192.8 | 47489.0 |
| 2024-01-12 18:00:00 | IWM | ETF | 192.8 | 193.23 | 192.6 | 192.84 | 255322.0 |
| 2024-01-12 19:00:00 | IWM | ETF | 192.76 | 192.8 | 192.6 | 192.68 | 6468.0 |
| 2024-01-12 04:00:00 | DIA | ETF | 377.72 | 378.0 | 377.59 | 377.59 | 3600.0 |
| 2024-01-12 05:00:00 | DIA | ETF | 377.87 | 377.9 | 377.21 | 377.21 | 1050.0 |
> showing 50 of 19,105 rows — these rows as CSV