PREVIEW / etf_30min / 2006-11-07
file: by_date/etf_30min/2006/2006-11-07.parquet size: 89 KB rows: 3,112
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.18 | 138.18 | 138.18 | 15000.0 |
| 2006-11-07 06:30:00 | SPY | ETF | 138.2 | 138.23 | 138.2 | 138.23 | 14000.0 |
| 2006-11-07 07:00:00 | SPY | ETF | 138.23 | 138.23 | 138.2 | 138.2 | 3200.0 |
| 2006-11-07 07:30:00 | SPY | ETF | 138.2 | 138.21 | 138.19 | 138.2 | 35100.0 |
| 2006-11-07 08:00:00 | SPY | ETF | 138.22 | 138.3 | 138.19 | 138.28 | 590000.0 |
| 2006-11-07 08:30:00 | SPY | ETF | 138.28 | 138.4 | 138.28 | 138.31 | 336200.0 |
| 2006-11-07 09:00:00 | SPY | ETF | 138.32 | 138.34 | 138.21 | 138.21 | 829000.0 |
| 2006-11-07 09:30:00 | SPY | ETF | 138.2 | 138.37 | 138.0 | 138.36 | 6042900.0 |
| 2006-11-07 10:00:00 | SPY | ETF | 138.35 | 138.86 | 138.31 | 138.73 | 8571900.0 |
| 2006-11-07 10:30:00 | SPY | ETF | 138.73 | 138.84 | 138.55 | 138.61 | 3630100.0 |
| 2006-11-07 11:00:00 | SPY | ETF | 138.62 | 138.83 | 138.61 | 138.82 | 3350400.0 |
| 2006-11-07 11:30:00 | SPY | ETF | 138.82 | 138.84 | 138.62 | 138.69 | 3768700.0 |
| 2006-11-07 12:00:00 | SPY | ETF | 138.69 | 138.9 | 138.64 | 138.73 | 3517900.0 |
| 2006-11-07 12:30:00 | SPY | ETF | 138.72 | 138.98 | 138.71 | 138.89 | 2086600.0 |
| 2006-11-07 13:00:00 | SPY | ETF | 138.86 | 138.95 | 138.67 | 138.72 | 3074800.0 |
| 2006-11-07 13:30:00 | SPY | ETF | 138.72 | 138.86 | 138.7 | 138.73 | 2183600.0 |
| 2006-11-07 14:00:00 | SPY | ETF | 138.74 | 138.76 | 138.35 | 138.41 | 7733500.0 |
| 2006-11-07 14:30:00 | SPY | ETF | 138.42 | 138.69 | 138.37 | 138.63 | 5717800.0 |
| 2006-11-07 15:00:00 | SPY | ETF | 138.63 | 138.72 | 138.39 | 138.5 | 3354900.0 |
| 2006-11-07 15:30:00 | SPY | ETF | 138.5 | 138.67 | 138.32 | 138.44 | 6195000.0 |
| 2006-11-07 16:00:00 | SPY | ETF | 138.44 | 138.75 | 138.42 | 138.61 | 441700.0 |
| 2006-11-07 16:30:00 | SPY | ETF | 138.58 | 138.58 | 138.45 | 138.46 | 170000.0 |
| 2006-11-07 17:00:00 | SPY | ETF | 138.49 | 138.5 | 138.46 | 138.49 | 47700.0 |
| 2006-11-07 17:30:00 | SPY | ETF | 138.52 | 138.53 | 138.48 | 138.51 | 4300.0 |
| 2006-11-07 18:00:00 | SPY | ETF | 138.42 | 138.49 | 138.42 | 138.49 | 42600.0 |
| 2006-11-07 18:30:00 | SPY | ETF | 138.48 | 138.48 | 138.43 | 138.43 | 2600.0 |
| 2006-11-07 19:00:00 | SPY | ETF | 138.43 | 138.45 | 138.4 | 138.45 | 23200.0 |
| 2006-11-07 19:30:00 | SPY | ETF | 138.45 | 138.45 | 138.42 | 138.42 | 2700.0 |
| 2006-11-07 09:30:00 | QQQ | ETF | 42.53 | 42.72 | 42.47 | 42.72 | 16597700.0 |
| 2006-11-07 10:00:00 | QQQ | ETF | 42.73 | 43.01 | 42.71 | 42.98 | 26284400.0 |
| 2006-11-07 10:30:00 | QQQ | ETF | 42.99 | 43.09 | 42.04 | 42.96 | 12911000.0 |
| 2006-11-07 11:00:00 | QQQ | ETF | 42.97 | 43.08 | 42.96 | 43.07 | 7306700.0 |
| 2006-11-07 11:30:00 | QQQ | ETF | 43.07 | 43.08 | 42.95 | 42.98 | 6816200.0 |
| 2006-11-07 12:00:00 | QQQ | ETF | 42.97 | 43.02 | 42.95 | 42.96 | 4319300.0 |
| 2006-11-07 12:30:00 | QQQ | ETF | 42.96 | 43.07 | 42.95 | 43.04 | 4945000.0 |
| 2006-11-07 13:00:00 | QQQ | ETF | 43.05 | 43.06 | 42.94 | 42.97 | 5722400.0 |
| 2006-11-07 13:30:00 | QQQ | ETF | 42.97 | 43.02 | 42.95 | 43.0 | 2977100.0 |
| 2006-11-07 14:00:00 | QQQ | ETF | 43.0 | 43.01 | 42.77 | 42.8 | 10896400.0 |
| 2006-11-07 14:30:00 | QQQ | ETF | 42.79 | 42.94 | 42.78 | 42.94 | 7134000.0 |
| 2006-11-07 15:00:00 | QQQ | ETF | 42.94 | 42.99 | 42.79 | 42.83 | 8932400.0 |
| 2006-11-07 15:30:00 | QQQ | ETF | 42.84 | 42.91 | 42.7 | 42.82 | 13080700.0 |
| 2006-11-07 08:00:00 | IWM | ETF | 75.8 | 75.88 | 75.8 | 75.87 | 22300.0 |
| 2006-11-07 08:30:00 | IWM | ETF | 75.87 | 75.95 | 75.84 | 75.86 | 225500.0 |
| 2006-11-07 09:00:00 | IWM | ETF | 75.89 | 75.9 | 75.81 | 75.84 | 201000.0 |
| 2006-11-07 09:30:00 | IWM | ETF | 75.83 | 76.32 | 75.77 | 76.32 | 6169200.0 |
| 2006-11-07 10:00:00 | IWM | ETF | 76.31 | 76.83 | 76.31 | 76.74 | 8883500.0 |
| 2006-11-07 10:30:00 | IWM | ETF | 76.74 | 76.79 | 76.51 | 76.55 | 3924000.0 |
| 2006-11-07 11:00:00 | IWM | ETF | 76.55 | 76.75 | 76.54 | 76.74 | 2605400.0 |
| 2006-11-07 11:30:00 | IWM | ETF | 76.74 | 76.75 | 76.48 | 76.49 | 2377700.0 |
| 2006-11-07 12:00:00 | IWM | ETF | 76.49 | 76.58 | 76.42 | 76.45 | 2490600.0 |
> showing 50 of 3,112 rows — these rows as CSV