PREVIEW / etf_1hour / 2024-04-29
file: by_date/etf_1hour/2024/2024-04-29.parquet size: 523 KB rows: 19,819
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-04-29 04:00:00 | SPY | ETF | 509.67 | 509.9 | 509.49 | 509.49 | 16270.0 |
| 2024-04-29 05:00:00 | SPY | ETF | 509.48 | 509.53 | 508.89 | 508.89 | 16569.0 |
| 2024-04-29 06:00:00 | SPY | ETF | 508.82 | 509.61 | 508.82 | 509.47 | 23918.0 |
| 2024-04-29 07:00:00 | SPY | ETF | 509.5 | 509.89 | 509.01 | 509.82 | 166649.0 |
| 2024-04-29 08:00:00 | SPY | ETF | 509.75 | 509.99 | 509.1996 | 509.89 | 147049.0 |
| 2024-04-29 09:00:00 | SPY | ETF | 509.87 | 510.75 | 508.26 | 509.58 | 4948928.0 |
| 2024-04-29 10:00:00 | SPY | ETF | 509.57 | 510.63 | 509.535 | 509.88 | 4046854.0 |
| 2024-04-29 11:00:00 | SPY | ETF | 509.88 | 509.935 | 509.005 | 509.7 | 2848029.0 |
| 2024-04-29 12:00:00 | SPY | ETF | 509.71 | 510.33 | 509.5602 | 509.945 | 2759240.0 |
| 2024-04-29 13:00:00 | SPY | ETF | 509.9499 | 510.52 | 509.575 | 510.175 | 2479776.0 |
| 2024-04-29 14:00:00 | SPY | ETF | 510.1599 | 510.16 | 508.6 | 509.5515 | 4021089.0 |
| 2024-04-29 15:00:00 | SPY | ETF | 509.55 | 510.2 | 507.25 | 510.05 | 11086367.0 |
| 2024-04-29 16:00:00 | SPY | ETF | 510.05 | 510.49 | 509.94 | 510.05 | 2874661.0 |
| 2024-04-29 17:00:00 | SPY | ETF | 510.07 | 510.26 | 509.95 | 510.19 | 48518.0 |
| 2024-04-29 18:00:00 | SPY | ETF | 510.06 | 510.06 | 509.65 | 509.73 | 32256.0 |
| 2024-04-29 19:00:00 | SPY | ETF | 509.79 | 509.88 | 509.73 | 509.83 | 19236.0 |
| 2024-04-29 04:00:00 | QQQ | ETF | 432.75 | 432.94 | 432.35 | 432.49 | 50210.0 |
| 2024-04-29 05:00:00 | QQQ | ETF | 432.49 | 432.68 | 431.82 | 431.91 | 40400.0 |
| 2024-04-29 06:00:00 | QQQ | ETF | 431.93 | 432.79 | 431.93 | 432.54 | 39448.0 |
| 2024-04-29 07:00:00 | QQQ | ETF | 432.55 | 433.07 | 432.21 | 432.939 | 110176.0 |
| 2024-04-29 08:00:00 | QQQ | ETF | 432.5196 | 433.26 | 432.1804 | 433.13 | 226148.0 |
| 2024-04-29 09:00:00 | QQQ | ETF | 433.14 | 433.76 | 430.9 | 431.8 | 4472155.0 |
| 2024-04-29 10:00:00 | QQQ | ETF | 431.8 | 432.99 | 431.71 | 432.235 | 3524977.0 |
| 2024-04-29 11:00:00 | QQQ | ETF | 432.27 | 432.38 | 431.2604 | 432.29 | 2014548.0 |
| 2024-04-29 12:00:00 | QQQ | ETF | 432.315 | 432.93 | 432.17 | 432.525 | 1918183.0 |
| 2024-04-29 13:00:00 | QQQ | ETF | 432.52 | 433.3453 | 431.98 | 433.005 | 1898954.0 |
| 2024-04-29 14:00:00 | QQQ | ETF | 432.97 | 432.97 | 431.25 | 432.306 | 2346376.0 |
| 2024-04-29 15:00:00 | QQQ | ETF | 432.3 | 432.86 | 429.98 | 432.74 | 6133189.0 |
| 2024-04-29 16:00:00 | QQQ | ETF | 432.76 | 433.33 | 432.74 | 432.91 | 1316803.0 |
| 2024-04-29 17:00:00 | QQQ | ETF | 432.92 | 433.07 | 432.87 | 432.92 | 26551.0 |
| 2024-04-29 18:00:00 | QQQ | ETF | 432.99 | 433.0 | 432.75 | 432.81 | 26624.0 |
| 2024-04-29 19:00:00 | QQQ | ETF | 432.85 | 432.9 | 432.75 | 432.82 | 23262.0 |
| 2024-04-29 04:00:00 | IWM | ETF | 198.95 | 199.15 | 198.82 | 198.93 | 13590.0 |
| 2024-04-29 05:00:00 | IWM | ETF | 198.88 | 198.95 | 198.63 | 198.76 | 13193.0 |
| 2024-04-29 06:00:00 | IWM | ETF | 198.76 | 198.83 | 198.66 | 198.75 | 5001.0 |
| 2024-04-29 07:00:00 | IWM | ETF | 198.77 | 199.11 | 198.67 | 199.08 | 21754.0 |
| 2024-04-29 08:00:00 | IWM | ETF | 198.7591 | 199.34 | 198.64 | 199.27 | 136669.0 |
| 2024-04-29 09:00:00 | IWM | ETF | 199.25 | 200.22 | 199.18 | 199.57 | 2260500.0 |
| 2024-04-29 10:00:00 | IWM | ETF | 199.56 | 200.11 | 199.48 | 199.745 | 1652808.0 |
| 2024-04-29 11:00:00 | IWM | ETF | 199.75 | 199.97 | 199.43 | 199.7401 | 1627358.0 |
| 2024-04-29 12:00:00 | IWM | ETF | 199.75 | 200.41 | 199.7099 | 199.97 | 1563310.0 |
| 2024-04-29 13:00:00 | IWM | ETF | 199.96 | 200.3 | 199.89 | 200.24 | 1270353.0 |
| 2024-04-29 14:00:00 | IWM | ETF | 200.235 | 200.235 | 199.63 | 200.04 | 1134041.0 |
| 2024-04-29 15:00:00 | IWM | ETF | 200.03 | 200.03 | 198.88 | 199.93 | 3924030.0 |
| 2024-04-29 16:00:00 | IWM | ETF | 199.93 | 200.03 | 199.6 | 199.67 | 1411061.0 |
| 2024-04-29 17:00:00 | IWM | ETF | 199.66 | 199.95 | 199.66 | 199.75 | 40176.0 |
| 2024-04-29 18:00:00 | IWM | ETF | 199.8 | 199.8 | 199.44 | 199.5192 | 22966.0 |
| 2024-04-29 19:00:00 | IWM | ETF | 199.53 | 199.62 | 199.45 | 199.6 | 32240.0 |
| 2024-04-29 04:00:00 | DIA | ETF | 383.19 | 383.28 | 383.19 | 383.21 | 5450.0 |
| 2024-04-29 05:00:00 | DIA | ETF | 382.93 | 382.93 | 382.89 | 382.89 | 650.0 |
> showing 50 of 19,819 rows — these rows as CSV