PREVIEW / etf_30min / 2002-07-17
file: by_date/etf_30min/2002/2002-07-17.parquet size: 19 KB rows: 522
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-07-17 09:30:00 | SPY | ETF | 92.46 | 93.3 | 92.21 | 92.5 | 5480000.0 |
| 2002-07-17 10:00:00 | SPY | ETF | 92.5 | 92.9 | 92.0 | 92.14 | 4394500.0 |
| 2002-07-17 10:30:00 | SPY | ETF | 92.25 | 92.32 | 91.41 | 91.45 | 3937300.0 |
| 2002-07-17 11:00:00 | SPY | ETF | 91.38 | 91.65 | 90.86 | 90.95 | 3812900.0 |
| 2002-07-17 11:30:00 | SPY | ETF | 90.96 | 91.7 | 90.86 | 91.0 | 2796800.0 |
| 2002-07-17 12:00:00 | SPY | ETF | 91.01 | 91.4 | 90.4 | 90.62 | 3290700.0 |
| 2002-07-17 12:30:00 | SPY | ETF | 90.61 | 90.91 | 89.75 | 90.0 | 4173400.0 |
| 2002-07-17 13:00:00 | SPY | ETF | 90.0 | 90.65 | 89.8 | 90.49 | 2203100.0 |
| 2002-07-17 13:30:00 | SPY | ETF | 90.49 | 91.1 | 90.24 | 90.86 | 2775700.0 |
| 2002-07-17 14:00:00 | SPY | ETF | 90.86 | 91.3 | 90.44 | 90.53 | 3137200.0 |
| 2002-07-17 14:30:00 | SPY | ETF | 90.53 | 90.77 | 89.97 | 90.33 | 1845900.0 |
| 2002-07-17 15:00:00 | SPY | ETF | 90.33 | 90.95 | 90.1 | 90.85 | 2987900.0 |
| 2002-07-17 15:30:00 | SPY | ETF | 90.85 | 91.45 | 90.56 | 91.0 | 3535100.0 |
| 2002-07-17 16:00:00 | SPY | ETF | 90.96 | 91.1 | 90.7 | 90.74 | 1222500.0 |
| 2002-07-17 09:30:00 | QQQ | ETF | 26.07 | 26.44 | 26.0 | 26.1 | 26026100.0 |
| 2002-07-17 10:00:00 | QQQ | ETF | 26.1 | 26.28 | 25.85 | 26.01 | 15911100.0 |
| 2002-07-17 10:30:00 | QQQ | ETF | 26.0 | 26.09 | 25.7 | 25.75 | 10037300.0 |
| 2002-07-17 11:00:00 | QQQ | ETF | 25.75 | 25.85 | 25.61 | 25.67 | 10669900.0 |
| 2002-07-17 11:30:00 | QQQ | ETF | 25.67 | 25.95 | 25.65 | 25.76 | 7553300.0 |
| 2002-07-17 12:00:00 | QQQ | ETF | 25.8 | 25.89 | 25.37 | 25.46 | 8002600.0 |
| 2002-07-17 12:30:00 | QQQ | ETF | 25.48 | 25.57 | 24.89 | 25.06 | 12000100.0 |
| 2002-07-17 13:00:00 | QQQ | ETF | 25.06 | 25.38 | 25.0 | 25.32 | 9353100.0 |
| 2002-07-17 13:30:00 | QQQ | ETF | 25.31 | 25.54 | 25.2 | 25.4 | 6796600.0 |
| 2002-07-17 14:00:00 | QQQ | ETF | 25.4 | 25.59 | 25.3 | 25.35 | 8509700.0 |
| 2002-07-17 14:30:00 | QQQ | ETF | 25.31 | 25.41 | 25.11 | 25.27 | 7193700.0 |
| 2002-07-17 15:00:00 | QQQ | ETF | 25.28 | 25.59 | 25.19 | 25.58 | 9467600.0 |
| 2002-07-17 15:30:00 | QQQ | ETF | 25.58 | 25.78 | 25.38 | 25.54 | 14970500.0 |
| 2002-07-17 16:00:00 | QQQ | ETF | 25.55 | 25.7 | 25.5 | 25.65 | 1469600.0 |
| 2002-07-17 09:30:00 | IWM | ETF | 41.495 | 41.5 | 41.175 | 41.175 | 347000.0 |
| 2002-07-17 10:00:00 | IWM | ETF | 41.2 | 41.475 | 41.115 | 41.185 | 574800.0 |
| 2002-07-17 10:30:00 | IWM | ETF | 41.18 | 41.265 | 40.9 | 40.93 | 244800.0 |
| 2002-07-17 11:00:00 | IWM | ETF | 40.93 | 40.94 | 40.62 | 40.64 | 225600.0 |
| 2002-07-17 11:30:00 | IWM | ETF | 40.64 | 40.78 | 40.6 | 40.63 | 138200.0 |
| 2002-07-17 12:00:00 | IWM | ETF | 40.62 | 40.665 | 40.075 | 40.075 | 184800.0 |
| 2002-07-17 12:30:00 | IWM | ETF | 40.1 | 40.35 | 40.1 | 40.1 | 93200.0 |
| 2002-07-17 13:00:00 | IWM | ETF | 40.07 | 40.31 | 40.06 | 40.295 | 152400.0 |
| 2002-07-17 13:30:00 | IWM | ETF | 40.32 | 40.49 | 40.23 | 40.475 | 139200.0 |
| 2002-07-17 14:00:00 | IWM | ETF | 40.475 | 40.68 | 40.475 | 40.56 | 92000.0 |
| 2002-07-17 14:30:00 | IWM | ETF | 40.55 | 40.62 | 40.365 | 40.365 | 149800.0 |
| 2002-07-17 15:00:00 | IWM | ETF | 40.45 | 40.66 | 40.39 | 40.65 | 177400.0 |
| 2002-07-17 15:30:00 | IWM | ETF | 40.65 | 40.875 | 40.64 | 40.75 | 104200.0 |
| 2002-07-17 16:00:00 | IWM | ETF | 40.875 | 40.875 | 40.875 | 40.875 | 11000.0 |
| 2002-07-17 09:30:00 | DIA | ETF | 86.62 | 87.5 | 86.56 | 86.77 | 1568200.0 |
| 2002-07-17 10:00:00 | DIA | ETF | 86.79 | 87.22 | 86.51 | 86.69 | 698500.0 |
| 2002-07-17 10:30:00 | DIA | ETF | 86.69 | 86.89 | 85.91 | 85.91 | 874000.0 |
| 2002-07-17 11:00:00 | DIA | ETF | 85.91 | 86.11 | 85.4 | 85.45 | 600500.0 |
| 2002-07-17 11:30:00 | DIA | ETF | 85.44 | 86.15 | 85.42 | 85.65 | 523600.0 |
| 2002-07-17 12:00:00 | DIA | ETF | 85.66 | 86.0 | 85.25 | 85.35 | 497400.0 |
| 2002-07-17 12:30:00 | DIA | ETF | 85.49 | 85.71 | 84.55 | 84.65 | 730200.0 |
| 2002-07-17 13:00:00 | DIA | ETF | 84.84 | 85.45 | 84.69 | 85.29 | 828000.0 |
> showing 50 of 522 rows — these rows as CSV