PREVIEW / etf_1hour / 2006-11-28
file: by_date/etf_1hour/2006/2006-11-28.parquet size: 58 KB rows: 1,796
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-28 06:00:00 | SPY | ETF | 138.44 | 138.44 | 138.39 | 138.42 | 11100.0 |
| 2006-11-28 07:00:00 | SPY | ETF | 138.51 | 138.53 | 138.45 | 138.49 | 51500.0 |
| 2006-11-28 08:00:00 | SPY | ETF | 138.49 | 138.53 | 137.96 | 138.05 | 4632600.0 |
| 2006-11-28 09:00:00 | SPY | ETF | 138.06 | 138.45 | 138.02 | 138.37 | 15223900.0 |
| 2006-11-28 10:00:00 | SPY | ETF | 138.38 | 139.1 | 138.17 | 138.89 | 27850100.0 |
| 2006-11-28 11:00:00 | SPY | ETF | 138.89 | 139.09 | 138.72 | 138.79 | 8330900.0 |
| 2006-11-28 12:00:00 | SPY | ETF | 138.79 | 138.96 | 138.51 | 138.67 | 9716600.0 |
| 2006-11-28 13:00:00 | SPY | ETF | 138.67 | 139.03 | 138.44 | 138.64 | 13093700.0 |
| 2006-11-28 14:00:00 | SPY | ETF | 138.64 | 138.95 | 138.58 | 138.82 | 6658000.0 |
| 2006-11-28 15:00:00 | SPY | ETF | 138.83 | 139.16 | 138.74 | 139.03 | 13713900.0 |
| 2006-11-28 16:00:00 | SPY | ETF | 139.02 | 139.11 | 138.8024 | 139.08 | 1887700.0 |
| 2006-11-28 17:00:00 | SPY | ETF | 139.1 | 139.1 | 137.6665 | 139.05 | 661000.0 |
| 2006-11-28 18:00:00 | SPY | ETF | 139.08 | 139.11 | 139.08 | 139.11 | 17000.0 |
| 2006-11-28 19:00:00 | SPY | ETF | 139.11 | 139.14 | 139.11 | 139.14 | 600.0 |
| 2006-11-28 09:00:00 | QQQ | ETF | 43.52 | 43.64 | 43.34 | 43.49 | 20353000.0 |
| 2006-11-28 10:00:00 | QQQ | ETF | 43.49 | 43.78 | 43.38 | 43.63 | 35065700.0 |
| 2006-11-28 11:00:00 | QQQ | ETF | 43.62 | 43.75 | 43.43 | 43.63 | 8790600.0 |
| 2006-11-28 12:00:00 | QQQ | ETF | 43.62 | 43.77 | 43.42 | 43.59 | 10439600.0 |
| 2006-11-28 13:00:00 | QQQ | ETF | 43.59 | 43.68 | 43.5 | 43.54 | 8411400.0 |
| 2006-11-28 14:00:00 | QQQ | ETF | 43.54 | 43.72 | 43.51 | 43.66 | 8297000.0 |
| 2006-11-28 15:00:00 | QQQ | ETF | 43.67 | 43.84 | 43.62 | 43.77 | 19075900.0 |
| 2006-11-28 07:00:00 | IWM | ETF | 76.65 | 76.8 | 76.65 | 76.8 | 300.0 |
| 2006-11-28 08:00:00 | IWM | ETF | 76.74 | 76.8 | 76.48 | 76.49 | 622100.0 |
| 2006-11-28 09:00:00 | IWM | ETF | 76.5 | 76.78 | 76.29 | 76.45 | 7525300.0 |
| 2006-11-28 10:00:00 | IWM | ETF | 76.45 | 77.09 | 76.42 | 76.93 | 16818100.0 |
| 2006-11-28 11:00:00 | IWM | ETF | 76.93 | 77.16 | 76.83 | 76.93 | 9330400.0 |
| 2006-11-28 12:00:00 | IWM | ETF | 76.92 | 76.96 | 76.64 | 76.73 | 6104800.0 |
| 2006-11-28 13:00:00 | IWM | ETF | 76.74 | 76.87 | 76.51 | 76.59 | 3959100.0 |
| 2006-11-28 14:00:00 | IWM | ETF | 76.58 | 76.9 | 76.49 | 76.74 | 4099200.0 |
| 2006-11-28 15:00:00 | IWM | ETF | 76.7325 | 77.12 | 76.67 | 77.12 | 8442800.0 |
| 2006-11-28 16:00:00 | IWM | ETF | 77.11 | 77.11 | 76.98 | 77.02 | 838600.0 |
| 2006-11-28 17:00:00 | IWM | ETF | 77.1 | 77.1 | 77.09 | 77.09 | 1100.0 |
| 2006-11-28 07:00:00 | DIA | ETF | 121.09 | 121.09 | 121.09 | 121.09 | 100.0 |
| 2006-11-28 08:00:00 | DIA | ETF | 121.07 | 121.13 | 120.85 | 120.9 | 64700.0 |
| 2006-11-28 09:00:00 | DIA | ETF | 120.89 | 121.12 | 120.8 | 120.91 | 965300.0 |
| 2006-11-28 10:00:00 | DIA | ETF | 120.92 | 121.41 | 120.68 | 121.25 | 3272200.0 |
| 2006-11-28 11:00:00 | DIA | ETF | 121.25 | 121.39 | 121.13 | 121.18 | 695300.0 |
| 2006-11-28 12:00:00 | DIA | ETF | 121.18 | 121.29 | 120.95 | 121.06 | 757600.0 |
| 2006-11-28 13:00:00 | DIA | ETF | 121.05 | 121.37 | 120.91 | 121.03 | 1139600.0 |
| 2006-11-28 14:00:00 | DIA | ETF | 121.03 | 121.24 | 120.96 | 121.09 | 545400.0 |
| 2006-11-28 15:00:00 | DIA | ETF | 121.11 | 121.45 | 121.06 | 121.3 | 892300.0 |
| 2006-11-28 16:00:00 | DIA | ETF | 121.31 | 121.35 | 121.23 | 121.35 | 24800.0 |
| 2006-11-28 07:00:00 | GLD | ETF | 63.46 | 63.46 | 63.42 | 63.42 | 5100.0 |
| 2006-11-28 08:00:00 | GLD | ETF | 63.48 | 63.57 | 63.39 | 63.55 | 198000.0 |
| 2006-11-28 09:00:00 | GLD | ETF | 63.53 | 63.71 | 63.48 | 63.68 | 602700.0 |
| 2006-11-28 10:00:00 | GLD | ETF | 63.69 | 63.69 | 62.82 | 63.12 | 1789600.0 |
| 2006-11-28 11:00:00 | GLD | ETF | 63.12 | 63.4178 | 63.1 | 63.39 | 984400.0 |
| 2006-11-28 12:00:00 | GLD | ETF | 63.39 | 63.49 | 63.08 | 63.13 | 778200.0 |
| 2006-11-28 13:00:00 | GLD | ETF | 63.15 | 63.46 | 63.14 | 63.35 | 660800.0 |
| 2006-11-28 14:00:00 | GLD | ETF | 63.36 | 63.44 | 63.35 | 63.43 | 357500.0 |
> showing 50 of 1,796 rows — these rows as CSV