PREVIEW / etf_30min / 2002-04-05
file: by_date/etf_30min/2002/2002-04-05.parquet size: 18 KB rows: 471
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-04-05 09:30:00 | SPY | ETF | 113.19 | 113.63 | 113.0 | 113.25 | 4143900.0 |
| 2002-04-05 10:00:00 | SPY | ETF | 113.26 | 113.46 | 113.09 | 113.19 | 1412100.0 |
| 2002-04-05 10:30:00 | SPY | ETF | 113.15 | 113.27 | 112.86 | 112.96 | 772000.0 |
| 2002-04-05 11:00:00 | SPY | ETF | 112.95 | 113.1 | 112.6 | 112.7 | 1012400.0 |
| 2002-04-05 11:30:00 | SPY | ETF | 112.72 | 112.87 | 112.65 | 112.74 | 485800.0 |
| 2002-04-05 12:00:00 | SPY | ETF | 112.76 | 112.76 | 112.18 | 112.37 | 1213900.0 |
| 2002-04-05 12:30:00 | SPY | ETF | 112.36 | 112.68 | 112.31 | 112.62 | 1090600.0 |
| 2002-04-05 13:00:00 | SPY | ETF | 112.65 | 112.68 | 112.4 | 112.51 | 453200.0 |
| 2002-04-05 13:30:00 | SPY | ETF | 112.49 | 113.03 | 112.49 | 112.91 | 2422000.0 |
| 2002-04-05 14:00:00 | SPY | ETF | 112.93 | 113.09 | 112.76 | 112.83 | 1075900.0 |
| 2002-04-05 14:30:00 | SPY | ETF | 112.81 | 113.06 | 112.71 | 112.73 | 438000.0 |
| 2002-04-05 15:00:00 | SPY | ETF | 112.73 | 112.8 | 112.46 | 112.53 | 1194300.0 |
| 2002-04-05 15:30:00 | SPY | ETF | 112.56 | 112.88 | 112.47 | 112.53 | 1873100.0 |
| 2002-04-05 16:00:00 | SPY | ETF | 112.48 | 112.7 | 112.46 | 112.65 | 951700.0 |
| 2002-04-05 16:30:00 | SPY | ETF | 112.65 | 112.65 | 112.65 | 112.65 | 10000.0 |
| 2002-04-05 09:30:00 | QQQ | ETF | 35.01 | 35.17 | 34.75 | 34.77 | 9544100.0 |
| 2002-04-05 10:00:00 | QQQ | ETF | 34.78 | 34.87 | 34.53 | 34.59 | 6167700.0 |
| 2002-04-05 10:30:00 | QQQ | ETF | 34.59 | 34.65 | 34.36 | 34.41 | 8217400.0 |
| 2002-04-05 11:00:00 | QQQ | ETF | 34.41 | 34.54 | 34.26 | 34.37 | 4961500.0 |
| 2002-04-05 11:30:00 | QQQ | ETF | 34.36 | 34.49 | 34.28 | 34.43 | 2360400.0 |
| 2002-04-05 12:00:00 | QQQ | ETF | 34.43 | 34.45 | 34.2 | 34.3 | 4114100.0 |
| 2002-04-05 12:30:00 | QQQ | ETF | 34.31 | 34.48 | 34.27 | 34.45 | 3993800.0 |
| 2002-04-05 13:00:00 | QQQ | ETF | 34.45 | 34.49 | 34.32 | 34.38 | 2797100.0 |
| 2002-04-05 13:30:00 | QQQ | ETF | 34.4 | 34.68 | 34.38 | 34.66 | 6283400.0 |
| 2002-04-05 14:00:00 | QQQ | ETF | 34.65 | 34.69 | 34.52 | 34.6 | 2921100.0 |
| 2002-04-05 14:30:00 | QQQ | ETF | 34.58 | 34.67 | 34.38 | 34.41 | 2521300.0 |
| 2002-04-05 15:00:00 | QQQ | ETF | 34.4 | 34.45 | 34.18 | 34.29 | 4347200.0 |
| 2002-04-05 15:30:00 | QQQ | ETF | 34.29 | 34.5 | 34.24 | 34.3 | 5948600.0 |
| 2002-04-05 16:00:00 | QQQ | ETF | 34.3 | 34.8 | 34.2 | 34.4 | 2850200.0 |
| 2002-04-05 16:30:00 | QQQ | ETF | 34.41 | 34.41 | 34.38 | 34.4 | 58100.0 |
| 2002-04-05 17:00:00 | QQQ | ETF | 34.4 | 34.41 | 34.32 | 34.4 | 38300.0 |
| 2002-04-05 17:30:00 | QQQ | ETF | 34.39 | 34.39 | 34.35 | 34.35 | 1600.0 |
| 2002-04-05 18:00:00 | QQQ | ETF | 34.37 | 34.41 | 34.37 | 34.41 | 17100.0 |
| 2002-04-05 09:30:00 | IWM | ETF | 49.8 | 49.91 | 49.725 | 49.76 | 92000.0 |
| 2002-04-05 10:00:00 | IWM | ETF | 49.825 | 49.95 | 49.825 | 49.875 | 265000.0 |
| 2002-04-05 10:30:00 | IWM | ETF | 49.885 | 49.885 | 49.755 | 49.785 | 70200.0 |
| 2002-04-05 11:00:00 | IWM | ETF | 49.79 | 49.845 | 49.725 | 49.74 | 86800.0 |
| 2002-04-05 11:30:00 | IWM | ETF | 49.7 | 49.78 | 49.665 | 49.745 | 8200.0 |
| 2002-04-05 12:00:00 | IWM | ETF | 49.695 | 49.74 | 49.58 | 49.63 | 40200.0 |
| 2002-04-05 12:30:00 | IWM | ETF | 49.63 | 49.66 | 49.58 | 49.65 | 58200.0 |
| 2002-04-05 13:00:00 | IWM | ETF | 49.71 | 49.75 | 49.61 | 49.61 | 22000.0 |
| 2002-04-05 13:30:00 | IWM | ETF | 49.66 | 49.785 | 49.66 | 49.785 | 7000.0 |
| 2002-04-05 14:00:00 | IWM | ETF | 49.87 | 49.87 | 49.72 | 49.75 | 53600.0 |
| 2002-04-05 14:30:00 | IWM | ETF | 49.76 | 49.79 | 49.72 | 49.78 | 5600.0 |
| 2002-04-05 15:00:00 | IWM | ETF | 49.695 | 49.75 | 49.62 | 49.695 | 24200.0 |
| 2002-04-05 15:30:00 | IWM | ETF | 49.675 | 49.72 | 49.525 | 49.525 | 71800.0 |
| 2002-04-05 16:00:00 | IWM | ETF | 49.525 | 49.55 | 49.35 | 49.55 | 6200.0 |
| 2002-04-05 09:30:00 | DIA | ETF | 103.02 | 103.48 | 103.0 | 103.05 | 1643000.0 |
| 2002-04-05 10:00:00 | DIA | ETF | 103.15 | 103.33 | 102.98 | 103.05 | 718000.0 |
| 2002-04-05 10:30:00 | DIA | ETF | 103.1 | 103.2 | 102.89 | 102.98 | 270800.0 |
> showing 50 of 471 rows — these rows as CSV