PREVIEW / etf_30min / 2006-09-21
file: by_date/etf_30min/2006/2006-09-21.parquet size: 82 KB rows: 2,830
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-09-21 06:30:00 | SPY | ETF | 132.76 | 132.8 | 132.76 | 132.8 | 1900.0 |
| 2006-09-21 07:00:00 | SPY | ETF | 132.74 | 132.78 | 132.74 | 132.78 | 5500.0 |
| 2006-09-21 07:30:00 | SPY | ETF | 132.76 | 132.83 | 132.73 | 132.79 | 38200.0 |
| 2006-09-21 08:00:00 | SPY | ETF | 132.76 | 132.83 | 132.66 | 132.75 | 352500.0 |
| 2006-09-21 08:30:00 | SPY | ETF | 132.7 | 132.8 | 132.69 | 132.7 | 672200.0 |
| 2006-09-21 09:00:00 | SPY | ETF | 132.7 | 132.74 | 132.58 | 132.58 | 411400.0 |
| 2006-09-21 09:30:00 | SPY | ETF | 132.61 | 132.73 | 132.37 | 132.39 | 7238800.0 |
| 2006-09-21 10:00:00 | SPY | ETF | 132.39 | 132.42 | 132.15 | 132.33 | 6310400.0 |
| 2006-09-21 10:30:00 | SPY | ETF | 132.34 | 132.54 | 132.29 | 132.45 | 2763000.0 |
| 2006-09-21 11:00:00 | SPY | ETF | 132.44 | 132.75 | 132.44 | 132.6 | 4448500.0 |
| 2006-09-21 11:30:00 | SPY | ETF | 132.59 | 132.73 | 132.45 | 132.599 | 4272800.0 |
| 2006-09-21 12:00:00 | SPY | ETF | 132.59 | 132.62 | 132.08 | 132.16 | 8130900.0 |
| 2006-09-21 12:30:00 | SPY | ETF | 132.16 | 132.24 | 131.84 | 131.91 | 11300200.0 |
| 2006-09-21 13:00:00 | SPY | ETF | 131.91 | 132.03 | 131.7 | 131.82 | 7859000.0 |
| 2006-09-21 13:30:00 | SPY | ETF | 131.81 | 132.03 | 131.79 | 131.94 | 2618300.0 |
| 2006-09-21 14:00:00 | SPY | ETF | 131.95 | 132.05 | 131.64 | 131.67 | 7106800.0 |
| 2006-09-21 14:30:00 | SPY | ETF | 131.66 | 131.91 | 131.63 | 131.6601 | 3824300.0 |
| 2006-09-21 15:00:00 | SPY | ETF | 131.67 | 131.84 | 131.42 | 131.55 | 10108600.0 |
| 2006-09-21 15:30:00 | SPY | ETF | 131.55 | 131.87 | 131.53 | 131.69 | 5541500.0 |
| 2006-09-21 16:00:00 | SPY | ETF | 131.71 | 132.4267 | 131.7 | 131.89 | 2403700.0 |
| 2006-09-21 16:30:00 | SPY | ETF | 131.86 | 131.9 | 131.81 | 131.83 | 1858700.0 |
| 2006-09-21 17:00:00 | SPY | ETF | 131.88 | 131.89 | 131.85 | 131.85 | 5100.0 |
| 2006-09-21 17:30:00 | SPY | ETF | 131.88 | 131.89 | 131.86 | 131.88 | 1700.0 |
| 2006-09-21 18:00:00 | SPY | ETF | 131.88 | 131.9 | 131.81 | 131.81 | 13100.0 |
| 2006-09-21 18:30:00 | SPY | ETF | 131.82 | 131.83 | 131.82 | 131.83 | 1000.0 |
| 2006-09-21 19:30:00 | SPY | ETF | 131.87 | 131.87 | 131.87 | 131.87 | 500.0 |
| 2006-09-21 09:30:00 | QQQ | ETF | 40.52 | 40.64 | 40.44 | 40.48 | 14955000.0 |
| 2006-09-21 10:00:00 | QQQ | ETF | 40.48 | 40.48 | 40.31 | 40.46 | 11519700.0 |
| 2006-09-21 10:30:00 | QQQ | ETF | 40.46 | 40.57 | 40.4 | 40.5 | 8966100.0 |
| 2006-09-21 11:00:00 | QQQ | ETF | 40.5 | 40.67 | 40.49 | 40.58 | 7448000.0 |
| 2006-09-21 11:30:00 | QQQ | ETF | 40.59 | 40.61 | 40.5 | 40.53 | 4093800.0 |
| 2006-09-21 12:00:00 | QQQ | ETF | 40.54 | 40.55 | 40.38 | 40.44 | 9711000.0 |
| 2006-09-21 12:30:00 | QQQ | ETF | 40.44 | 40.48 | 40.25 | 40.32 | 10714500.0 |
| 2006-09-21 13:00:00 | QQQ | ETF | 40.31 | 40.36 | 40.2 | 40.25 | 7173800.0 |
| 2006-09-21 13:30:00 | QQQ | ETF | 40.25 | 40.38 | 40.23 | 40.3 | 4146600.0 |
| 2006-09-21 14:00:00 | QQQ | ETF | 40.3 | 40.34 | 40.16 | 40.18 | 4996900.0 |
| 2006-09-21 14:30:00 | QQQ | ETF | 40.18 | 40.27 | 40.14 | 40.15 | 7710900.0 |
| 2006-09-21 15:00:00 | QQQ | ETF | 40.16 | 40.22 | 40.08 | 40.14 | 14788900.0 |
| 2006-09-21 15:30:00 | QQQ | ETF | 40.14 | 40.21 | 40.12 | 40.17 | 8891200.0 |
| 2006-09-21 07:30:00 | IWM | ETF | 73.5 | 73.7 | 73.5 | 73.6 | 8600.0 |
| 2006-09-21 08:00:00 | IWM | ETF | 73.6 | 73.6 | 73.29 | 73.5 | 169300.0 |
| 2006-09-21 08:30:00 | IWM | ETF | 73.5 | 73.55 | 73.48 | 73.49 | 85900.0 |
| 2006-09-21 09:00:00 | IWM | ETF | 73.49 | 73.5 | 73.33 | 73.37 | 74400.0 |
| 2006-09-21 09:30:00 | IWM | ETF | 73.35 | 73.5 | 72.99 | 72.99 | 4436800.0 |
| 2006-09-21 10:00:00 | IWM | ETF | 72.98 | 73.3 | 72.72 | 72.92 | 4023800.0 |
| 2006-09-21 10:30:00 | IWM | ETF | 72.92 | 73.18 | 72.84 | 73.06 | 3139500.0 |
| 2006-09-21 11:00:00 | IWM | ETF | 73.04 | 73.54 | 73.04 | 73.45 | 6121800.0 |
| 2006-09-21 11:30:00 | IWM | ETF | 73.45 | 73.57 | 73.31 | 73.41 | 3101700.0 |
| 2006-09-21 12:00:00 | IWM | ETF | 73.42 | 73.45 | 72.8 | 72.88 | 7362500.0 |
| 2006-09-21 12:30:00 | IWM | ETF | 72.88 | 73.01 | 72.5 | 72.57 | 5075200.0 |
> showing 50 of 2,830 rows — these rows as CSV