PREVIEW / etf_30min / 2001-11-02
file: by_date/etf_30min/2001/2001-11-02.parquet size: 16 KB rows: 409
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-02 09:30:00 | SPY | ETF | 108.44 | 108.65 | 107.99 | 108.32 | 1981800.0 |
| 2001-11-02 10:00:00 | SPY | ETF | 108.2 | 108.66 | 107.87 | 108.52 | 2926500.0 |
| 2001-11-02 10:30:00 | SPY | ETF | 108.58 | 108.61 | 108.05 | 108.32 | 1194100.0 |
| 2001-11-02 11:00:00 | SPY | ETF | 108.28 | 108.88 | 108.07 | 108.85 | 1100700.0 |
| 2001-11-02 11:30:00 | SPY | ETF | 108.88 | 108.95 | 108.62 | 108.85 | 1454900.0 |
| 2001-11-02 12:00:00 | SPY | ETF | 108.85 | 109.24 | 108.81 | 109.2 | 1522500.0 |
| 2001-11-02 12:30:00 | SPY | ETF | 109.26 | 109.35 | 109.03 | 109.27 | 824500.0 |
| 2001-11-02 13:00:00 | SPY | ETF | 109.3 | 109.38 | 109.04 | 109.28 | 411800.0 |
| 2001-11-02 13:30:00 | SPY | ETF | 109.26 | 109.32 | 108.82 | 108.86 | 919400.0 |
| 2001-11-02 14:00:00 | SPY | ETF | 108.89 | 109.29 | 108.76 | 109.14 | 558100.0 |
| 2001-11-02 14:30:00 | SPY | ETF | 109.12 | 109.26 | 108.76 | 109.1 | 709200.0 |
| 2001-11-02 15:00:00 | SPY | ETF | 109.1 | 109.27 | 108.9 | 109.11 | 535800.0 |
| 2001-11-02 15:30:00 | SPY | ETF | 109.14 | 109.37 | 109.02 | 109.06 | 1470900.0 |
| 2001-11-02 16:00:00 | SPY | ETF | 109.07 | 109.25 | 108.92 | 109.25 | 1659200.0 |
| 2001-11-02 17:00:00 | SPY | ETF | 109.2 | 109.25 | 109.2 | 109.25 | 2000.0 |
| 2001-11-02 09:30:00 | QQQ | ETF | 35.27 | 35.75 | 35.1 | 35.5 | 10707500.0 |
| 2001-11-02 10:00:00 | QQQ | ETF | 35.5 | 35.57 | 35.02 | 35.37 | 9558000.0 |
| 2001-11-02 10:30:00 | QQQ | ETF | 35.35 | 35.45 | 34.89 | 35.06 | 4995800.0 |
| 2001-11-02 11:00:00 | QQQ | ETF | 35.05 | 35.48 | 34.92 | 35.43 | 4289500.0 |
| 2001-11-02 11:30:00 | QQQ | ETF | 35.45 | 35.61 | 35.3 | 35.59 | 6851600.0 |
| 2001-11-02 12:00:00 | QQQ | ETF | 35.6 | 35.84 | 35.5 | 35.79 | 3578000.0 |
| 2001-11-02 12:30:00 | QQQ | ETF | 35.82 | 35.85 | 35.54 | 35.71 | 2853200.0 |
| 2001-11-02 13:00:00 | QQQ | ETF | 35.73 | 35.8 | 35.48 | 35.74 | 3303500.0 |
| 2001-11-02 13:30:00 | QQQ | ETF | 35.73 | 35.8 | 35.38 | 35.41 | 2789100.0 |
| 2001-11-02 14:00:00 | QQQ | ETF | 35.4 | 35.65 | 35.3 | 35.53 | 3220600.0 |
| 2001-11-02 14:30:00 | QQQ | ETF | 35.52 | 35.62 | 35.3 | 35.51 | 3278100.0 |
| 2001-11-02 15:00:00 | QQQ | ETF | 35.46 | 35.62 | 35.37 | 35.51 | 2574300.0 |
| 2001-11-02 15:30:00 | QQQ | ETF | 35.5 | 35.67 | 35.3 | 35.5 | 4087100.0 |
| 2001-11-02 16:00:00 | QQQ | ETF | 35.49 | 35.6 | 35.35 | 35.6 | 1880400.0 |
| 2001-11-02 16:30:00 | QQQ | ETF | 35.52 | 35.61 | 35.52 | 35.6 | 59700.0 |
| 2001-11-02 17:00:00 | QQQ | ETF | 35.59 | 35.62 | 35.59 | 35.6 | 5600.0 |
| 2001-11-02 17:30:00 | QQQ | ETF | 35.62 | 35.62 | 35.5 | 35.6 | 13500.0 |
| 2001-11-02 18:00:00 | QQQ | ETF | 35.6 | 35.6 | 35.57 | 35.59 | 4600.0 |
| 2001-11-02 09:30:00 | IWM | ETF | 43.225 | 43.3 | 43.1 | 43.135 | 46200.0 |
| 2001-11-02 10:00:00 | IWM | ETF | 43.055 | 43.095 | 42.98 | 43.09 | 11400.0 |
| 2001-11-02 10:30:00 | IWM | ETF | 43.095 | 43.105 | 43.05 | 43.07 | 60600.0 |
| 2001-11-02 11:00:00 | IWM | ETF | 43.095 | 43.19 | 43.095 | 43.17 | 21000.0 |
| 2001-11-02 11:30:00 | IWM | ETF | 43.22 | 43.245 | 43.22 | 43.245 | 2200.0 |
| 2001-11-02 12:00:00 | IWM | ETF | 43.275 | 43.315 | 43.225 | 43.27 | 4200.0 |
| 2001-11-02 12:30:00 | IWM | ETF | 43.325 | 43.325 | 43.32 | 43.32 | 400.0 |
| 2001-11-02 13:00:00 | IWM | ETF | 43.35 | 43.35 | 43.28 | 43.335 | 9800.0 |
| 2001-11-02 13:30:00 | IWM | ETF | 43.275 | 43.275 | 43.225 | 43.225 | 3800.0 |
| 2001-11-02 14:00:00 | IWM | ETF | 43.195 | 43.265 | 43.195 | 43.265 | 19600.0 |
| 2001-11-02 14:30:00 | IWM | ETF | 43.225 | 43.225 | 43.155 | 43.165 | 9800.0 |
| 2001-11-02 15:00:00 | IWM | ETF | 43.165 | 43.22 | 43.15 | 43.175 | 16600.0 |
| 2001-11-02 15:30:00 | IWM | ETF | 43.18 | 43.305 | 43.0 | 43.0 | 98400.0 |
| 2001-11-02 16:00:00 | IWM | ETF | 43.24 | 43.24 | 42.925 | 43.0 | 64600.0 |
| 2001-11-02 09:30:00 | DIA | ETF | 92.5 | 92.74 | 92.12 | 92.38 | 587900.0 |
| 2001-11-02 10:00:00 | DIA | ETF | 92.36 | 92.91 | 92.15 | 92.88 | 238000.0 |
| 2001-11-02 10:30:00 | DIA | ETF | 92.89 | 92.9 | 92.48 | 92.72 | 73400.0 |
> showing 50 of 409 rows — these rows as CSV