PREVIEW / etf_1hour / 2001-06-04
file: by_date/etf_1hour/2001/2001-06-04.parquet size: 11 KB rows: 218
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-04 09:00:00 | SPY | ETF | 126.8 | 127.22 | 126.5 | 126.59 | 923200.0 |
| 2001-06-04 10:00:00 | SPY | ETF | 126.67 | 126.74 | 126.08 | 126.49 | 1168900.0 |
| 2001-06-04 11:00:00 | SPY | ETF | 126.4 | 126.66 | 126.2 | 126.66 | 460200.0 |
| 2001-06-04 12:00:00 | SPY | ETF | 126.65 | 127.0 | 126.55 | 126.84 | 647400.0 |
| 2001-06-04 13:00:00 | SPY | ETF | 126.84 | 127.07 | 126.6 | 126.72 | 499100.0 |
| 2001-06-04 14:00:00 | SPY | ETF | 126.72 | 127.0 | 126.5 | 126.98 | 317900.0 |
| 2001-06-04 15:00:00 | SPY | ETF | 126.95 | 127.27 | 126.91 | 127.18 | 796600.0 |
| 2001-06-04 16:00:00 | SPY | ETF | 127.16 | 128.3 | 127.01 | 127.23 | 531600.0 |
| 2001-06-04 09:00:00 | QQQ | ETF | 46.33 | 46.66 | 45.6 | 45.74 | 9108200.0 |
| 2001-06-04 10:00:00 | QQQ | ETF | 45.74 | 45.95 | 45.29 | 45.55 | 9376000.0 |
| 2001-06-04 11:00:00 | QQQ | ETF | 45.57 | 45.85 | 45.36 | 45.77 | 4356200.0 |
| 2001-06-04 12:00:00 | QQQ | ETF | 45.77 | 46.2 | 45.71 | 46.0 | 5297600.0 |
| 2001-06-04 13:00:00 | QQQ | ETF | 45.97 | 46.16 | 45.6 | 45.7 | 3375700.0 |
| 2001-06-04 14:00:00 | QQQ | ETF | 45.68 | 45.93 | 45.5 | 45.85 | 3566000.0 |
| 2001-06-04 15:00:00 | QQQ | ETF | 45.85 | 46.06 | 45.64 | 45.76 | 4783200.0 |
| 2001-06-04 16:00:00 | QQQ | ETF | 45.76 | 45.9 | 45.71 | 45.81 | 609800.0 |
| 2001-06-04 17:00:00 | QQQ | ETF | 45.8 | 46.15 | 45.8 | 46.09 | 158400.0 |
| 2001-06-04 18:00:00 | QQQ | ETF | 46.1 | 46.2 | 46.08 | 46.14 | 17100.0 |
| 2001-06-04 09:00:00 | IWM | ETF | 50.375 | 50.38 | 50.15 | 50.15 | 31000.0 |
| 2001-06-04 10:00:00 | IWM | ETF | 50.2 | 50.3 | 50.2 | 50.3 | 17400.0 |
| 2001-06-04 11:00:00 | IWM | ETF | 50.3 | 50.495 | 50.265 | 50.495 | 80800.0 |
| 2001-06-04 12:00:00 | IWM | ETF | 50.515 | 50.67 | 50.515 | 50.625 | 15200.0 |
| 2001-06-04 13:00:00 | IWM | ETF | 50.72 | 50.725 | 50.515 | 50.515 | 88400.0 |
| 2001-06-04 14:00:00 | IWM | ETF | 50.5 | 50.525 | 50.39 | 50.495 | 55000.0 |
| 2001-06-04 15:00:00 | IWM | ETF | 50.5 | 50.72 | 50.48 | 50.575 | 122400.0 |
| 2001-06-04 16:00:00 | IWM | ETF | 50.725 | 50.79 | 50.725 | 50.79 | 2800.0 |
| 2001-06-04 09:00:00 | DIA | ETF | 110.25 | 110.4 | 109.88 | 109.95 | 176200.0 |
| 2001-06-04 10:00:00 | DIA | ETF | 109.9 | 109.98 | 109.5 | 109.8 | 205100.0 |
| 2001-06-04 11:00:00 | DIA | ETF | 109.68 | 110.05 | 109.62 | 109.9 | 90800.0 |
| 2001-06-04 12:00:00 | DIA | ETF | 109.92 | 110.42 | 109.92 | 110.25 | 186600.0 |
| 2001-06-04 13:00:00 | DIA | ETF | 110.35 | 110.56 | 110.15 | 110.3 | 39200.0 |
| 2001-06-04 14:00:00 | DIA | ETF | 110.26 | 110.54 | 110.1 | 110.5 | 29100.0 |
| 2001-06-04 15:00:00 | DIA | ETF | 110.49 | 110.92 | 110.43 | 110.7 | 264200.0 |
| 2001-06-04 16:00:00 | DIA | ETF | 110.7 | 110.92 | 110.56 | 110.7 | 57000.0 |
| 2001-06-04 18:00:00 | DIA | ETF | 110.82 | 110.82 | 110.82 | 110.82 | 200.0 |
> showing 35 of 218 rows — these rows as CSV