PREVIEW / etf_30min / 2002-08-06
file: by_date/etf_30min/2002/2002-08-06.parquet size: 20 KB rows: 575
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-06 09:30:00 | SPY | ETF | 85.23 | 86.16 | 85.11 | 85.75 | 7940000.0 |
| 2002-08-06 10:00:00 | SPY | ETF | 85.76 | 87.35 | 85.76 | 86.84 | 11033700.0 |
| 2002-08-06 10:30:00 | SPY | ETF | 86.84 | 87.45 | 86.7 | 86.91 | 4962200.0 |
| 2002-08-06 11:00:00 | SPY | ETF | 86.91 | 87.39 | 86.71 | 87.03 | 4133500.0 |
| 2002-08-06 11:30:00 | SPY | ETF | 87.03 | 87.24 | 86.85 | 87.16 | 2171700.0 |
| 2002-08-06 12:00:00 | SPY | ETF | 87.19 | 87.58 | 85.5 | 87.4 | 2581400.0 |
| 2002-08-06 12:30:00 | SPY | ETF | 87.35 | 87.76 | 87.22 | 87.4 | 2551600.0 |
| 2002-08-06 13:00:00 | SPY | ETF | 87.38 | 87.58 | 87.05 | 87.24 | 2438700.0 |
| 2002-08-06 13:30:00 | SPY | ETF | 87.28 | 87.45 | 87.08 | 87.23 | 1865300.0 |
| 2002-08-06 14:00:00 | SPY | ETF | 87.21 | 87.42 | 86.9 | 87.21 | 2266600.0 |
| 2002-08-06 14:30:00 | SPY | ETF | 87.24 | 87.84 | 87.22 | 87.69 | 3593500.0 |
| 2002-08-06 15:00:00 | SPY | ETF | 87.75 | 87.9 | 87.5 | 87.59 | 3317300.0 |
| 2002-08-06 15:30:00 | SPY | ETF | 87.58 | 87.68 | 86.07 | 86.4 | 8042300.0 |
| 2002-08-06 16:00:00 | SPY | ETF | 86.35 | 86.59 | 86.25 | 86.59 | 1825900.0 |
| 2002-08-06 09:30:00 | QQQ | ETF | 21.8 | 22.04 | 21.8 | 21.94 | 12240500.0 |
| 2002-08-06 10:00:00 | QQQ | ETF | 21.94 | 22.52 | 21.93 | 22.41 | 13044700.0 |
| 2002-08-06 10:30:00 | QQQ | ETF | 22.42 | 22.56 | 22.3 | 22.38 | 8280100.0 |
| 2002-08-06 11:00:00 | QQQ | ETF | 22.39 | 22.65 | 22.36 | 22.57 | 6676100.0 |
| 2002-08-06 11:30:00 | QQQ | ETF | 22.57 | 22.6 | 22.48 | 22.54 | 3766300.0 |
| 2002-08-06 12:00:00 | QQQ | ETF | 22.51 | 22.74 | 21.83 | 22.67 | 4628400.0 |
| 2002-08-06 12:30:00 | QQQ | ETF | 22.7 | 22.8 | 22.61 | 22.67 | 4394200.0 |
| 2002-08-06 13:00:00 | QQQ | ETF | 22.67 | 22.76 | 22.54 | 22.67 | 5436500.0 |
| 2002-08-06 13:30:00 | QQQ | ETF | 22.69 | 22.74 | 22.62 | 22.7 | 4247000.0 |
| 2002-08-06 14:00:00 | QQQ | ETF | 22.71 | 22.77 | 22.55 | 22.71 | 2998000.0 |
| 2002-08-06 14:30:00 | QQQ | ETF | 22.71 | 22.97 | 22.67 | 22.95 | 9306000.0 |
| 2002-08-06 15:00:00 | QQQ | ETF | 22.95 | 23.01 | 22.84 | 22.87 | 11004300.0 |
| 2002-08-06 15:30:00 | QQQ | ETF | 22.89 | 22.9 | 22.26 | 22.43 | 16150600.0 |
| 2002-08-06 16:00:00 | QQQ | ETF | 22.43 | 22.55 | 22.4 | 22.5 | 1302000.0 |
| 2002-08-06 09:30:00 | IWM | ETF | 37.15 | 37.425 | 37.0 | 37.2 | 103800.0 |
| 2002-08-06 10:00:00 | IWM | ETF | 37.26 | 37.93 | 37.26 | 37.93 | 383600.0 |
| 2002-08-06 10:30:00 | IWM | ETF | 37.925 | 37.975 | 37.765 | 37.765 | 136200.0 |
| 2002-08-06 11:00:00 | IWM | ETF | 37.805 | 37.985 | 37.805 | 37.985 | 115600.0 |
| 2002-08-06 11:30:00 | IWM | ETF | 37.875 | 37.905 | 37.8 | 37.875 | 56800.0 |
| 2002-08-06 12:00:00 | IWM | ETF | 37.885 | 37.885 | 37.8 | 37.865 | 67200.0 |
| 2002-08-06 12:30:00 | IWM | ETF | 37.9 | 37.92 | 37.835 | 37.92 | 55800.0 |
| 2002-08-06 13:00:00 | IWM | ETF | 37.855 | 37.905 | 37.765 | 37.775 | 70000.0 |
| 2002-08-06 13:30:00 | IWM | ETF | 37.81 | 37.855 | 37.765 | 37.855 | 7600.0 |
| 2002-08-06 14:00:00 | IWM | ETF | 37.775 | 37.78 | 37.705 | 37.715 | 104600.0 |
| 2002-08-06 14:30:00 | IWM | ETF | 37.78 | 37.895 | 37.725 | 37.895 | 49600.0 |
| 2002-08-06 15:00:00 | IWM | ETF | 37.905 | 37.925 | 37.815 | 37.895 | 87400.0 |
| 2002-08-06 15:30:00 | IWM | ETF | 37.825 | 37.93 | 37.635 | 37.93 | 231600.0 |
| 2002-08-06 16:00:00 | IWM | ETF | 37.925 | 38.075 | 37.925 | 38.075 | 14400.0 |
| 2002-08-06 09:30:00 | DIA | ETF | 82.05 | 82.75 | 81.85 | 82.25 | 1629800.0 |
| 2002-08-06 10:00:00 | DIA | ETF | 82.27 | 83.8 | 82.23 | 83.42 | 1968500.0 |
| 2002-08-06 10:30:00 | DIA | ETF | 83.4 | 84.0 | 83.22 | 83.44 | 1117100.0 |
| 2002-08-06 11:00:00 | DIA | ETF | 83.46 | 83.95 | 83.23 | 83.65 | 769300.0 |
| 2002-08-06 11:30:00 | DIA | ETF | 83.64 | 83.86 | 83.45 | 83.75 | 507100.0 |
| 2002-08-06 12:00:00 | DIA | ETF | 83.74 | 83.97 | 83.55 | 83.83 | 383400.0 |
| 2002-08-06 12:30:00 | DIA | ETF | 83.84 | 84.25 | 83.72 | 83.91 | 487900.0 |
| 2002-08-06 13:00:00 | DIA | ETF | 83.94 | 84.07 | 83.47 | 83.71 | 516600.0 |
> showing 50 of 575 rows — these rows as CSV