PREVIEW / etf_30min / 2002-09-27
file: by_date/etf_30min/2002/2002-09-27.parquet size: 20 KB rows: 553
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-09-27 09:30:00 | SPY | ETF | 85.0 | 85.19 | 84.51 | 84.91 | 10750800.0 |
| 2002-09-27 10:00:00 | SPY | ETF | 85.0 | 85.16 | 84.7 | 85.08 | 3942200.0 |
| 2002-09-27 10:30:00 | SPY | ETF | 85.09 | 85.63 | 84.92 | 85.27 | 4080500.0 |
| 2002-09-27 11:00:00 | SPY | ETF | 85.28 | 85.55 | 85.02 | 85.15 | 2721800.0 |
| 2002-09-27 11:30:00 | SPY | ETF | 85.15 | 85.25 | 84.58 | 84.8 | 3023900.0 |
| 2002-09-27 12:00:00 | SPY | ETF | 84.81 | 84.95 | 84.65 | 84.9 | 1925800.0 |
| 2002-09-27 12:30:00 | SPY | ETF | 84.88 | 85.03 | 84.05 | 84.09 | 2769000.0 |
| 2002-09-27 13:00:00 | SPY | ETF | 84.07 | 84.35 | 84.0 | 84.29 | 3742200.0 |
| 2002-09-27 13:30:00 | SPY | ETF | 84.29 | 84.39 | 83.7 | 83.86 | 3862700.0 |
| 2002-09-27 14:00:00 | SPY | ETF | 83.88 | 83.93 | 83.35 | 83.49 | 4232800.0 |
| 2002-09-27 14:30:00 | SPY | ETF | 83.61 | 83.72 | 83.26 | 83.43 | 4232800.0 |
| 2002-09-27 15:00:00 | SPY | ETF | 83.43 | 83.47 | 82.85 | 83.2 | 5411000.0 |
| 2002-09-27 15:30:00 | SPY | ETF | 83.22 | 83.32 | 82.8 | 82.85 | 6311900.0 |
| 2002-09-27 16:00:00 | SPY | ETF | 82.88 | 82.98 | 82.75 | 82.75 | 2369900.0 |
| 2002-09-27 09:30:00 | QQQ | ETF | 21.55 | 21.78 | 21.45 | 21.66 | 14208500.0 |
| 2002-09-27 10:00:00 | QQQ | ETF | 21.66 | 21.79 | 21.55 | 21.73 | 8377700.0 |
| 2002-09-27 10:30:00 | QQQ | ETF | 21.73 | 22.21 | 21.71 | 22.01 | 12413200.0 |
| 2002-09-27 11:00:00 | QQQ | ETF | 22.0 | 22.18 | 21.92 | 22.0 | 6327000.0 |
| 2002-09-27 11:30:00 | QQQ | ETF | 22.02 | 22.09 | 21.87 | 21.95 | 4909000.0 |
| 2002-09-27 12:00:00 | QQQ | ETF | 21.96 | 22.06 | 21.91 | 22.0 | 3255300.0 |
| 2002-09-27 12:30:00 | QQQ | ETF | 21.99 | 22.08 | 21.76 | 21.79 | 4239200.0 |
| 2002-09-27 13:00:00 | QQQ | ETF | 21.78 | 21.9 | 21.74 | 21.86 | 4223500.0 |
| 2002-09-27 13:30:00 | QQQ | ETF | 21.86 | 21.9 | 21.65 | 21.7 | 4920800.0 |
| 2002-09-27 14:00:00 | QQQ | ETF | 21.69 | 21.73 | 21.56 | 21.63 | 6204700.0 |
| 2002-09-27 14:30:00 | QQQ | ETF | 21.64 | 21.74 | 21.53 | 21.59 | 4043100.0 |
| 2002-09-27 15:00:00 | QQQ | ETF | 21.59 | 21.62 | 21.37 | 21.47 | 6054500.0 |
| 2002-09-27 15:30:00 | QQQ | ETF | 21.48 | 21.52 | 21.33 | 21.35 | 7723700.0 |
| 2002-09-27 16:00:00 | QQQ | ETF | 21.35 | 21.4 | 21.31 | 21.31 | 1147400.0 |
| 2002-09-27 09:30:00 | IWM | ETF | 36.625 | 36.925 | 36.625 | 36.925 | 142600.0 |
| 2002-09-27 10:00:00 | IWM | ETF | 36.795 | 36.86 | 36.78 | 36.825 | 63800.0 |
| 2002-09-27 10:30:00 | IWM | ETF | 36.82 | 37.02 | 36.82 | 36.945 | 358800.0 |
| 2002-09-27 11:00:00 | IWM | ETF | 36.93 | 36.975 | 36.865 | 36.875 | 119400.0 |
| 2002-09-27 11:30:00 | IWM | ETF | 36.875 | 36.875 | 36.725 | 36.725 | 206800.0 |
| 2002-09-27 12:00:00 | IWM | ETF | 36.775 | 36.78 | 36.65 | 36.75 | 67200.0 |
| 2002-09-27 12:30:00 | IWM | ETF | 36.77 | 36.77 | 36.545 | 36.545 | 117000.0 |
| 2002-09-27 13:00:00 | IWM | ETF | 36.525 | 36.555 | 36.395 | 36.395 | 69800.0 |
| 2002-09-27 13:30:00 | IWM | ETF | 36.43 | 36.47 | 36.35 | 36.35 | 471200.0 |
| 2002-09-27 14:00:00 | IWM | ETF | 36.35 | 36.37 | 36.15 | 36.22 | 289000.0 |
| 2002-09-27 14:30:00 | IWM | ETF | 36.2 | 36.245 | 36.125 | 36.2 | 160000.0 |
| 2002-09-27 15:00:00 | IWM | ETF | 36.2 | 36.2 | 36.025 | 36.125 | 64600.0 |
| 2002-09-27 15:30:00 | IWM | ETF | 36.155 | 36.155 | 36.02 | 36.02 | 250400.0 |
| 2002-09-27 16:00:00 | IWM | ETF | 36.02 | 36.025 | 36.02 | 36.025 | 7000.0 |
| 2002-09-27 09:30:00 | DIA | ETF | 79.21 | 79.36 | 78.84 | 79.19 | 1722300.0 |
| 2002-09-27 10:00:00 | DIA | ETF | 79.1 | 79.26 | 78.79 | 79.09 | 966600.0 |
| 2002-09-27 10:30:00 | DIA | ETF | 79.1 | 79.5 | 78.94 | 79.14 | 612600.0 |
| 2002-09-27 11:00:00 | DIA | ETF | 79.15 | 79.4 | 79.0 | 79.09 | 486500.0 |
| 2002-09-27 11:30:00 | DIA | ETF | 79.05 | 79.2 | 78.55 | 78.76 | 707900.0 |
| 2002-09-27 12:00:00 | DIA | ETF | 78.78 | 78.9 | 78.6 | 78.76 | 423300.0 |
| 2002-09-27 12:30:00 | DIA | ETF | 78.8 | 78.99 | 78.1 | 78.15 | 608600.0 |
| 2002-09-27 13:00:00 | DIA | ETF | 78.17 | 78.45 | 78.14 | 78.41 | 379300.0 |
> showing 50 of 553 rows — these rows as CSV