PREVIEW / etf_30min / 2006-11-24
file: by_date/etf_30min/2006/2006-11-24.parquet size: 54 KB rows: 1,733
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-24 07:00:00 | SPY | ETF | 140.34 | 140.39 | 140.34 | 140.38 | 18800.0 |
| 2006-11-24 07:30:00 | SPY | ETF | 140.36 | 140.38 | 140.25 | 140.25 | 167000.0 |
| 2006-11-24 08:00:00 | SPY | ETF | 140.25 | 140.4 | 140.1 | 140.25 | 1095400.0 |
| 2006-11-24 08:30:00 | SPY | ETF | 140.27 | 140.27 | 140.13 | 140.18 | 365100.0 |
| 2006-11-24 09:00:00 | SPY | ETF | 140.19 | 140.25 | 140.17 | 140.22 | 234900.0 |
| 2006-11-24 09:30:00 | SPY | ETF | 140.24 | 140.4 | 140.2 | 140.38 | 5785800.0 |
| 2006-11-24 10:00:00 | SPY | ETF | 140.37 | 140.69 | 140.36 | 140.67 | 5029600.0 |
| 2006-11-24 10:30:00 | SPY | ETF | 140.66 | 140.8 | 140.61 | 140.74 | 2234700.0 |
| 2006-11-24 11:00:00 | SPY | ETF | 140.74 | 140.84 | 140.67 | 140.78 | 1476800.0 |
| 2006-11-24 11:30:00 | SPY | ETF | 140.77 | 140.82 | 140.53 | 140.64 | 3094800.0 |
| 2006-11-24 12:00:00 | SPY | ETF | 140.63 | 140.75 | 140.61 | 140.68 | 1179400.0 |
| 2006-11-24 12:30:00 | SPY | ETF | 140.69 | 140.71 | 140.44 | 140.46 | 2924300.0 |
| 2006-11-24 13:00:00 | SPY | ETF | 140.45 | 140.55 | 140.35 | 140.35 | 738300.0 |
| 2006-11-24 09:30:00 | QQQ | ETF | 44.39 | 44.54 | 44.38 | 44.53 | 9206900.0 |
| 2006-11-24 10:00:00 | QQQ | ETF | 44.53 | 44.71 | 44.52 | 44.68 | 8689300.0 |
| 2006-11-24 10:30:00 | QQQ | ETF | 44.69 | 44.78 | 44.62 | 44.75 | 4640100.0 |
| 2006-11-24 11:00:00 | QQQ | ETF | 44.75 | 44.86 | 44.71 | 44.78 | 5263800.0 |
| 2006-11-24 11:30:00 | QQQ | ETF | 44.77 | 44.8 | 44.68 | 44.71 | 4430200.0 |
| 2006-11-24 12:00:00 | QQQ | ETF | 44.71 | 44.75 | 44.69 | 44.75 | 2532300.0 |
| 2006-11-24 12:30:00 | QQQ | ETF | 44.75 | 44.75 | 44.63 | 44.65 | 8092000.0 |
| 2006-11-24 08:00:00 | IWM | ETF | 78.5 | 78.58 | 78.39 | 78.44 | 228900.0 |
| 2006-11-24 08:30:00 | IWM | ETF | 78.43 | 78.44 | 78.3 | 78.36 | 644700.0 |
| 2006-11-24 09:00:00 | IWM | ETF | 78.38 | 78.4 | 78.34 | 78.37 | 91200.0 |
| 2006-11-24 09:30:00 | IWM | ETF | 78.37 | 78.65 | 78.23 | 78.34 | 3749200.0 |
| 2006-11-24 10:00:00 | IWM | ETF | 78.33 | 78.88 | 78.33 | 78.82 | 3312400.0 |
| 2006-11-24 10:30:00 | IWM | ETF | 78.83 | 79.0 | 78.78 | 78.97 | 1629700.0 |
| 2006-11-24 11:00:00 | IWM | ETF | 78.97 | 79.03 | 78.89 | 78.95 | 2085600.0 |
| 2006-11-24 11:30:00 | IWM | ETF | 78.96 | 79.01 | 78.84 | 78.89 | 2448800.0 |
| 2006-11-24 12:00:00 | IWM | ETF | 78.89 | 78.97 | 78.81 | 78.95 | 1246400.0 |
| 2006-11-24 12:30:00 | IWM | ETF | 78.95 | 78.98 | 78.75 | 78.8 | 1720300.0 |
| 2006-11-24 13:00:00 | IWM | ETF | 78.79 | 78.79 | 78.51 | 78.56 | 547800.0 |
| 2006-11-24 07:30:00 | DIA | ETF | 122.81 | 122.81 | 122.79 | 122.79 | 600.0 |
| 2006-11-24 08:00:00 | DIA | ETF | 122.75 | 122.81 | 122.68 | 122.71 | 11100.0 |
| 2006-11-24 08:30:00 | DIA | ETF | 122.67 | 122.72 | 122.64 | 122.67 | 20000.0 |
| 2006-11-24 09:00:00 | DIA | ETF | 122.66 | 122.67 | 122.6 | 122.66 | 29500.0 |
| 2006-11-24 09:30:00 | DIA | ETF | 122.67 | 122.74 | 122.53 | 122.63 | 562900.0 |
| 2006-11-24 10:00:00 | DIA | ETF | 122.6388 | 122.97 | 122.6388 | 122.96 | 466400.0 |
| 2006-11-24 10:30:00 | DIA | ETF | 122.97 | 123.09 | 122.92 | 123.0 | 291000.0 |
| 2006-11-24 11:00:00 | DIA | ETF | 123.0 | 123.1 | 122.95 | 123.0 | 172700.0 |
| 2006-11-24 11:30:00 | DIA | ETF | 123.0099 | 123.03 | 122.79 | 122.88 | 133700.0 |
| 2006-11-24 12:00:00 | DIA | ETF | 122.87 | 122.97 | 122.86 | 122.96 | 93500.0 |
| 2006-11-24 12:30:00 | DIA | ETF | 122.97 | 122.97 | 122.81 | 122.82 | 167200.0 |
| 2006-11-24 13:00:00 | DIA | ETF | 122.81 | 122.84 | 122.68 | 122.68 | 18200.0 |
| 2006-11-24 07:30:00 | GLD | ETF | 63.33 | 63.33 | 63.3 | 63.3 | 54900.0 |
| 2006-11-24 08:00:00 | GLD | ETF | 63.32 | 63.48 | 63.25 | 63.48 | 142600.0 |
| 2006-11-24 08:30:00 | GLD | ETF | 63.46 | 63.53 | 63.29 | 63.29 | 108400.0 |
| 2006-11-24 09:00:00 | GLD | ETF | 63.28 | 63.5 | 63.28 | 63.48 | 1311400.0 |
| 2006-11-24 09:30:00 | GLD | ETF | 63.48 | 63.68 | 63.45 | 63.6001 | 2663600.0 |
| 2006-11-24 10:00:00 | GLD | ETF | 63.6 | 63.61 | 63.42 | 63.428 | 908900.0 |
| 2006-11-24 10:30:00 | GLD | ETF | 63.42 | 63.47 | 63.31 | 63.4312 | 716600.0 |
> showing 50 of 1,733 rows — these rows as CSV