PREVIEW / etf_30min / 2002-05-31
file: by_date/etf_30min/2002/2002-05-31.parquet size: 18 KB rows: 493
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-05-31 09:30:00 | SPY | ETF | 107.4 | 107.81 | 107.21 | 107.68 | 2149500.0 |
| 2002-05-31 10:00:00 | SPY | ETF | 107.6 | 108.16 | 107.6 | 107.97 | 3665000.0 |
| 2002-05-31 10:30:00 | SPY | ETF | 107.94 | 107.98 | 107.7 | 107.93 | 806600.0 |
| 2002-05-31 11:00:00 | SPY | ETF | 107.9 | 108.21 | 107.9 | 108.1 | 746000.0 |
| 2002-05-31 11:30:00 | SPY | ETF | 108.08 | 108.3 | 107.98 | 108.01 | 880000.0 |
| 2002-05-31 12:00:00 | SPY | ETF | 108.01 | 108.25 | 107.91 | 108.2 | 667500.0 |
| 2002-05-31 12:30:00 | SPY | ETF | 108.14 | 108.47 | 108.14 | 108.45 | 1283200.0 |
| 2002-05-31 13:00:00 | SPY | ETF | 108.48 | 108.56 | 108.29 | 108.35 | 1049200.0 |
| 2002-05-31 13:30:00 | SPY | ETF | 108.38 | 108.4 | 108.0 | 108.1 | 714300.0 |
| 2002-05-31 14:00:00 | SPY | ETF | 108.1 | 108.17 | 107.84 | 107.85 | 1039600.0 |
| 2002-05-31 14:30:00 | SPY | ETF | 107.85 | 107.89 | 107.27 | 107.37 | 1017300.0 |
| 2002-05-31 15:00:00 | SPY | ETF | 107.36 | 107.69 | 107.3 | 107.48 | 872800.0 |
| 2002-05-31 15:30:00 | SPY | ETF | 107.45 | 107.61 | 107.08 | 107.22 | 1602000.0 |
| 2002-05-31 16:00:00 | SPY | ETF | 107.25 | 107.37 | 106.84 | 106.93 | 2740300.0 |
| 2002-05-31 16:30:00 | SPY | ETF | 106.9 | 107.22 | 106.9 | 106.9 | 3600.0 |
| 2002-05-31 17:00:00 | SPY | ETF | 106.95 | 106.95 | 106.95 | 106.95 | 500.0 |
| 2002-05-31 09:30:00 | QQQ | ETF | 30.76 | 30.84 | 30.37 | 30.63 | 10547100.0 |
| 2002-05-31 10:00:00 | QQQ | ETF | 30.63 | 30.98 | 30.56 | 30.88 | 12506500.0 |
| 2002-05-31 10:30:00 | QQQ | ETF | 30.88 | 30.9 | 30.7 | 30.82 | 4051100.0 |
| 2002-05-31 11:00:00 | QQQ | ETF | 30.84 | 30.98 | 30.81 | 30.91 | 4029300.0 |
| 2002-05-31 11:30:00 | QQQ | ETF | 30.91 | 31.04 | 30.81 | 30.84 | 4057500.0 |
| 2002-05-31 12:00:00 | QQQ | ETF | 30.85 | 30.9 | 30.76 | 30.86 | 2467800.0 |
| 2002-05-31 12:30:00 | QQQ | ETF | 30.86 | 30.99 | 30.83 | 30.93 | 2507000.0 |
| 2002-05-31 13:00:00 | QQQ | ETF | 30.93 | 30.98 | 30.78 | 30.8 | 1884300.0 |
| 2002-05-31 13:30:00 | QQQ | ETF | 30.81 | 30.85 | 30.6 | 30.65 | 3209600.0 |
| 2002-05-31 14:00:00 | QQQ | ETF | 30.65 | 30.74 | 30.5 | 30.53 | 2999600.0 |
| 2002-05-31 14:30:00 | QQQ | ETF | 30.51 | 30.56 | 30.12 | 30.2 | 9193900.0 |
| 2002-05-31 15:00:00 | QQQ | ETF | 30.17 | 30.35 | 30.14 | 30.23 | 7388800.0 |
| 2002-05-31 15:30:00 | QQQ | ETF | 30.23 | 30.33 | 30.03 | 30.08 | 9288600.0 |
| 2002-05-31 16:00:00 | QQQ | ETF | 30.08 | 30.14 | 30.0 | 30.02 | 4446100.0 |
| 2002-05-31 16:30:00 | QQQ | ETF | 30.02 | 30.04 | 29.99 | 29.99 | 158000.0 |
| 2002-05-31 17:00:00 | QQQ | ETF | 30.02 | 30.02 | 29.98 | 30.02 | 20100.0 |
| 2002-05-31 17:30:00 | QQQ | ETF | 30.03 | 30.07 | 30.0 | 30.04 | 16200.0 |
| 2002-05-31 18:00:00 | QQQ | ETF | 30.05 | 30.05 | 30.01 | 30.01 | 1900.0 |
| 2002-05-31 09:30:00 | IWM | ETF | 48.775 | 48.8 | 48.625 | 48.69 | 372200.0 |
| 2002-05-31 10:00:00 | IWM | ETF | 48.745 | 49.025 | 48.745 | 48.92 | 245400.0 |
| 2002-05-31 10:30:00 | IWM | ETF | 48.93 | 48.945 | 48.8 | 48.8 | 13200.0 |
| 2002-05-31 11:00:00 | IWM | ETF | 48.97 | 49.075 | 48.955 | 49.04 | 92000.0 |
| 2002-05-31 11:30:00 | IWM | ETF | 49.075 | 49.115 | 48.935 | 48.95 | 83000.0 |
| 2002-05-31 12:00:00 | IWM | ETF | 48.945 | 49.075 | 48.925 | 49.055 | 20800.0 |
| 2002-05-31 12:30:00 | IWM | ETF | 49.055 | 49.1 | 49.05 | 49.1 | 45600.0 |
| 2002-05-31 13:00:00 | IWM | ETF | 49.1 | 49.12 | 49.035 | 49.09 | 137200.0 |
| 2002-05-31 13:30:00 | IWM | ETF | 49.015 | 49.07 | 48.92 | 48.925 | 55200.0 |
| 2002-05-31 14:00:00 | IWM | ETF | 48.995 | 48.995 | 48.9 | 48.935 | 13200.0 |
| 2002-05-31 14:30:00 | IWM | ETF | 48.935 | 48.935 | 48.755 | 48.755 | 168000.0 |
| 2002-05-31 15:00:00 | IWM | ETF | 48.765 | 48.83 | 48.75 | 48.78 | 136200.0 |
| 2002-05-31 15:30:00 | IWM | ETF | 48.785 | 48.815 | 48.48 | 48.48 | 1633000.0 |
| 2002-05-31 16:00:00 | IWM | ETF | 48.425 | 48.585 | 48.25 | 48.25 | 887200.0 |
| 2002-05-31 16:30:00 | IWM | ETF | 48.58 | 48.58 | 48.58 | 48.58 | 2224000.0 |
| 2002-05-31 17:00:00 | IWM | ETF | 48.085 | 48.085 | 48.085 | 48.085 | 506800.0 |
> showing 50 of 493 rows — these rows as CSV