PREVIEW / etf_30min / 2005-11-03
file: by_date/etf_30min/2005/2005-11-03.parquet size: 52 KB rows: 1,828
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-11-03 07:00:00 | SPY | ETF | 121.69 | 121.69 | 121.66 | 121.66 | 3300.0 |
| 2005-11-03 07:30:00 | SPY | ETF | 121.71 | 121.76 | 121.65 | 121.65 | 8600.0 |
| 2005-11-03 08:00:00 | SPY | ETF | 121.71 | 121.73 | 121.59 | 121.69 | 220500.0 |
| 2005-11-03 08:30:00 | SPY | ETF | 121.75 | 122.18 | 121.71 | 122.17 | 2551100.0 |
| 2005-11-03 09:00:00 | SPY | ETF | 122.15 | 122.21 | 122.09 | 122.15 | 2215100.0 |
| 2005-11-03 09:30:00 | SPY | ETF | 122.15 | 122.55 | 122.11 | 122.43 | 13741500.0 |
| 2005-11-03 10:00:00 | SPY | ETF | 122.43 | 122.5 | 122.0 | 122.05 | 12727200.0 |
| 2005-11-03 10:30:00 | SPY | ETF | 122.05 | 122.51 | 121.96 | 122.22 | 8586500.0 |
| 2005-11-03 11:00:00 | SPY | ETF | 122.23 | 122.5 | 122.22 | 122.44 | 2804800.0 |
| 2005-11-03 11:30:00 | SPY | ETF | 122.44 | 122.51 | 122.33 | 122.36 | 2407900.0 |
| 2005-11-03 12:00:00 | SPY | ETF | 122.35 | 122.66 | 122.33 | 122.59 | 3208400.0 |
| 2005-11-03 12:30:00 | SPY | ETF | 122.59 | 122.66 | 122.38 | 122.41 | 2067700.0 |
| 2005-11-03 13:00:00 | SPY | ETF | 122.41 | 122.46 | 122.25 | 122.37 | 2754300.0 |
| 2005-11-03 13:30:00 | SPY | ETF | 122.38 | 122.41 | 122.17 | 122.33 | 4361600.0 |
| 2005-11-03 14:00:00 | SPY | ETF | 122.33 | 122.46 | 122.11 | 122.17 | 3250200.0 |
| 2005-11-03 14:30:00 | SPY | ETF | 122.19 | 122.39 | 121.89 | 122.03 | 4246300.0 |
| 2005-11-03 15:00:00 | SPY | ETF | 122.03 | 122.05 | 121.75 | 122.03 | 10924900.0 |
| 2005-11-03 15:30:00 | SPY | ETF | 122.03 | 122.17 | 121.88 | 122.14 | 6203600.0 |
| 2005-11-03 16:00:00 | SPY | ETF | 122.15 | 122.27 | 122.14 | 122.21 | 1157800.0 |
| 2005-11-03 16:30:00 | SPY | ETF | 122.25 | 122.27 | 122.0173 | 122.2 | 264800.0 |
| 2005-11-03 17:00:00 | SPY | ETF | 122.21 | 122.25 | 122.2 | 122.25 | 56600.0 |
| 2005-11-03 17:30:00 | SPY | ETF | 122.25 | 122.29 | 122.25 | 122.29 | 6400.0 |
| 2005-11-03 18:00:00 | SPY | ETF | 122.22 | 122.24 | 122.11 | 122.21 | 254100.0 |
| 2005-11-03 18:30:00 | SPY | ETF | 122.21 | 122.21 | 122.21 | 122.21 | 200.0 |
| 2005-11-03 19:00:00 | SPY | ETF | 122.21 | 122.21 | 122.21 | 122.21 | 700.0 |
| 2005-11-03 19:30:00 | SPY | ETF | 122.21 | 122.21 | 122.15 | 122.15 | 2500.0 |
| 2005-11-03 09:30:00 | QQQ | ETF | 39.74 | 39.86 | 39.69 | 39.82 | 17101300.0 |
| 2005-11-03 10:00:00 | QQQ | ETF | 39.81 | 39.83 | 39.68 | 39.73 | 15797500.0 |
| 2005-11-03 10:30:00 | QQQ | ETF | 39.73 | 39.91 | 38.86 | 39.85 | 11365000.0 |
| 2005-11-03 11:00:00 | QQQ | ETF | 39.83 | 39.98 | 39.83 | 39.95 | 8831400.0 |
| 2005-11-03 11:30:00 | QQQ | ETF | 39.95 | 39.97 | 39.9 | 39.94 | 10645500.0 |
| 2005-11-03 12:00:00 | QQQ | ETF | 39.94 | 40.07 | 39.93 | 40.05 | 10891700.0 |
| 2005-11-03 12:30:00 | QQQ | ETF | 40.06 | 40.09 | 39.9 | 39.98 | 7579700.0 |
| 2005-11-03 13:00:00 | QQQ | ETF | 39.98 | 40.01 | 39.95 | 40.0 | 3362600.0 |
| 2005-11-03 13:30:00 | QQQ | ETF | 40.0 | 40.0 | 39.9 | 39.94 | 4333800.0 |
| 2005-11-03 14:00:00 | QQQ | ETF | 39.93 | 39.98 | 39.82 | 39.85 | 6381300.0 |
| 2005-11-03 14:30:00 | QQQ | ETF | 39.86 | 39.88 | 39.79 | 39.85 | 8474500.0 |
| 2005-11-03 15:00:00 | QQQ | ETF | 39.85 | 39.88 | 39.75 | 39.88 | 8267400.0 |
| 2005-11-03 15:30:00 | QQQ | ETF | 39.89 | 39.98 | 39.8 | 39.95 | 9554200.0 |
| 2005-11-03 08:00:00 | IWM | ETF | 65.3 | 65.31 | 65.25 | 65.25 | 208100.0 |
| 2005-11-03 08:30:00 | IWM | ETF | 65.31 | 65.76 | 65.31 | 65.72 | 576700.0 |
| 2005-11-03 09:00:00 | IWM | ETF | 65.72 | 65.88 | 65.72 | 65.76 | 228000.0 |
| 2005-11-03 09:30:00 | IWM | ETF | 65.77 | 66.16 | 65.73 | 66.07 | 6720100.0 |
| 2005-11-03 10:00:00 | IWM | ETF | 66.07 | 66.08 | 65.7 | 65.71 | 8529600.0 |
| 2005-11-03 10:30:00 | IWM | ETF | 65.71 | 66.05 | 65.66 | 65.93 | 6342300.0 |
| 2005-11-03 11:00:00 | IWM | ETF | 65.92 | 66.11 | 65.9 | 66.02 | 1748600.0 |
| 2005-11-03 11:30:00 | IWM | ETF | 66.03 | 66.09 | 65.89 | 65.91 | 2016100.0 |
| 2005-11-03 12:00:00 | IWM | ETF | 65.88 | 66.09 | 65.88 | 66.06 | 1047200.0 |
| 2005-11-03 12:30:00 | IWM | ETF | 66.05 | 66.09 | 65.92 | 65.97 | 1469000.0 |
| 2005-11-03 13:00:00 | IWM | ETF | 65.96 | 66.0 | 65.89 | 65.9501 | 574600.0 |
> showing 50 of 1,828 rows — these rows as CSV