PREVIEW / etf_30min / 2005-06-28
file: by_date/etf_30min/2005/2005-06-28.parquet size: 44 KB rows: 1,560
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-28 07:30:00 | SPY | ETF | 119.4 | 119.47 | 119.4 | 119.44 | 18300.0 |
| 2005-06-28 08:00:00 | SPY | ETF | 119.42 | 119.52 | 119.42 | 119.45 | 60400.0 |
| 2005-06-28 08:30:00 | SPY | ETF | 119.45 | 119.5 | 119.45 | 119.46 | 74300.0 |
| 2005-06-28 09:00:00 | SPY | ETF | 119.46 | 119.51 | 119.39 | 119.42 | 707500.0 |
| 2005-06-28 09:30:00 | SPY | ETF | 119.4 | 119.71 | 119.37 | 119.65 | 6474900.0 |
| 2005-06-28 10:00:00 | SPY | ETF | 119.69 | 119.86 | 119.6 | 119.8 | 6240600.0 |
| 2005-06-28 10:30:00 | SPY | ETF | 119.8 | 119.87 | 119.67 | 119.69 | 2898000.0 |
| 2005-06-28 11:00:00 | SPY | ETF | 119.69 | 119.86 | 119.68 | 119.78 | 1347000.0 |
| 2005-06-28 11:30:00 | SPY | ETF | 119.77 | 119.95 | 119.77 | 119.87 | 2400500.0 |
| 2005-06-28 12:00:00 | SPY | ETF | 119.87 | 119.94 | 119.82 | 119.83 | 1031900.0 |
| 2005-06-28 12:30:00 | SPY | ETF | 119.84 | 119.88 | 119.76 | 119.8 | 1158000.0 |
| 2005-06-28 13:00:00 | SPY | ETF | 119.82 | 120.1 | 119.79 | 120.05 | 2776600.0 |
| 2005-06-28 13:30:00 | SPY | ETF | 120.05 | 120.09 | 119.92 | 119.97 | 1611100.0 |
| 2005-06-28 14:00:00 | SPY | ETF | 119.97 | 120.04 | 119.9 | 119.95 | 1319200.0 |
| 2005-06-28 14:30:00 | SPY | ETF | 119.95 | 120.2 | 119.94 | 120.1 | 2679200.0 |
| 2005-06-28 15:00:00 | SPY | ETF | 120.09 | 120.19 | 120.05 | 120.14 | 3519100.0 |
| 2005-06-28 15:30:00 | SPY | ETF | 120.13 | 120.24 | 120.12 | 120.15 | 5645700.0 |
| 2005-06-28 16:00:00 | SPY | ETF | 120.16 | 120.22 | 119.8774 | 120.19 | 548500.0 |
| 2005-06-28 16:30:00 | SPY | ETF | 120.17 | 120.18 | 120.14 | 120.18 | 230300.0 |
| 2005-06-28 17:00:00 | SPY | ETF | 120.14 | 120.15 | 120.13 | 120.15 | 5000.0 |
| 2005-06-28 18:00:00 | SPY | ETF | 120.17 | 120.17 | 120.16 | 120.16 | 2000.0 |
| 2005-06-28 18:30:00 | SPY | ETF | 120.19 | 120.19 | 120.19 | 120.19 | 1900.0 |
| 2005-06-28 09:30:00 | QQQ | ETF | 36.94 | 37.05 | 36.9 | 37.01 | 11646200.0 |
| 2005-06-28 10:00:00 | QQQ | ETF | 37.01 | 37.1 | 37.01 | 37.04 | 10049900.0 |
| 2005-06-28 10:30:00 | QQQ | ETF | 37.04 | 37.09 | 36.95 | 36.97 | 4836200.0 |
| 2005-06-28 11:00:00 | QQQ | ETF | 36.97 | 37.06 | 36.96 | 37.01 | 2995000.0 |
| 2005-06-28 11:30:00 | QQQ | ETF | 37.01 | 37.11 | 36.99 | 37.06 | 3660300.0 |
| 2005-06-28 12:00:00 | QQQ | ETF | 37.06 | 37.1 | 37.03 | 37.03 | 2119200.0 |
| 2005-06-28 12:30:00 | QQQ | ETF | 37.03 | 37.04 | 36.98 | 37.04 | 2146200.0 |
| 2005-06-28 13:00:00 | QQQ | ETF | 37.03 | 37.17 | 37.03 | 37.14 | 4632200.0 |
| 2005-06-28 13:30:00 | QQQ | ETF | 37.14 | 37.16 | 37.11 | 37.13 | 2354400.0 |
| 2005-06-28 14:00:00 | QQQ | ETF | 37.14 | 37.18 | 37.12 | 37.14 | 2572000.0 |
| 2005-06-28 14:30:00 | QQQ | ETF | 37.14 | 37.25 | 37.13 | 37.2 | 7215100.0 |
| 2005-06-28 15:00:00 | QQQ | ETF | 37.2 | 37.24 | 37.19 | 37.22 | 5986800.0 |
| 2005-06-28 15:30:00 | QQQ | ETF | 37.22 | 37.26 | 37.15 | 37.15 | 10318000.0 |
| 2005-06-28 08:30:00 | IWM | ETF | 62.76 | 62.76 | 62.76 | 62.76 | 600.0 |
| 2005-06-28 09:00:00 | IWM | ETF | 62.75 | 62.78 | 62.75 | 62.78 | 8100.0 |
| 2005-06-28 09:30:00 | IWM | ETF | 62.77 | 63.08 | 62.72 | 63.06 | 2934700.0 |
| 2005-06-28 10:00:00 | IWM | ETF | 63.07 | 63.25 | 63.06 | 63.21 | 2099400.0 |
| 2005-06-28 10:30:00 | IWM | ETF | 63.22 | 63.27 | 63.13 | 63.17 | 1156100.0 |
| 2005-06-28 11:00:00 | IWM | ETF | 63.17 | 63.38 | 63.17 | 63.28 | 1186100.0 |
| 2005-06-28 11:30:00 | IWM | ETF | 63.28 | 63.45 | 63.27 | 63.42 | 725000.0 |
| 2005-06-28 12:00:00 | IWM | ETF | 63.42 | 63.52 | 63.35 | 63.36 | 877800.0 |
| 2005-06-28 12:30:00 | IWM | ETF | 63.36 | 63.4 | 63.33 | 63.36 | 468700.0 |
| 2005-06-28 13:00:00 | IWM | ETF | 63.36 | 63.58 | 63.36 | 63.54 | 1104800.0 |
| 2005-06-28 13:30:00 | IWM | ETF | 63.54 | 63.56 | 63.45 | 63.47 | 377800.0 |
| 2005-06-28 14:00:00 | IWM | ETF | 63.47 | 63.55 | 63.39 | 63.45 | 1312700.0 |
| 2005-06-28 14:30:00 | IWM | ETF | 63.44 | 63.65 | 63.43 | 63.58 | 1326200.0 |
| 2005-06-28 15:00:00 | IWM | ETF | 63.59 | 63.67 | 63.58 | 63.66 | 1154500.0 |
| 2005-06-28 15:30:00 | IWM | ETF | 63.67 | 63.81 | 63.66 | 63.8 | 3022700.0 |
> showing 50 of 1,560 rows — these rows as CSV