PREVIEW / etf_30min / 2006-09-22
file: by_date/etf_30min/2006/2006-09-22.parquet size: 77 KB rows: 2,771
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-22 07:00:00 | SPY | ETF | 131.54 | 131.6 | 131.54 | 131.6 | 10600.0 |
| 2006-09-22 07:30:00 | SPY | ETF | 131.64 | 131.66 | 131.6 | 131.62 | 32200.0 |
| 2006-09-22 08:00:00 | SPY | ETF | 131.59 | 131.66 | 131.49 | 131.55 | 361600.0 |
| 2006-09-22 08:30:00 | SPY | ETF | 131.53 | 131.7 | 131.5 | 131.67 | 814300.0 |
| 2006-09-22 09:00:00 | SPY | ETF | 131.69 | 131.71 | 131.56 | 131.67 | 875700.0 |
| 2006-09-22 09:30:00 | SPY | ETF | 131.67 | 131.68 | 131.41 | 131.44 | 6603800.0 |
| 2006-09-22 10:00:00 | SPY | ETF | 131.45 | 131.45 | 131.15 | 131.2 | 10168000.0 |
| 2006-09-22 10:30:00 | SPY | ETF | 131.2 | 131.26 | 131.0 | 131.04 | 5099900.0 |
| 2006-09-22 11:00:00 | SPY | ETF | 131.05 | 131.29 | 131.0 | 131.18 | 5553000.0 |
| 2006-09-22 11:30:00 | SPY | ETF | 131.17 | 131.36 | 131.08 | 131.3 | 3781300.0 |
| 2006-09-22 12:00:00 | SPY | ETF | 131.3 | 131.3 | 131.0 | 131.15 | 3287000.0 |
| 2006-09-22 12:30:00 | SPY | ETF | 131.13 | 131.3 | 131.01 | 131.26 | 3912800.0 |
| 2006-09-22 13:00:00 | SPY | ETF | 131.26 | 131.37 | 131.14 | 131.29 | 4806900.0 |
| 2006-09-22 13:30:00 | SPY | ETF | 131.3 | 131.35 | 131.16 | 131.26 | 4824000.0 |
| 2006-09-22 14:00:00 | SPY | ETF | 131.25 | 131.33 | 131.14 | 131.19 | 2962600.0 |
| 2006-09-22 14:30:00 | SPY | ETF | 131.18 | 131.25 | 131.01 | 131.15 | 2499100.0 |
| 2006-09-22 15:00:00 | SPY | ETF | 131.15 | 131.54 | 131.13 | 131.39 | 4829800.0 |
| 2006-09-22 15:30:00 | SPY | ETF | 131.39 | 131.44 | 131.23 | 131.4 | 4055300.0 |
| 2006-09-22 16:00:00 | SPY | ETF | 131.39 | 131.5 | 131.36 | 131.45 | 555300.0 |
| 2006-09-22 16:30:00 | SPY | ETF | 131.45 | 131.5 | 131.41 | 131.45 | 74300.0 |
| 2006-09-22 17:00:00 | SPY | ETF | 131.5 | 131.6 | 131.5 | 131.6 | 15100.0 |
| 2006-09-22 17:30:00 | SPY | ETF | 131.5 | 131.5 | 131.5 | 131.5 | 400.0 |
| 2006-09-22 18:00:00 | SPY | ETF | 131.52 | 131.52 | 131.52 | 131.52 | 2000.0 |
| 2006-09-22 09:30:00 | QQQ | ETF | 40.16 | 40.16 | 39.93 | 39.96 | 15835400.0 |
| 2006-09-22 10:00:00 | QQQ | ETF | 39.97 | 39.98 | 38.84 | 39.9 | 14749500.0 |
| 2006-09-22 10:30:00 | QQQ | ETF | 39.9 | 39.96 | 39.78 | 39.83 | 6367300.0 |
| 2006-09-22 11:00:00 | QQQ | ETF | 39.83 | 39.95 | 39.79 | 39.83 | 5527600.0 |
| 2006-09-22 11:30:00 | QQQ | ETF | 39.83 | 39.92 | 39.83 | 39.89 | 5502200.0 |
| 2006-09-22 12:00:00 | QQQ | ETF | 39.9 | 39.9 | 39.72 | 39.76 | 5637700.0 |
| 2006-09-22 12:30:00 | QQQ | ETF | 39.75 | 39.85 | 39.7 | 39.83 | 3697800.0 |
| 2006-09-22 13:00:00 | QQQ | ETF | 39.82 | 39.92 | 39.8 | 39.85 | 6263100.0 |
| 2006-09-22 13:30:00 | QQQ | ETF | 39.85 | 39.88 | 39.79 | 39.84 | 3057000.0 |
| 2006-09-22 14:00:00 | QQQ | ETF | 39.83 | 39.9 | 39.8 | 39.8 | 3064700.0 |
| 2006-09-22 14:30:00 | QQQ | ETF | 39.8 | 39.85 | 39.74 | 39.8 | 4660700.0 |
| 2006-09-22 15:00:00 | QQQ | ETF | 39.8 | 39.97 | 39.78 | 39.89 | 8849600.0 |
| 2006-09-22 15:30:00 | QQQ | ETF | 39.89 | 39.92 | 39.84 | 39.87 | 8903600.0 |
| 2006-09-22 08:00:00 | IWM | ETF | 72.06 | 72.5 | 72.0 | 72.05 | 57000.0 |
| 2006-09-22 08:30:00 | IWM | ETF | 72.04 | 72.19 | 72.04 | 72.18 | 23800.0 |
| 2006-09-22 09:00:00 | IWM | ETF | 72.2 | 72.21 | 72.09 | 72.2 | 98200.0 |
| 2006-09-22 09:30:00 | IWM | ETF | 72.16 | 72.18 | 71.7 | 71.71 | 5349400.0 |
| 2006-09-22 10:00:00 | IWM | ETF | 71.72 | 71.73 | 71.47 | 71.56 | 7007200.0 |
| 2006-09-22 10:30:00 | IWM | ETF | 71.56 | 71.66 | 71.3 | 71.31 | 4331700.0 |
| 2006-09-22 11:00:00 | IWM | ETF | 71.31 | 71.6 | 71.24 | 71.27 | 4563400.0 |
| 2006-09-22 11:30:00 | IWM | ETF | 71.26 | 71.57 | 71.26 | 71.53 | 5494000.0 |
| 2006-09-22 12:00:00 | IWM | ETF | 71.53 | 71.54 | 71.13 | 71.15 | 3036500.0 |
| 2006-09-22 12:30:00 | IWM | ETF | 71.15 | 71.25 | 71.06 | 71.22 | 2003200.0 |
| 2006-09-22 13:00:00 | IWM | ETF | 71.22 | 71.6 | 71.19 | 71.34 | 2391400.0 |
| 2006-09-22 13:30:00 | IWM | ETF | 71.34 | 71.43 | 71.19 | 71.31 | 2806700.0 |
| 2006-09-22 14:00:00 | IWM | ETF | 71.31 | 71.38 | 71.2 | 71.27 | 2511000.0 |
| 2006-09-22 14:30:00 | IWM | ETF | 71.27 | 71.35 | 71.1 | 71.24 | 1750800.0 |
> showing 50 of 2,771 rows — these rows as CSV