PREVIEW / etf_30min / 2006-12-26
file: by_date/etf_30min/2006/2006-12-26.parquet size: 81 KB rows: 2,894
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-12-26 07:30:00 | SPY | ETF | 140.83 | 140.9 | 140.8 | 140.9 | 23500.0 |
| 2006-12-26 08:00:00 | SPY | ETF | 140.89 | 140.9 | 140.8 | 140.88 | 837900.0 |
| 2006-12-26 08:30:00 | SPY | ETF | 140.87 | 140.88 | 140.83 | 140.86 | 215900.0 |
| 2006-12-26 09:00:00 | SPY | ETF | 140.85 | 140.88 | 140.8 | 140.82 | 80700.0 |
| 2006-12-26 09:30:00 | SPY | ETF | 140.81 | 141.43 | 140.78 | 141.22 | 6959500.0 |
| 2006-12-26 10:00:00 | SPY | ETF | 141.21 | 141.3 | 141.14 | 141.23 | 2307400.0 |
| 2006-12-26 10:30:00 | SPY | ETF | 141.23 | 141.25 | 141.05 | 141.08 | 1403100.0 |
| 2006-12-26 11:00:00 | SPY | ETF | 141.08 | 141.28 | 141.06 | 141.25 | 2196200.0 |
| 2006-12-26 11:30:00 | SPY | ETF | 141.25 | 141.28 | 141.21 | 141.27 | 1216500.0 |
| 2006-12-26 12:00:00 | SPY | ETF | 141.27 | 141.27 | 141.16 | 141.191 | 2868200.0 |
| 2006-12-26 12:30:00 | SPY | ETF | 141.18 | 141.21 | 141.14 | 141.18 | 550200.0 |
| 2006-12-26 13:00:00 | SPY | ETF | 141.18 | 141.26 | 141.14 | 141.22 | 749500.0 |
| 2006-12-26 13:30:00 | SPY | ETF | 141.22 | 141.4 | 141.2 | 141.36 | 1294200.0 |
| 2006-12-26 14:00:00 | SPY | ETF | 141.36 | 141.38 | 141.32 | 141.36 | 799000.0 |
| 2006-12-26 14:30:00 | SPY | ETF | 141.36 | 141.4 | 141.24 | 141.28 | 856100.0 |
| 2006-12-26 15:00:00 | SPY | ETF | 141.28 | 141.39 | 141.25 | 141.37 | 1833600.0 |
| 2006-12-26 15:30:00 | SPY | ETF | 141.37 | 141.58 | 141.36 | 141.54 | 2948500.0 |
| 2006-12-26 16:00:00 | SPY | ETF | 141.54 | 141.66 | 141.5 | 141.57 | 559700.0 |
| 2006-12-26 16:30:00 | SPY | ETF | 141.57 | 141.6 | 141.56 | 141.6 | 6700.0 |
| 2006-12-26 17:00:00 | SPY | ETF | 141.59 | 141.6 | 141.55 | 141.6 | 11300.0 |
| 2006-12-26 17:30:00 | SPY | ETF | 141.55 | 141.61 | 141.55 | 141.61 | 1400.0 |
| 2006-12-26 18:00:00 | SPY | ETF | 141.58 | 141.58 | 141.58 | 141.58 | 200.0 |
| 2006-12-26 18:30:00 | SPY | ETF | 141.6 | 141.6 | 141.6 | 141.6 | 500.0 |
| 2006-12-26 19:00:00 | SPY | ETF | 141.58 | 141.6 | 141.58 | 141.6 | 1000.0 |
| 2006-12-26 19:30:00 | SPY | ETF | 141.59 | 141.6 | 141.59 | 141.6 | 1500.0 |
| 2006-12-26 09:30:00 | QQQ | ETF | 42.93 | 43.12 | 42.88 | 43.01 | 11030600.0 |
| 2006-12-26 10:00:00 | QQQ | ETF | 43.01 | 43.07 | 42.96 | 43.02 | 3244300.0 |
| 2006-12-26 10:30:00 | QQQ | ETF | 43.02 | 43.04 | 42.93 | 42.95 | 3832400.0 |
| 2006-12-26 11:00:00 | QQQ | ETF | 42.95 | 43.06 | 42.94 | 43.03 | 5311300.0 |
| 2006-12-26 11:30:00 | QQQ | ETF | 43.03 | 43.06 | 43.01 | 43.03 | 2868700.0 |
| 2006-12-26 12:00:00 | QQQ | ETF | 43.03 | 43.05 | 42.98 | 43.0 | 1803200.0 |
| 2006-12-26 12:30:00 | QQQ | ETF | 42.99 | 43.01 | 42.97 | 42.99 | 592400.0 |
| 2006-12-26 13:00:00 | QQQ | ETF | 42.99 | 43.04 | 42.99 | 43.02 | 1949500.0 |
| 2006-12-26 13:30:00 | QQQ | ETF | 43.01 | 43.06 | 43.0 | 43.04 | 1498900.0 |
| 2006-12-26 14:00:00 | QQQ | ETF | 43.03 | 43.05 | 43.01 | 43.03 | 1858200.0 |
| 2006-12-26 14:30:00 | QQQ | ETF | 43.03 | 43.05 | 42.99 | 43.0 | 2703400.0 |
| 2006-12-26 15:00:00 | QQQ | ETF | 43.0 | 43.05 | 42.99 | 43.03 | 1886300.0 |
| 2006-12-26 15:30:00 | QQQ | ETF | 43.02 | 43.12 | 43.02 | 43.12 | 4870100.0 |
| 2006-12-26 08:00:00 | IWM | ETF | 77.39 | 77.39 | 77.34 | 77.34 | 3900.0 |
| 2006-12-26 08:30:00 | IWM | ETF | 77.35 | 77.35 | 77.29 | 77.29 | 7600.0 |
| 2006-12-26 09:00:00 | IWM | ETF | 77.28 | 77.35 | 77.27 | 77.35 | 16200.0 |
| 2006-12-26 09:30:00 | IWM | ETF | 77.33 | 78.13 | 77.3 | 78.0 | 4517800.0 |
| 2006-12-26 10:00:00 | IWM | ETF | 78.0 | 78.03 | 77.9 | 77.95 | 1571200.0 |
| 2006-12-26 10:30:00 | IWM | ETF | 77.96 | 78.01 | 77.86 | 77.88 | 1380000.0 |
| 2006-12-26 11:00:00 | IWM | ETF | 77.89 | 78.05 | 77.88 | 78.01 | 1998300.0 |
| 2006-12-26 11:30:00 | IWM | ETF | 78.01 | 78.03 | 77.93 | 77.97 | 546300.0 |
| 2006-12-26 12:00:00 | IWM | ETF | 77.97 | 77.98 | 77.9 | 77.92 | 445000.0 |
| 2006-12-26 12:30:00 | IWM | ETF | 77.91 | 77.94 | 77.82 | 77.88 | 944900.0 |
| 2006-12-26 13:00:00 | IWM | ETF | 77.87 | 77.94 | 77.86 | 77.9 | 1672600.0 |
| 2006-12-26 13:30:00 | IWM | ETF | 77.9 | 78.09 | 77.9 | 78.02 | 1132100.0 |
> showing 50 of 2,894 rows — these rows as CSV