PREVIEW / etf_30min / 2001-11-29
file: by_date/etf_30min/2001/2001-11-29.parquet size: 17 KB rows: 441
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-29 09:30:00 | SPY | ETF | 113.66 | 113.75 | 113.05 | 113.28 | 1777800.0 |
| 2001-11-29 10:00:00 | SPY | ETF | 113.31 | 113.9 | 113.0 | 113.75 | 2346900.0 |
| 2001-11-29 10:30:00 | SPY | ETF | 113.76 | 114.12 | 113.66 | 113.84 | 1153700.0 |
| 2001-11-29 11:00:00 | SPY | ETF | 113.77 | 113.92 | 113.53 | 113.78 | 904300.0 |
| 2001-11-29 11:30:00 | SPY | ETF | 113.76 | 114.08 | 113.63 | 113.98 | 917900.0 |
| 2001-11-29 12:00:00 | SPY | ETF | 113.98 | 114.12 | 113.88 | 113.92 | 328200.0 |
| 2001-11-29 12:30:00 | SPY | ETF | 113.92 | 113.96 | 113.6 | 113.79 | 509200.0 |
| 2001-11-29 13:00:00 | SPY | ETF | 113.79 | 113.81 | 113.32 | 113.4 | 674900.0 |
| 2001-11-29 13:30:00 | SPY | ETF | 113.32 | 113.76 | 113.31 | 113.74 | 670900.0 |
| 2001-11-29 14:00:00 | SPY | ETF | 113.75 | 114.0 | 113.7 | 113.98 | 839900.0 |
| 2001-11-29 14:30:00 | SPY | ETF | 113.97 | 114.07 | 113.73 | 113.79 | 647400.0 |
| 2001-11-29 15:00:00 | SPY | ETF | 113.75 | 114.09 | 113.61 | 114.08 | 1336200.0 |
| 2001-11-29 15:30:00 | SPY | ETF | 114.05 | 114.56 | 114.01 | 114.48 | 2651500.0 |
| 2001-11-29 16:00:00 | SPY | ETF | 114.45 | 114.97 | 114.41 | 114.9 | 1030900.0 |
| 2001-11-29 16:30:00 | SPY | ETF | 114.87 | 114.97 | 114.78 | 114.87 | 112900.0 |
| 2001-11-29 17:00:00 | SPY | ETF | 113.35 | 114.83 | 113.35 | 114.81 | 901700.0 |
| 2001-11-29 17:30:00 | SPY | ETF | 114.65 | 114.7 | 114.21 | 114.51 | 2600.0 |
| 2001-11-29 18:00:00 | SPY | ETF | 115.21 | 115.21 | 114.72 | 115.18 | 2800.0 |
| 2001-11-29 09:30:00 | QQQ | ETF | 39.03 | 39.24 | 38.87 | 38.9 | 9216000.0 |
| 2001-11-29 10:00:00 | QQQ | ETF | 38.94 | 39.4 | 38.79 | 39.24 | 9212300.0 |
| 2001-11-29 10:30:00 | QQQ | ETF | 39.27 | 39.48 | 39.11 | 39.32 | 4985700.0 |
| 2001-11-29 11:00:00 | QQQ | ETF | 39.31 | 39.45 | 39.1 | 39.25 | 3492500.0 |
| 2001-11-29 11:30:00 | QQQ | ETF | 39.26 | 39.6 | 39.2 | 39.54 | 4317400.0 |
| 2001-11-29 12:00:00 | QQQ | ETF | 39.55 | 39.66 | 39.42 | 39.55 | 3423800.0 |
| 2001-11-29 12:30:00 | QQQ | ETF | 39.54 | 39.57 | 39.22 | 39.39 | 4466000.0 |
| 2001-11-29 13:00:00 | QQQ | ETF | 39.37 | 39.41 | 38.95 | 39.0 | 5952100.0 |
| 2001-11-29 13:30:00 | QQQ | ETF | 39.0 | 39.41 | 38.96 | 39.41 | 4084800.0 |
| 2001-11-29 14:00:00 | QQQ | ETF | 39.41 | 39.65 | 39.32 | 39.65 | 5235100.0 |
| 2001-11-29 14:30:00 | QQQ | ETF | 39.6 | 39.75 | 39.4 | 39.46 | 7663700.0 |
| 2001-11-29 15:00:00 | QQQ | ETF | 39.46 | 39.62 | 39.35 | 39.58 | 4223100.0 |
| 2001-11-29 15:30:00 | QQQ | ETF | 39.58 | 39.86 | 39.57 | 39.84 | 11464100.0 |
| 2001-11-29 16:00:00 | QQQ | ETF | 39.8 | 40.0 | 39.74 | 40.0 | 3197500.0 |
| 2001-11-29 16:30:00 | QQQ | ETF | 40.0 | 40.02 | 39.8 | 39.83 | 854600.0 |
| 2001-11-29 17:00:00 | QQQ | ETF | 39.82 | 39.85 | 39.73 | 39.77 | 163600.0 |
| 2001-11-29 17:30:00 | QQQ | ETF | 39.75 | 39.82 | 39.65 | 39.8 | 42200.0 |
| 2001-11-29 18:00:00 | QQQ | ETF | 39.78 | 39.81 | 39.75 | 39.78 | 99000.0 |
| 2001-11-29 09:30:00 | IWM | ETF | 45.175 | 45.35 | 45.155 | 45.25 | 49200.0 |
| 2001-11-29 10:00:00 | IWM | ETF | 45.18 | 45.45 | 45.1 | 45.265 | 45800.0 |
| 2001-11-29 10:30:00 | IWM | ETF | 45.31 | 45.44 | 45.31 | 45.44 | 6400.0 |
| 2001-11-29 11:00:00 | IWM | ETF | 45.37 | 45.43 | 45.37 | 45.375 | 5200.0 |
| 2001-11-29 11:30:00 | IWM | ETF | 45.36 | 45.45 | 45.335 | 45.445 | 41400.0 |
| 2001-11-29 12:00:00 | IWM | ETF | 45.455 | 45.575 | 45.39 | 45.45 | 26800.0 |
| 2001-11-29 12:30:00 | IWM | ETF | 45.41 | 45.41 | 45.35 | 45.375 | 8800.0 |
| 2001-11-29 13:00:00 | IWM | ETF | 45.375 | 45.375 | 45.34 | 45.345 | 40000.0 |
| 2001-11-29 13:30:00 | IWM | ETF | 45.315 | 45.52 | 45.315 | 45.455 | 53000.0 |
| 2001-11-29 14:00:00 | IWM | ETF | 45.495 | 45.65 | 45.495 | 45.565 | 53000.0 |
| 2001-11-29 14:30:00 | IWM | ETF | 45.55 | 45.725 | 45.55 | 45.65 | 60600.0 |
| 2001-11-29 15:00:00 | IWM | ETF | 45.64 | 45.745 | 45.575 | 45.74 | 63200.0 |
| 2001-11-29 15:30:00 | IWM | ETF | 45.835 | 46.15 | 45.74 | 46.15 | 40600.0 |
| 2001-11-29 16:00:00 | IWM | ETF | 46.07 | 46.35 | 46.07 | 46.35 | 10600.0 |
> showing 50 of 441 rows — these rows as CSV