PREVIEW / etf_30min / 2001-08-29
file: by_date/etf_30min/2001/2001-08-29.parquet size: 15 KB rows: 389
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 |
|---|---|---|---|---|---|---|---|
| 2001-08-29 09:30:00 | SPY | ETF | 117.13 | 117.18 | 116.71 | 116.79 | 2311800.0 |
| 2001-08-29 10:00:00 | SPY | ETF | 116.8 | 116.8 | 115.8 | 115.94 | 2393300.0 |
| 2001-08-29 10:30:00 | SPY | ETF | 115.94 | 115.98 | 115.53 | 115.84 | 2066300.0 |
| 2001-08-29 11:00:00 | SPY | ETF | 115.84 | 116.09 | 115.68 | 116.09 | 1219500.0 |
| 2001-08-29 11:30:00 | SPY | ETF | 116.04 | 116.07 | 115.64 | 115.64 | 151200.0 |
| 2001-08-29 12:00:00 | SPY | ETF | 115.65 | 115.89 | 115.61 | 115.75 | 322300.0 |
| 2001-08-29 12:30:00 | SPY | ETF | 115.73 | 115.95 | 115.69 | 115.71 | 344400.0 |
| 2001-08-29 13:00:00 | SPY | ETF | 115.71 | 115.93 | 115.52 | 115.87 | 529800.0 |
| 2001-08-29 13:30:00 | SPY | ETF | 115.86 | 115.96 | 115.6 | 115.76 | 329100.0 |
| 2001-08-29 14:00:00 | SPY | ETF | 115.74 | 115.86 | 115.5 | 115.84 | 318200.0 |
| 2001-08-29 14:30:00 | SPY | ETF | 115.81 | 115.81 | 115.34 | 115.38 | 1039600.0 |
| 2001-08-29 15:00:00 | SPY | ETF | 115.4 | 115.5 | 115.17 | 115.43 | 1473600.0 |
| 2001-08-29 15:30:00 | SPY | ETF | 115.43 | 115.65 | 115.24 | 115.39 | 1585300.0 |
| 2001-08-29 16:00:00 | SPY | ETF | 115.37 | 115.6 | 115.26 | 115.6 | 1252400.0 |
| 2001-08-29 16:30:00 | SPY | ETF | 115.4 | 115.66 | 115.4 | 115.66 | 151000.0 |
| 2001-08-29 17:00:00 | SPY | ETF | 115.55 | 115.6 | 115.5 | 115.52 | 18400.0 |
| 2001-08-29 17:30:00 | SPY | ETF | 115.54 | 115.54 | 115.45 | 115.54 | 2800.0 |
| 2001-08-29 09:30:00 | QQQ | ETF | 38.37 | 38.45 | 37.85 | 37.88 | 9657400.0 |
| 2001-08-29 10:00:00 | QQQ | ETF | 37.91 | 37.93 | 37.43 | 37.55 | 5801900.0 |
| 2001-08-29 10:30:00 | QQQ | ETF | 37.51 | 37.58 | 37.15 | 37.47 | 8553500.0 |
| 2001-08-29 11:00:00 | QQQ | ETF | 37.48 | 37.69 | 37.35 | 37.64 | 3766200.0 |
| 2001-08-29 11:30:00 | QQQ | ETF | 37.67 | 37.69 | 37.4 | 37.41 | 2292600.0 |
| 2001-08-29 12:00:00 | QQQ | ETF | 37.45 | 37.63 | 37.41 | 37.55 | 1273600.0 |
| 2001-08-29 12:30:00 | QQQ | ETF | 37.55 | 37.71 | 37.45 | 37.5 | 1227900.0 |
| 2001-08-29 13:00:00 | QQQ | ETF | 37.53 | 37.61 | 37.22 | 37.58 | 3089900.0 |
| 2001-08-29 13:30:00 | QQQ | ETF | 37.57 | 37.65 | 37.3 | 37.44 | 1804000.0 |
| 2001-08-29 14:00:00 | QQQ | ETF | 37.45 | 37.67 | 37.32 | 37.63 | 3055000.0 |
| 2001-08-29 14:30:00 | QQQ | ETF | 37.63 | 37.65 | 37.22 | 37.3 | 3709200.0 |
| 2001-08-29 15:00:00 | QQQ | ETF | 37.27 | 37.4 | 37.13 | 37.33 | 4676900.0 |
| 2001-08-29 15:30:00 | QQQ | ETF | 37.32 | 37.52 | 37.2 | 37.35 | 4490500.0 |
| 2001-08-29 16:00:00 | QQQ | ETF | 37.35 | 38.05 | 37.32 | 37.53 | 1468300.0 |
| 2001-08-29 16:30:00 | QQQ | ETF | 37.53 | 37.57 | 37.25 | 37.4 | 833900.0 |
| 2001-08-29 17:00:00 | QQQ | ETF | 37.4 | 37.48 | 37.2 | 37.32 | 314500.0 |
| 2001-08-29 17:30:00 | QQQ | ETF | 37.27 | 37.4 | 37.27 | 37.4 | 75200.0 |
| 2001-08-29 18:00:00 | QQQ | ETF | 37.4 | 37.4 | 37.25 | 37.32 | 34500.0 |
| 2001-08-29 09:30:00 | IWM | ETF | 47.525 | 47.525 | 47.375 | 47.375 | 34800.0 |
| 2001-08-29 10:00:00 | IWM | ETF | 47.305 | 47.305 | 47.105 | 47.125 | 183400.0 |
| 2001-08-29 10:30:00 | IWM | ETF | 47.06 | 47.06 | 46.9 | 47.035 | 27600.0 |
| 2001-08-29 11:00:00 | IWM | ETF | 47.055 | 47.145 | 47.055 | 47.135 | 1600.0 |
| 2001-08-29 11:30:00 | IWM | ETF | 47.12 | 47.12 | 47.05 | 47.05 | 1800.0 |
| 2001-08-29 12:00:00 | IWM | ETF | 47.125 | 47.125 | 47.105 | 47.105 | 1000.0 |
| 2001-08-29 12:30:00 | IWM | ETF | 47.115 | 47.2 | 47.115 | 47.155 | 2800.0 |
| 2001-08-29 13:00:00 | IWM | ETF | 47.14 | 47.245 | 47.14 | 47.225 | 36800.0 |
| 2001-08-29 13:30:00 | IWM | ETF | 47.325 | 47.325 | 47.225 | 47.29 | 110400.0 |
| 2001-08-29 14:00:00 | IWM | ETF | 47.29 | 47.29 | 47.245 | 47.245 | 8600.0 |
| 2001-08-29 14:30:00 | IWM | ETF | 47.25 | 47.295 | 47.1 | 47.175 | 29200.0 |
| 2001-08-29 15:00:00 | IWM | ETF | 47.11 | 47.165 | 47.0 | 47.165 | 13600.0 |
| 2001-08-29 15:30:00 | IWM | ETF | 47.18 | 47.18 | 47.105 | 47.105 | 77800.0 |
| 2001-08-29 16:00:00 | IWM | ETF | 47.05 | 47.15 | 47.05 | 47.15 | 123600.0 |
| 2001-08-29 09:30:00 | DIA | ETF | 102.7 | 102.85 | 102.37 | 102.5 | 377600.0 |
> showing 50 of 389 rows — these rows as CSV