PREVIEW / etf_30min / 2002-02-04
file: by_date/etf_30min/2002/2002-02-04.parquet size: 18 KB rows: 470
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-02-04 09:30:00 | SPY | ETF | 112.23 | 112.23 | 111.48 | 111.75 | 3429300.0 |
| 2002-02-04 10:00:00 | SPY | ETF | 111.71 | 111.83 | 111.04 | 111.23 | 2189400.0 |
| 2002-02-04 10:30:00 | SPY | ETF | 111.24 | 111.4 | 111.02 | 111.12 | 1089100.0 |
| 2002-02-04 11:00:00 | SPY | ETF | 111.18 | 111.26 | 110.96 | 111.22 | 1100800.0 |
| 2002-02-04 11:30:00 | SPY | ETF | 111.2 | 111.24 | 110.62 | 110.76 | 846700.0 |
| 2002-02-04 12:00:00 | SPY | ETF | 110.76 | 110.83 | 110.28 | 110.34 | 1950500.0 |
| 2002-02-04 12:30:00 | SPY | ETF | 110.33 | 110.63 | 110.27 | 110.37 | 1338500.0 |
| 2002-02-04 13:00:00 | SPY | ETF | 110.42 | 110.42 | 110.06 | 110.22 | 1476500.0 |
| 2002-02-04 13:30:00 | SPY | ETF | 110.22 | 110.56 | 110.12 | 110.53 | 2333500.0 |
| 2002-02-04 14:00:00 | SPY | ETF | 110.52 | 110.66 | 110.35 | 110.41 | 2004100.0 |
| 2002-02-04 14:30:00 | SPY | ETF | 110.39 | 110.54 | 110.18 | 110.3 | 497600.0 |
| 2002-02-04 15:00:00 | SPY | ETF | 110.32 | 110.42 | 109.77 | 109.9 | 1502700.0 |
| 2002-02-04 15:30:00 | SPY | ETF | 109.89 | 109.91 | 109.44 | 109.69 | 3418200.0 |
| 2002-02-04 16:00:00 | SPY | ETF | 109.7 | 109.87 | 109.56 | 109.85 | 1012300.0 |
| 2002-02-04 16:30:00 | SPY | ETF | 109.51 | 109.8 | 109.5 | 109.8 | 5100.0 |
| 2002-02-04 17:00:00 | SPY | ETF | 109.85 | 109.9 | 109.85 | 109.86 | 2300.0 |
| 2002-02-04 17:30:00 | SPY | ETF | 109.96 | 109.99 | 109.96 | 109.99 | 600.0 |
| 2002-02-04 18:00:00 | SPY | ETF | 109.98 | 110.0 | 109.95 | 110.0 | 3600.0 |
| 2002-02-04 09:30:00 | QQQ | ETF | 37.96 | 38.07 | 37.61 | 37.81 | 7783800.0 |
| 2002-02-04 10:00:00 | QQQ | ETF | 37.81 | 37.88 | 37.38 | 37.48 | 10920000.0 |
| 2002-02-04 10:30:00 | QQQ | ETF | 37.45 | 37.59 | 37.22 | 37.27 | 5415200.0 |
| 2002-02-04 11:00:00 | QQQ | ETF | 37.3 | 37.39 | 37.13 | 37.33 | 4376000.0 |
| 2002-02-04 11:30:00 | QQQ | ETF | 37.35 | 37.36 | 36.96 | 37.05 | 5173900.0 |
| 2002-02-04 12:00:00 | QQQ | ETF | 37.02 | 37.21 | 36.97 | 37.07 | 6825000.0 |
| 2002-02-04 12:30:00 | QQQ | ETF | 37.06 | 37.3 | 37.06 | 37.16 | 6351400.0 |
| 2002-02-04 13:00:00 | QQQ | ETF | 37.16 | 37.17 | 36.91 | 37.05 | 4460400.0 |
| 2002-02-04 13:30:00 | QQQ | ETF | 37.04 | 37.2 | 36.96 | 37.16 | 2473200.0 |
| 2002-02-04 14:00:00 | QQQ | ETF | 37.12 | 37.26 | 37.01 | 37.05 | 4104800.0 |
| 2002-02-04 14:30:00 | QQQ | ETF | 37.05 | 37.15 | 36.94 | 36.97 | 3164700.0 |
| 2002-02-04 15:00:00 | QQQ | ETF | 37.0 | 37.05 | 36.69 | 36.81 | 8639400.0 |
| 2002-02-04 15:30:00 | QQQ | ETF | 36.81 | 36.85 | 36.61 | 36.79 | 11236900.0 |
| 2002-02-04 16:00:00 | QQQ | ETF | 36.78 | 37.0 | 36.75 | 36.89 | 1608200.0 |
| 2002-02-04 16:30:00 | QQQ | ETF | 36.91 | 36.95 | 36.88 | 36.91 | 50600.0 |
| 2002-02-04 17:00:00 | QQQ | ETF | 36.9 | 36.93 | 36.86 | 36.89 | 21800.0 |
| 2002-02-04 17:30:00 | QQQ | ETF | 36.89 | 36.94 | 36.88 | 36.92 | 6500.0 |
| 2002-02-04 18:00:00 | QQQ | ETF | 36.89 | 36.96 | 36.88 | 36.9 | 10200.0 |
| 2002-02-04 09:30:00 | IWM | ETF | 47.625 | 47.705 | 47.43 | 47.435 | 217200.0 |
| 2002-02-04 10:00:00 | IWM | ETF | 47.48 | 47.505 | 47.26 | 47.265 | 17000.0 |
| 2002-02-04 10:30:00 | IWM | ETF | 47.355 | 47.365 | 47.24 | 47.255 | 20400.0 |
| 2002-02-04 11:00:00 | IWM | ETF | 47.325 | 47.335 | 47.255 | 47.335 | 7600.0 |
| 2002-02-04 11:30:00 | IWM | ETF | 47.27 | 47.345 | 47.14 | 47.14 | 17400.0 |
| 2002-02-04 12:00:00 | IWM | ETF | 47.14 | 47.175 | 47.0 | 47.0 | 206400.0 |
| 2002-02-04 12:30:00 | IWM | ETF | 46.955 | 47.045 | 46.955 | 47.0 | 203800.0 |
| 2002-02-04 13:00:00 | IWM | ETF | 47.025 | 47.025 | 46.9 | 46.945 | 131800.0 |
| 2002-02-04 13:30:00 | IWM | ETF | 46.95 | 46.975 | 46.85 | 46.975 | 445200.0 |
| 2002-02-04 14:00:00 | IWM | ETF | 46.925 | 47.09 | 46.925 | 47.065 | 342000.0 |
| 2002-02-04 14:30:00 | IWM | ETF | 46.935 | 47.015 | 46.85 | 46.85 | 426000.0 |
| 2002-02-04 15:00:00 | IWM | ETF | 46.85 | 46.85 | 46.68 | 46.7 | 261400.0 |
| 2002-02-04 15:30:00 | IWM | ETF | 46.75 | 46.75 | 46.555 | 46.625 | 425800.0 |
| 2002-02-04 16:00:00 | IWM | ETF | 46.645 | 46.7 | 46.645 | 46.7 | 65200.0 |
> showing 50 of 470 rows — these rows as CSV