PREVIEW / etf_1hour / 2006-11-07
file: by_date/etf_1hour/2006/2006-11-07.parquet size: 58 KB rows: 1,816
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-07 06:00:00 | SPY | ETF | 138.18 | 138.23 | 138.18 | 138.23 | 29000.0 |
| 2006-11-07 07:00:00 | SPY | ETF | 138.23 | 138.23 | 138.19 | 138.2 | 38300.0 |
| 2006-11-07 08:00:00 | SPY | ETF | 138.22 | 138.4 | 138.19 | 138.31 | 926200.0 |
| 2006-11-07 09:00:00 | SPY | ETF | 138.32 | 138.37 | 138.0 | 138.36 | 6871900.0 |
| 2006-11-07 10:00:00 | SPY | ETF | 138.35 | 138.86 | 138.31 | 138.61 | 12202000.0 |
| 2006-11-07 11:00:00 | SPY | ETF | 138.62 | 138.84 | 138.61 | 138.69 | 7119100.0 |
| 2006-11-07 12:00:00 | SPY | ETF | 138.69 | 138.98 | 138.64 | 138.89 | 5604500.0 |
| 2006-11-07 13:00:00 | SPY | ETF | 138.86 | 138.95 | 138.67 | 138.73 | 5258400.0 |
| 2006-11-07 14:00:00 | SPY | ETF | 138.74 | 138.76 | 138.35 | 138.63 | 13451300.0 |
| 2006-11-07 15:00:00 | SPY | ETF | 138.63 | 138.72 | 138.32 | 138.44 | 9549900.0 |
| 2006-11-07 16:00:00 | SPY | ETF | 138.44 | 138.75 | 138.42 | 138.46 | 611700.0 |
| 2006-11-07 17:00:00 | SPY | ETF | 138.49 | 138.53 | 138.46 | 138.51 | 52000.0 |
| 2006-11-07 18:00:00 | SPY | ETF | 138.42 | 138.49 | 138.42 | 138.43 | 45200.0 |
| 2006-11-07 19:00:00 | SPY | ETF | 138.43 | 138.45 | 138.4 | 138.42 | 25900.0 |
| 2006-11-07 09:00:00 | QQQ | ETF | 42.53 | 42.72 | 42.47 | 42.72 | 16597700.0 |
| 2006-11-07 10:00:00 | QQQ | ETF | 42.73 | 43.09 | 42.04 | 42.96 | 39195400.0 |
| 2006-11-07 11:00:00 | QQQ | ETF | 42.97 | 43.08 | 42.95 | 42.98 | 14122900.0 |
| 2006-11-07 12:00:00 | QQQ | ETF | 42.97 | 43.07 | 42.95 | 43.04 | 9264300.0 |
| 2006-11-07 13:00:00 | QQQ | ETF | 43.05 | 43.06 | 42.94 | 43.0 | 8699500.0 |
| 2006-11-07 14:00:00 | QQQ | ETF | 43.0 | 43.01 | 42.77 | 42.94 | 18030400.0 |
| 2006-11-07 15:00:00 | QQQ | ETF | 42.94 | 42.99 | 42.7 | 42.82 | 22013100.0 |
| 2006-11-07 08:00:00 | IWM | ETF | 75.8 | 75.95 | 75.8 | 75.86 | 247800.0 |
| 2006-11-07 09:00:00 | IWM | ETF | 75.89 | 76.32 | 75.77 | 76.32 | 6370200.0 |
| 2006-11-07 10:00:00 | IWM | ETF | 76.31 | 76.83 | 76.31 | 76.55 | 12807500.0 |
| 2006-11-07 11:00:00 | IWM | ETF | 76.55 | 76.75 | 76.48 | 76.49 | 4983100.0 |
| 2006-11-07 12:00:00 | IWM | ETF | 76.49 | 76.65 | 76.42 | 76.6 | 3844400.0 |
| 2006-11-07 13:00:00 | IWM | ETF | 76.59 | 76.62 | 76.3 | 76.42 | 3599100.0 |
| 2006-11-07 14:00:00 | IWM | ETF | 76.43 | 76.45 | 75.9 | 76.14 | 7510600.0 |
| 2006-11-07 15:00:00 | IWM | ETF | 76.15 | 76.3 | 75.88 | 75.98 | 6923100.0 |
| 2006-11-07 16:00:00 | IWM | ETF | 76.05 | 76.25 | 75.7334 | 75.7334 | 1779900.0 |
| 2006-11-07 17:00:00 | IWM | ETF | 76.16 | 76.16 | 76.11 | 76.13 | 118500.0 |
| 2006-11-07 19:00:00 | IWM | ETF | 76.08 | 76.13 | 76.07 | 76.07 | 4000.0 |
| 2006-11-07 08:00:00 | DIA | ETF | 121.17 | 121.3 | 121.17 | 121.29 | 26800.0 |
| 2006-11-07 09:00:00 | DIA | ETF | 121.18 | 121.35 | 120.955 | 121.34 | 769100.0 |
| 2006-11-07 10:00:00 | DIA | ETF | 121.35 | 121.77 | 121.31 | 121.57 | 2139700.0 |
| 2006-11-07 11:00:00 | DIA | ETF | 121.57 | 121.86 | 121.55 | 121.76 | 1188000.0 |
| 2006-11-07 12:00:00 | DIA | ETF | 121.74 | 121.88 | 121.65 | 121.82 | 901200.0 |
| 2006-11-07 13:00:00 | DIA | ETF | 121.83 | 121.84 | 121.69 | 121.74 | 1350200.0 |
| 2006-11-07 14:00:00 | DIA | ETF | 121.74 | 121.77 | 121.47 | 121.7 | 907400.0 |
| 2006-11-07 15:00:00 | DIA | ETF | 121.71 | 121.81 | 121.46 | 121.47 | 1583000.0 |
| 2006-11-07 16:00:00 | DIA | ETF | 121.48 | 121.62 | 120.9976 | 121.53 | 542300.0 |
| 2006-11-07 17:00:00 | DIA | ETF | 121.55 | 121.55 | 121.54 | 121.54 | 75100.0 |
| 2006-11-07 08:00:00 | GLD | ETF | 62.16 | 62.3 | 62.14 | 62.21 | 20800.0 |
| 2006-11-07 09:00:00 | GLD | ETF | 62.25 | 62.48 | 62.19 | 62.22 | 960200.0 |
| 2006-11-07 10:00:00 | GLD | ETF | 62.23 | 62.44 | 61.99 | 62.0 | 1570600.0 |
| 2006-11-07 11:00:00 | GLD | ETF | 62.0 | 62.41 | 62.0 | 62.3 | 845300.0 |
| 2006-11-07 12:00:00 | GLD | ETF | 62.32 | 62.43 | 62.23 | 62.2506 | 1001700.0 |
| 2006-11-07 13:00:00 | GLD | ETF | 62.2599 | 62.32 | 62.06 | 62.27 | 357300.0 |
| 2006-11-07 14:00:00 | GLD | ETF | 62.27 | 62.27 | 62.01 | 62.01 | 215900.0 |
| 2006-11-07 15:00:00 | GLD | ETF | 62.0101 | 62.08 | 61.97 | 61.97 | 243900.0 |
> showing 50 of 1,816 rows — these rows as CSV