PREVIEW / etf_30min / 2006-07-14
file: by_date/etf_30min/2006/2006-07-14.parquet size: 78 KB rows: 2,722
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-07-14 06:00:00 | SPY | ETF | 124.32 | 124.35 | 124.29 | 124.34 | 27200.0 |
| 2006-07-14 06:30:00 | SPY | ETF | 124.32 | 124.34 | 124.25 | 124.25 | 73300.0 |
| 2006-07-14 07:00:00 | SPY | ETF | 124.28 | 124.28 | 124.07 | 124.09 | 74700.0 |
| 2006-07-14 07:30:00 | SPY | ETF | 124.09 | 124.16 | 123.95 | 124.04 | 49200.0 |
| 2006-07-14 08:00:00 | SPY | ETF | 123.5 | 124.4 | 123.5 | 123.99 | 494800.0 |
| 2006-07-14 08:30:00 | SPY | ETF | 123.98 | 124.33 | 123.9 | 124.31 | 2390700.0 |
| 2006-07-14 09:00:00 | SPY | ETF | 124.32 | 124.39 | 124.15 | 124.15 | 1250900.0 |
| 2006-07-14 09:30:00 | SPY | ETF | 124.16 | 124.26 | 123.77 | 123.9 | 9688400.0 |
| 2006-07-14 10:00:00 | SPY | ETF | 123.9 | 124.17 | 123.77 | 124.1 | 9206000.0 |
| 2006-07-14 10:30:00 | SPY | ETF | 124.09 | 124.24 | 123.77 | 123.8 | 6789800.0 |
| 2006-07-14 11:00:00 | SPY | ETF | 123.81 | 123.83 | 123.16 | 123.18 | 11297500.0 |
| 2006-07-14 11:30:00 | SPY | ETF | 123.17 | 123.37 | 122.83 | 123.35 | 9083100.0 |
| 2006-07-14 12:00:00 | SPY | ETF | 123.35 | 123.38 | 123.09 | 123.1701 | 3614800.0 |
| 2006-07-14 12:30:00 | SPY | ETF | 123.18 | 123.66 | 123.13 | 123.47 | 6079100.0 |
| 2006-07-14 13:00:00 | SPY | ETF | 123.48 | 123.66 | 123.2 | 123.57 | 4353400.0 |
| 2006-07-14 13:30:00 | SPY | ETF | 123.57 | 123.78 | 123.43 | 123.44 | 5414300.0 |
| 2006-07-14 14:00:00 | SPY | ETF | 123.44 | 123.6289 | 123.16 | 123.25 | 5158100.0 |
| 2006-07-14 14:30:00 | SPY | ETF | 123.25 | 123.49 | 123.15 | 123.4 | 5257400.0 |
| 2006-07-14 15:00:00 | SPY | ETF | 123.42 | 123.66 | 123.32 | 123.39 | 5117600.0 |
| 2006-07-14 15:30:00 | SPY | ETF | 123.41 | 123.87 | 123.26 | 123.63 | 9750300.0 |
| 2006-07-14 16:00:00 | SPY | ETF | 123.64 | 123.71 | 123.44 | 123.51 | 3102300.0 |
| 2006-07-14 16:30:00 | SPY | ETF | 123.55 | 123.6 | 123.55 | 123.55 | 33900.0 |
| 2006-07-14 17:00:00 | SPY | ETF | 123.55 | 123.55 | 123.5 | 123.5 | 18400.0 |
| 2006-07-14 17:30:00 | SPY | ETF | 123.51 | 123.6 | 123.51 | 123.6 | 29700.0 |
| 2006-07-14 18:00:00 | SPY | ETF | 123.6 | 123.68 | 123.6 | 123.68 | 11700.0 |
| 2006-07-14 09:30:00 | QQQ | ETF | 36.31 | 36.38 | 36.08 | 36.2 | 22351000.0 |
| 2006-07-14 10:00:00 | QQQ | ETF | 36.2 | 36.33 | 36.16 | 36.23 | 15316400.0 |
| 2006-07-14 10:30:00 | QQQ | ETF | 36.23 | 36.29 | 36.08 | 36.09 | 13245900.0 |
| 2006-07-14 11:00:00 | QQQ | ETF | 36.1 | 36.1 | 35.89 | 35.89 | 12726400.0 |
| 2006-07-14 11:30:00 | QQQ | ETF | 35.9 | 35.96 | 35.79 | 35.96 | 18011100.0 |
| 2006-07-14 12:00:00 | QQQ | ETF | 35.95 | 36.0 | 35.88 | 35.92 | 8026700.0 |
| 2006-07-14 12:30:00 | QQQ | ETF | 35.93 | 36.1 | 35.9 | 36.03 | 8366400.0 |
| 2006-07-14 13:00:00 | QQQ | ETF | 36.04 | 36.06 | 35.92 | 36.02 | 5175700.0 |
| 2006-07-14 13:30:00 | QQQ | ETF | 36.03 | 36.1 | 35.94 | 35.95 | 7307300.0 |
| 2006-07-14 14:00:00 | QQQ | ETF | 35.95 | 35.98 | 35.82 | 35.88 | 10086700.0 |
| 2006-07-14 14:30:00 | QQQ | ETF | 35.87 | 36.0 | 35.82 | 35.87 | 8261600.0 |
| 2006-07-14 15:00:00 | QQQ | ETF | 35.88 | 36.02 | 35.84 | 35.89 | 10131600.0 |
| 2006-07-14 15:30:00 | QQQ | ETF | 35.89 | 36.09 | 35.85 | 35.96 | 15507600.0 |
| 2006-07-14 08:00:00 | IWM | ETF | 68.1 | 68.1 | 67.79 | 67.81 | 73600.0 |
| 2006-07-14 08:30:00 | IWM | ETF | 67.86 | 68.13 | 67.71 | 68.13 | 115100.0 |
| 2006-07-14 09:00:00 | IWM | ETF | 68.15 | 68.2 | 68.06 | 68.08 | 431100.0 |
| 2006-07-14 09:30:00 | IWM | ETF | 68.08 | 68.21 | 67.67 | 67.82 | 11183500.0 |
| 2006-07-14 10:00:00 | IWM | ETF | 67.82 | 68.07 | 67.73 | 67.94 | 5371900.0 |
| 2006-07-14 10:30:00 | IWM | ETF | 67.93 | 68.11 | 67.76 | 67.8 | 4836600.0 |
| 2006-07-14 11:00:00 | IWM | ETF | 67.8 | 67.8 | 67.23 | 67.23 | 9538200.0 |
| 2006-07-14 11:30:00 | IWM | ETF | 67.23 | 67.59 | 66.95 | 67.59 | 6869600.0 |
| 2006-07-14 12:00:00 | IWM | ETF | 67.58 | 67.64 | 67.37 | 67.39 | 3387700.0 |
| 2006-07-14 12:30:00 | IWM | ETF | 67.4 | 67.8 | 67.33 | 67.7 | 4814400.0 |
| 2006-07-14 13:00:00 | IWM | ETF | 67.69 | 67.76 | 67.42 | 67.75 | 2868400.0 |
| 2006-07-14 13:30:00 | IWM | ETF | 67.75 | 67.97 | 67.6 | 67.6 | 4111100.0 |
> showing 50 of 2,722 rows — these rows as CSV