PREVIEW / etf_30min / 2001-11-30
file: by_date/etf_30min/2001/2001-11-30.parquet size: 16 KB rows: 436
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-30 09:30:00 | SPY | ETF | 114.4 | 114.65 | 114.05 | 114.28 | 1495200.0 |
| 2001-11-30 10:00:00 | SPY | ETF | 114.1 | 114.68 | 114.02 | 114.58 | 1687600.0 |
| 2001-11-30 10:30:00 | SPY | ETF | 114.55 | 114.82 | 114.34 | 114.39 | 1372000.0 |
| 2001-11-30 11:00:00 | SPY | ETF | 114.4 | 114.61 | 114.28 | 114.61 | 470700.0 |
| 2001-11-30 11:30:00 | SPY | ETF | 114.54 | 114.67 | 114.41 | 114.6 | 463900.0 |
| 2001-11-30 12:00:00 | SPY | ETF | 114.62 | 114.8 | 114.57 | 114.67 | 512000.0 |
| 2001-11-30 12:30:00 | SPY | ETF | 114.68 | 114.72 | 114.51 | 114.6 | 410700.0 |
| 2001-11-30 13:00:00 | SPY | ETF | 114.6 | 114.67 | 114.31 | 114.4 | 512300.0 |
| 2001-11-30 13:30:00 | SPY | ETF | 114.38 | 114.61 | 114.35 | 114.39 | 327200.0 |
| 2001-11-30 14:00:00 | SPY | ETF | 114.39 | 114.57 | 114.28 | 114.48 | 1219100.0 |
| 2001-11-30 14:30:00 | SPY | ETF | 114.44 | 114.9 | 114.42 | 114.76 | 1038900.0 |
| 2001-11-30 15:00:00 | SPY | ETF | 114.77 | 114.91 | 114.57 | 114.65 | 451000.0 |
| 2001-11-30 15:30:00 | SPY | ETF | 114.7 | 114.75 | 114.24 | 114.3 | 2424800.0 |
| 2001-11-30 16:00:00 | SPY | ETF | 114.3 | 114.47 | 114.03 | 114.05 | 1084100.0 |
| 2001-11-30 16:30:00 | SPY | ETF | 114.03 | 114.03 | 114.02 | 114.02 | 8200.0 |
| 2001-11-30 09:30:00 | QQQ | ETF | 39.73 | 39.86 | 39.4 | 39.45 | 9760200.0 |
| 2001-11-30 10:00:00 | QQQ | ETF | 39.47 | 39.85 | 39.36 | 39.79 | 8247400.0 |
| 2001-11-30 10:30:00 | QQQ | ETF | 39.79 | 40.04 | 39.67 | 39.75 | 8355900.0 |
| 2001-11-30 11:00:00 | QQQ | ETF | 39.76 | 39.85 | 39.61 | 39.82 | 4304500.0 |
| 2001-11-30 11:30:00 | QQQ | ETF | 39.81 | 39.91 | 39.71 | 39.84 | 1849500.0 |
| 2001-11-30 12:00:00 | QQQ | ETF | 39.82 | 40.0 | 39.81 | 39.86 | 2359600.0 |
| 2001-11-30 12:30:00 | QQQ | ETF | 39.87 | 39.9 | 39.63 | 39.74 | 3987100.0 |
| 2001-11-30 13:00:00 | QQQ | ETF | 39.74 | 39.78 | 39.46 | 39.52 | 3779100.0 |
| 2001-11-30 13:30:00 | QQQ | ETF | 39.54 | 39.69 | 39.47 | 39.49 | 3459600.0 |
| 2001-11-30 14:00:00 | QQQ | ETF | 39.49 | 39.65 | 39.44 | 39.63 | 2958700.0 |
| 2001-11-30 14:30:00 | QQQ | ETF | 39.63 | 39.95 | 39.6 | 39.86 | 4479100.0 |
| 2001-11-30 15:00:00 | QQQ | ETF | 39.86 | 39.96 | 39.73 | 39.86 | 3360500.0 |
| 2001-11-30 15:30:00 | QQQ | ETF | 39.88 | 39.94 | 39.41 | 39.73 | 6785300.0 |
| 2001-11-30 16:00:00 | QQQ | ETF | 39.73 | 39.83 | 39.51 | 39.69 | 1722700.0 |
| 2001-11-30 16:30:00 | QQQ | ETF | 39.69 | 39.7 | 39.63 | 39.66 | 40300.0 |
| 2001-11-30 17:00:00 | QQQ | ETF | 39.75 | 39.75 | 39.66 | 39.68 | 303100.0 |
| 2001-11-30 17:30:00 | QQQ | ETF | 39.68 | 39.7 | 39.65 | 39.7 | 7500.0 |
| 2001-11-30 18:00:00 | QQQ | ETF | 39.7 | 39.75 | 39.65 | 39.65 | 3900.0 |
| 2001-11-30 09:30:00 | IWM | ETF | 46.2 | 46.2 | 45.975 | 45.975 | 58400.0 |
| 2001-11-30 10:00:00 | IWM | ETF | 45.955 | 46.1 | 45.885 | 46.03 | 80600.0 |
| 2001-11-30 10:30:00 | IWM | ETF | 46.025 | 46.285 | 46.025 | 46.235 | 46800.0 |
| 2001-11-30 11:00:00 | IWM | ETF | 46.15 | 46.205 | 46.08 | 46.085 | 11000.0 |
| 2001-11-30 11:30:00 | IWM | ETF | 46.205 | 46.205 | 46.15 | 46.165 | 4200.0 |
| 2001-11-30 12:00:00 | IWM | ETF | 46.115 | 46.17 | 46.08 | 46.17 | 12000.0 |
| 2001-11-30 12:30:00 | IWM | ETF | 46.185 | 46.19 | 46.025 | 46.11 | 34000.0 |
| 2001-11-30 13:00:00 | IWM | ETF | 46.05 | 46.095 | 45.935 | 45.935 | 7400.0 |
| 2001-11-30 13:30:00 | IWM | ETF | 46.03 | 46.055 | 46.0 | 46.03 | 4200.0 |
| 2001-11-30 14:00:00 | IWM | ETF | 45.955 | 46.005 | 45.955 | 45.995 | 9800.0 |
| 2001-11-30 14:30:00 | IWM | ETF | 46.015 | 46.165 | 45.99 | 46.165 | 13200.0 |
| 2001-11-30 15:00:00 | IWM | ETF | 46.1 | 46.165 | 46.025 | 46.15 | 114600.0 |
| 2001-11-30 15:30:00 | IWM | ETF | 46.06 | 46.17 | 45.85 | 45.85 | 239800.0 |
| 2001-11-30 16:00:00 | IWM | ETF | 45.7 | 45.8 | 45.7 | 45.8 | 103000.0 |
| 2001-11-30 09:30:00 | DIA | ETF | 98.42 | 98.76 | 98.32 | 98.35 | 435500.0 |
| 2001-11-30 10:00:00 | DIA | ETF | 98.1 | 98.79 | 98.1 | 98.7 | 409500.0 |
| 2001-11-30 10:30:00 | DIA | ETF | 98.69 | 98.94 | 98.52 | 98.52 | 202400.0 |
> showing 50 of 436 rows — these rows as CSV