PREVIEW / etf_1hour / 2001-06-11
file: by_date/etf_1hour/2001/2001-06-11.parquet size: 11 KB rows: 222
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-11 09:00:00 | SPY | ETF | 126.71 | 126.99 | 126.47 | 126.57 | 1607800.0 |
| 2001-06-11 10:00:00 | SPY | ETF | 126.58 | 126.89 | 125.96 | 126.0 | 1096800.0 |
| 2001-06-11 11:00:00 | SPY | ETF | 126.05 | 126.05 | 125.56 | 125.83 | 744900.0 |
| 2001-06-11 12:00:00 | SPY | ETF | 125.8 | 125.92 | 125.63 | 125.78 | 482300.0 |
| 2001-06-11 13:00:00 | SPY | ETF | 125.73 | 125.98 | 125.42 | 125.55 | 555500.0 |
| 2001-06-11 14:00:00 | SPY | ETF | 125.57 | 125.91 | 125.41 | 125.83 | 927000.0 |
| 2001-06-11 15:00:00 | SPY | ETF | 125.8 | 126.22 | 125.68 | 125.94 | 1163400.0 |
| 2001-06-11 16:00:00 | SPY | ETF | 125.94 | 126.17 | 125.52 | 126.17 | 156700.0 |
| 2001-06-11 09:00:00 | QQQ | ETF | 46.9 | 47.0 | 46.4 | 46.55 | 8168100.0 |
| 2001-06-11 10:00:00 | QQQ | ETF | 46.55 | 46.68 | 45.9 | 45.95 | 9361000.0 |
| 2001-06-11 11:00:00 | QQQ | ETF | 45.95 | 45.98 | 45.6 | 45.87 | 8019700.0 |
| 2001-06-11 12:00:00 | QQQ | ETF | 45.84 | 45.98 | 45.7 | 45.83 | 2915500.0 |
| 2001-06-11 13:00:00 | QQQ | ETF | 45.85 | 45.98 | 45.51 | 45.55 | 4582200.0 |
| 2001-06-11 14:00:00 | QQQ | ETF | 45.55 | 45.95 | 45.49 | 45.9 | 4476700.0 |
| 2001-06-11 15:00:00 | QQQ | ETF | 45.88 | 46.25 | 45.73 | 46.04 | 8245100.0 |
| 2001-06-11 16:00:00 | QQQ | ETF | 46.04 | 46.25 | 45.8 | 46.04 | 1002400.0 |
| 2001-06-11 17:00:00 | QQQ | ETF | 46.08 | 46.18 | 46.06 | 46.18 | 34400.0 |
| 2001-06-11 18:00:00 | QQQ | ETF | 46.12 | 46.18 | 46.12 | 46.18 | 4300.0 |
| 2001-06-11 09:00:00 | IWM | ETF | 50.95 | 50.95 | 50.75 | 50.75 | 8000.0 |
| 2001-06-11 10:00:00 | IWM | ETF | 50.75 | 50.75 | 50.545 | 50.545 | 14600.0 |
| 2001-06-11 11:00:00 | IWM | ETF | 50.54 | 50.545 | 50.3 | 50.305 | 113400.0 |
| 2001-06-11 12:00:00 | IWM | ETF | 50.4 | 50.545 | 50.35 | 50.475 | 132200.0 |
| 2001-06-11 13:00:00 | IWM | ETF | 50.375 | 50.53 | 50.25 | 50.255 | 66200.0 |
| 2001-06-11 14:00:00 | IWM | ETF | 50.33 | 50.415 | 50.25 | 50.275 | 34000.0 |
| 2001-06-11 15:00:00 | IWM | ETF | 50.285 | 50.595 | 50.275 | 50.42 | 122400.0 |
| 2001-06-11 16:00:00 | IWM | ETF | 50.3 | 50.3 | 50.275 | 50.275 | 21000.0 |
| 2001-06-11 09:00:00 | DIA | ETF | 109.55 | 109.85 | 109.37 | 109.58 | 542500.0 |
| 2001-06-11 10:00:00 | DIA | ETF | 109.5 | 109.85 | 109.12 | 109.15 | 547600.0 |
| 2001-06-11 11:00:00 | DIA | ETF | 109.12 | 109.19 | 108.8 | 109.09 | 202000.0 |
| 2001-06-11 12:00:00 | DIA | ETF | 109.1 | 109.29 | 109.0 | 109.17 | 169100.0 |
| 2001-06-11 13:00:00 | DIA | ETF | 109.16 | 109.33 | 108.92 | 109.02 | 156100.0 |
| 2001-06-11 14:00:00 | DIA | ETF | 109.08 | 109.38 | 108.93 | 109.3 | 425500.0 |
| 2001-06-11 15:00:00 | DIA | ETF | 109.3 | 109.5 | 109.2 | 109.39 | 143400.0 |
| 2001-06-11 16:00:00 | DIA | ETF | 109.39 | 109.48 | 108.4 | 108.4 | 34100.0 |
> showing 34 of 222 rows — these rows as CSV