PREVIEW / etf_30min / 2002-08-29
file: by_date/etf_30min/2002/2002-08-29.parquet size: 20 KB rows: 557
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-29 09:30:00 | SPY | ETF | 91.27 | 91.39 | 90.81 | 91.05 | 5984000.0 |
| 2002-08-29 10:00:00 | SPY | ETF | 91.05 | 91.84 | 90.97 | 91.63 | 4658100.0 |
| 2002-08-29 10:30:00 | SPY | ETF | 91.68 | 92.2 | 91.56 | 91.74 | 4281900.0 |
| 2002-08-29 11:00:00 | SPY | ETF | 91.78 | 92.05 | 91.56 | 91.93 | 1260100.0 |
| 2002-08-29 11:30:00 | SPY | ETF | 91.93 | 92.35 | 91.76 | 92.27 | 1965300.0 |
| 2002-08-29 12:00:00 | SPY | ETF | 92.27 | 92.65 | 92.24 | 92.64 | 2493200.0 |
| 2002-08-29 12:30:00 | SPY | ETF | 92.64 | 93.05 | 92.59 | 92.71 | 3208100.0 |
| 2002-08-29 13:00:00 | SPY | ETF | 92.71 | 92.83 | 92.4 | 92.51 | 1696800.0 |
| 2002-08-29 13:30:00 | SPY | ETF | 92.51 | 92.72 | 92.11 | 92.19 | 2070700.0 |
| 2002-08-29 14:00:00 | SPY | ETF | 92.2 | 92.48 | 91.95 | 92.11 | 1516600.0 |
| 2002-08-29 14:30:00 | SPY | ETF | 92.12 | 92.54 | 91.75 | 92.5 | 2570000.0 |
| 2002-08-29 15:00:00 | SPY | ETF | 92.49 | 92.83 | 92.3 | 92.54 | 4756700.0 |
| 2002-08-29 15:30:00 | SPY | ETF | 92.52 | 92.61 | 92.08 | 92.3 | 3191800.0 |
| 2002-08-29 16:00:00 | SPY | ETF | 92.32 | 92.32 | 92.05 | 92.14 | 1521500.0 |
| 2002-08-29 09:30:00 | QQQ | ETF | 23.2 | 23.28 | 23.02 | 23.18 | 14616500.0 |
| 2002-08-29 10:00:00 | QQQ | ETF | 23.18 | 23.7 | 23.15 | 23.61 | 11645600.0 |
| 2002-08-29 10:30:00 | QQQ | ETF | 23.6 | 23.93 | 23.6 | 23.75 | 9635800.0 |
| 2002-08-29 11:00:00 | QQQ | ETF | 23.74 | 23.86 | 23.66 | 23.82 | 5050100.0 |
| 2002-08-29 11:30:00 | QQQ | ETF | 23.82 | 23.99 | 23.75 | 23.93 | 4198600.0 |
| 2002-08-29 12:00:00 | QQQ | ETF | 23.93 | 24.06 | 23.89 | 24.05 | 4397200.0 |
| 2002-08-29 12:30:00 | QQQ | ETF | 24.05 | 24.22 | 24.0 | 24.11 | 7739100.0 |
| 2002-08-29 13:00:00 | QQQ | ETF | 24.12 | 24.19 | 24.0 | 24.05 | 4738900.0 |
| 2002-08-29 13:30:00 | QQQ | ETF | 24.05 | 24.18 | 23.86 | 23.94 | 5055200.0 |
| 2002-08-29 14:00:00 | QQQ | ETF | 23.94 | 24.03 | 23.71 | 23.81 | 4740700.0 |
| 2002-08-29 14:30:00 | QQQ | ETF | 23.81 | 23.94 | 23.63 | 23.88 | 6006700.0 |
| 2002-08-29 15:00:00 | QQQ | ETF | 23.93 | 24.08 | 23.82 | 23.97 | 6240300.0 |
| 2002-08-29 15:30:00 | QQQ | ETF | 23.97 | 24.0 | 23.79 | 23.86 | 7576800.0 |
| 2002-08-29 16:00:00 | QQQ | ETF | 23.87 | 23.88 | 23.76 | 23.79 | 722900.0 |
| 2002-08-29 09:30:00 | IWM | ETF | 38.425 | 38.65 | 38.425 | 38.62 | 186800.0 |
| 2002-08-29 10:00:00 | IWM | ETF | 38.705 | 39.07 | 38.675 | 38.95 | 186000.0 |
| 2002-08-29 10:30:00 | IWM | ETF | 38.95 | 39.265 | 38.95 | 39.155 | 107000.0 |
| 2002-08-29 11:00:00 | IWM | ETF | 39.155 | 39.24 | 39.1 | 39.205 | 65600.0 |
| 2002-08-29 11:30:00 | IWM | ETF | 39.225 | 39.35 | 39.195 | 39.27 | 80200.0 |
| 2002-08-29 12:00:00 | IWM | ETF | 39.35 | 39.435 | 39.285 | 39.415 | 198600.0 |
| 2002-08-29 12:30:00 | IWM | ETF | 39.415 | 39.61 | 39.375 | 39.485 | 145000.0 |
| 2002-08-29 13:00:00 | IWM | ETF | 39.5 | 39.545 | 39.32 | 39.32 | 190400.0 |
| 2002-08-29 13:30:00 | IWM | ETF | 39.31 | 39.35 | 39.21 | 39.215 | 82800.0 |
| 2002-08-29 14:00:00 | IWM | ETF | 39.25 | 39.315 | 39.235 | 39.275 | 303800.0 |
| 2002-08-29 14:30:00 | IWM | ETF | 39.21 | 39.325 | 39.15 | 39.325 | 124600.0 |
| 2002-08-29 15:00:00 | IWM | ETF | 39.335 | 39.45 | 39.28 | 39.4 | 125200.0 |
| 2002-08-29 15:30:00 | IWM | ETF | 39.485 | 39.485 | 39.26 | 39.33 | 225200.0 |
| 2002-08-29 16:00:00 | IWM | ETF | 39.25 | 39.29 | 39.25 | 39.29 | 22000.0 |
| 2002-08-29 09:30:00 | DIA | ETF | 86.2 | 86.32 | 85.76 | 85.97 | 1736700.0 |
| 2002-08-29 10:00:00 | DIA | ETF | 85.92 | 86.75 | 85.92 | 86.4 | 1153500.0 |
| 2002-08-29 10:30:00 | DIA | ETF | 86.35 | 86.86 | 86.32 | 86.43 | 767800.0 |
| 2002-08-29 11:00:00 | DIA | ETF | 86.43 | 86.7 | 86.27 | 86.64 | 337400.0 |
| 2002-08-29 11:30:00 | DIA | ETF | 86.61 | 87.02 | 86.47 | 86.97 | 390500.0 |
| 2002-08-29 12:00:00 | DIA | ETF | 86.97 | 87.3 | 86.8 | 87.27 | 852700.0 |
| 2002-08-29 12:30:00 | DIA | ETF | 87.28 | 87.6 | 87.2 | 87.34 | 509100.0 |
| 2002-08-29 13:00:00 | DIA | ETF | 87.34 | 87.43 | 87.0 | 87.15 | 332900.0 |
> showing 50 of 557 rows — these rows as CSV