PREVIEW / etf_30min / 2002-08-28
file: by_date/etf_30min/2002/2002-08-28.parquet size: 20 KB rows: 568
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-28 09:30:00 | SPY | ETF | 93.28 | 93.49 | 93.1 | 93.25 | 5085800.0 |
| 2002-08-28 10:00:00 | SPY | ETF | 93.25 | 93.37 | 92.91 | 93.2 | 2704600.0 |
| 2002-08-28 10:30:00 | SPY | ETF | 93.16 | 93.23 | 92.83 | 93.01 | 2063800.0 |
| 2002-08-28 11:00:00 | SPY | ETF | 93.0 | 93.06 | 92.63 | 92.8 | 3079200.0 |
| 2002-08-28 11:30:00 | SPY | ETF | 92.81 | 92.82 | 92.26 | 92.41 | 3060000.0 |
| 2002-08-28 12:00:00 | SPY | ETF | 92.38 | 92.43 | 92.0 | 92.22 | 2952500.0 |
| 2002-08-28 12:30:00 | SPY | ETF | 92.18 | 92.62 | 92.11 | 92.51 | 1714400.0 |
| 2002-08-28 13:00:00 | SPY | ETF | 92.5 | 92.86 | 92.29 | 92.77 | 2328300.0 |
| 2002-08-28 13:30:00 | SPY | ETF | 92.8 | 92.8 | 92.14 | 92.35 | 2564400.0 |
| 2002-08-28 14:00:00 | SPY | ETF | 92.37 | 92.38 | 91.87 | 91.91 | 3081000.0 |
| 2002-08-28 14:30:00 | SPY | ETF | 92.0 | 92.5 | 91.92 | 92.12 | 2322200.0 |
| 2002-08-28 15:00:00 | SPY | ETF | 92.13 | 92.3 | 91.8 | 92.28 | 2100100.0 |
| 2002-08-28 15:30:00 | SPY | ETF | 92.28 | 92.8 | 92.16 | 92.3 | 3835900.0 |
| 2002-08-28 16:00:00 | SPY | ETF | 92.3 | 92.3 | 92.1 | 92.1 | 1067000.0 |
| 2002-08-28 09:30:00 | QQQ | ETF | 24.02 | 24.09 | 23.94 | 23.99 | 9686900.0 |
| 2002-08-28 10:00:00 | QQQ | ETF | 24.0 | 24.05 | 23.83 | 23.99 | 7797300.0 |
| 2002-08-28 10:30:00 | QQQ | ETF | 23.98 | 24.01 | 23.82 | 23.93 | 5670600.0 |
| 2002-08-28 11:00:00 | QQQ | ETF | 23.93 | 23.96 | 23.8 | 23.87 | 5665200.0 |
| 2002-08-28 11:30:00 | QQQ | ETF | 23.86 | 23.89 | 23.65 | 23.7 | 6778500.0 |
| 2002-08-28 12:00:00 | QQQ | ETF | 23.72 | 23.74 | 23.6 | 23.64 | 5175300.0 |
| 2002-08-28 12:30:00 | QQQ | ETF | 23.62 | 23.82 | 23.6 | 23.79 | 7949500.0 |
| 2002-08-28 13:00:00 | QQQ | ETF | 23.77 | 23.95 | 23.71 | 23.89 | 10004100.0 |
| 2002-08-28 13:30:00 | QQQ | ETF | 23.88 | 23.9 | 23.72 | 23.82 | 7273300.0 |
| 2002-08-28 14:00:00 | QQQ | ETF | 23.82 | 23.83 | 23.45 | 23.47 | 12421100.0 |
| 2002-08-28 14:30:00 | QQQ | ETF | 23.47 | 23.7 | 23.45 | 23.5 | 8532700.0 |
| 2002-08-28 15:00:00 | QQQ | ETF | 23.5 | 23.55 | 23.39 | 23.53 | 8606800.0 |
| 2002-08-28 15:30:00 | QQQ | ETF | 23.54 | 23.74 | 23.47 | 23.5 | 14301700.0 |
| 2002-08-28 16:00:00 | QQQ | ETF | 23.48 | 23.5 | 23.45 | 23.48 | 909300.0 |
| 2002-08-28 09:30:00 | IWM | ETF | 39.35 | 39.525 | 39.3 | 39.525 | 218200.0 |
| 2002-08-28 10:00:00 | IWM | ETF | 39.495 | 39.495 | 39.27 | 39.435 | 267800.0 |
| 2002-08-28 10:30:00 | IWM | ETF | 39.46 | 39.46 | 39.25 | 39.34 | 203600.0 |
| 2002-08-28 11:00:00 | IWM | ETF | 39.305 | 39.305 | 39.18 | 39.28 | 84800.0 |
| 2002-08-28 11:30:00 | IWM | ETF | 39.23 | 39.28 | 39.08 | 39.16 | 130200.0 |
| 2002-08-28 12:00:00 | IWM | ETF | 39.135 | 39.135 | 39.03 | 39.08 | 69800.0 |
| 2002-08-28 12:30:00 | IWM | ETF | 39.075 | 39.21 | 39.075 | 39.16 | 260600.0 |
| 2002-08-28 13:00:00 | IWM | ETF | 39.22 | 39.26 | 39.175 | 39.255 | 68000.0 |
| 2002-08-28 13:30:00 | IWM | ETF | 39.295 | 39.295 | 39.075 | 39.09 | 210000.0 |
| 2002-08-28 14:00:00 | IWM | ETF | 39.09 | 39.115 | 38.955 | 39.01 | 43600.0 |
| 2002-08-28 14:30:00 | IWM | ETF | 38.995 | 39.09 | 38.995 | 39.05 | 119200.0 |
| 2002-08-28 15:00:00 | IWM | ETF | 38.99 | 39.025 | 38.835 | 38.965 | 385200.0 |
| 2002-08-28 15:30:00 | IWM | ETF | 38.975 | 39.225 | 38.925 | 38.925 | 529200.0 |
| 2002-08-28 16:00:00 | IWM | ETF | 38.9 | 39.0 | 38.9 | 39.0 | 102800.0 |
| 2002-08-28 09:30:00 | DIA | ETF | 87.76 | 87.99 | 87.6 | 87.81 | 1118800.0 |
| 2002-08-28 10:00:00 | DIA | ETF | 87.8 | 87.93 | 87.55 | 87.81 | 664100.0 |
| 2002-08-28 10:30:00 | DIA | ETF | 87.77 | 87.84 | 87.53 | 87.69 | 432900.0 |
| 2002-08-28 11:00:00 | DIA | ETF | 87.66 | 87.72 | 87.33 | 87.46 | 725200.0 |
| 2002-08-28 11:30:00 | DIA | ETF | 87.46 | 87.51 | 87.06 | 87.22 | 532100.0 |
| 2002-08-28 12:00:00 | DIA | ETF | 87.26 | 87.3 | 86.9 | 87.06 | 370600.0 |
| 2002-08-28 12:30:00 | DIA | ETF | 87.09 | 87.45 | 86.99 | 87.39 | 459700.0 |
| 2002-08-28 13:00:00 | DIA | ETF | 87.35 | 87.64 | 87.1 | 87.49 | 433000.0 |
> showing 50 of 568 rows — these rows as CSV