PREVIEW / etf_30min / 2001-11-09
file: by_date/etf_30min/2001/2001-11-09.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-09 09:30:00 | SPY | ETF | 112.25 | 112.59 | 111.74 | 111.92 | 3196700.0 |
| 2001-11-09 10:00:00 | SPY | ETF | 111.88 | 112.2 | 111.44 | 112.0 | 1956900.0 |
| 2001-11-09 10:30:00 | SPY | ETF | 112.11 | 112.9 | 112.09 | 112.31 | 3339100.0 |
| 2001-11-09 11:00:00 | SPY | ETF | 112.32 | 112.38 | 111.86 | 112.12 | 1201100.0 |
| 2001-11-09 11:30:00 | SPY | ETF | 112.12 | 112.44 | 112.06 | 112.23 | 438800.0 |
| 2001-11-09 12:00:00 | SPY | ETF | 112.21 | 112.32 | 112.02 | 112.13 | 841000.0 |
| 2001-11-09 12:30:00 | SPY | ETF | 112.09 | 112.48 | 112.05 | 112.43 | 466500.0 |
| 2001-11-09 13:00:00 | SPY | ETF | 112.43 | 112.79 | 112.42 | 112.64 | 772600.0 |
| 2001-11-09 13:30:00 | SPY | ETF | 112.61 | 112.74 | 112.44 | 112.56 | 339300.0 |
| 2001-11-09 14:00:00 | SPY | ETF | 112.52 | 112.64 | 112.18 | 112.19 | 645100.0 |
| 2001-11-09 14:30:00 | SPY | ETF | 112.24 | 112.5 | 112.2 | 112.36 | 307100.0 |
| 2001-11-09 15:00:00 | SPY | ETF | 112.37 | 112.62 | 112.3 | 112.36 | 447200.0 |
| 2001-11-09 15:30:00 | SPY | ETF | 112.35 | 112.59 | 112.23 | 112.44 | 816400.0 |
| 2001-11-09 16:00:00 | SPY | ETF | 112.45 | 112.72 | 112.17 | 112.6 | 1036600.0 |
| 2001-11-09 16:30:00 | SPY | ETF | 112.6 | 112.6 | 112.55 | 112.55 | 1100.0 |
| 2001-11-09 17:00:00 | SPY | ETF | 112.55 | 112.6 | 112.55 | 112.6 | 600.0 |
| 2001-11-09 09:30:00 | QQQ | ETF | 37.59 | 37.95 | 37.34 | 37.53 | 11201600.0 |
| 2001-11-09 10:00:00 | QQQ | ETF | 37.47 | 37.61 | 37.12 | 37.55 | 9194400.0 |
| 2001-11-09 10:30:00 | QQQ | ETF | 37.55 | 37.98 | 37.46 | 37.7 | 9765200.0 |
| 2001-11-09 11:00:00 | QQQ | ETF | 37.78 | 37.78 | 37.4 | 37.52 | 3488200.0 |
| 2001-11-09 11:30:00 | QQQ | ETF | 37.59 | 37.77 | 37.5 | 37.6 | 3498400.0 |
| 2001-11-09 12:00:00 | QQQ | ETF | 37.6 | 37.7 | 37.45 | 37.53 | 2959600.0 |
| 2001-11-09 12:30:00 | QQQ | ETF | 37.55 | 37.89 | 37.5 | 37.86 | 3876100.0 |
| 2001-11-09 13:00:00 | QQQ | ETF | 37.88 | 38.08 | 37.81 | 37.95 | 5536700.0 |
| 2001-11-09 13:30:00 | QQQ | ETF | 37.93 | 38.04 | 37.79 | 37.86 | 2884800.0 |
| 2001-11-09 14:00:00 | QQQ | ETF | 37.86 | 37.98 | 37.56 | 37.6 | 3801100.0 |
| 2001-11-09 14:30:00 | QQQ | ETF | 37.6 | 37.78 | 37.56 | 37.69 | 3558600.0 |
| 2001-11-09 15:00:00 | QQQ | ETF | 37.7 | 37.87 | 37.64 | 37.73 | 3311300.0 |
| 2001-11-09 15:30:00 | QQQ | ETF | 37.73 | 37.82 | 37.57 | 37.69 | 6362700.0 |
| 2001-11-09 16:00:00 | QQQ | ETF | 37.7 | 37.76 | 37.6 | 37.7 | 3462100.0 |
| 2001-11-09 16:30:00 | QQQ | ETF | 37.7 | 37.73 | 37.69 | 37.72 | 13300.0 |
| 2001-11-09 17:00:00 | QQQ | ETF | 37.74 | 37.95 | 37.74 | 37.85 | 14300.0 |
| 2001-11-09 17:30:00 | QQQ | ETF | 37.85 | 37.95 | 37.85 | 37.85 | 7700.0 |
| 2001-11-09 18:00:00 | QQQ | ETF | 37.93 | 38.0 | 37.88 | 37.9 | 9200.0 |
| 2001-11-09 09:30:00 | IWM | ETF | 43.53 | 43.745 | 43.53 | 43.575 | 51200.0 |
| 2001-11-09 10:00:00 | IWM | ETF | 43.55 | 43.59 | 43.435 | 43.435 | 27600.0 |
| 2001-11-09 10:30:00 | IWM | ETF | 43.55 | 43.695 | 43.415 | 43.565 | 9000.0 |
| 2001-11-09 11:00:00 | IWM | ETF | 43.665 | 43.685 | 43.465 | 43.465 | 7400.0 |
| 2001-11-09 11:30:00 | IWM | ETF | 43.45 | 43.69 | 43.45 | 43.69 | 21200.0 |
| 2001-11-09 12:00:00 | IWM | ETF | 43.54 | 43.605 | 43.5 | 43.5 | 4000.0 |
| 2001-11-09 12:30:00 | IWM | ETF | 43.53 | 43.61 | 43.53 | 43.565 | 8600.0 |
| 2001-11-09 13:00:00 | IWM | ETF | 43.62 | 43.7 | 43.575 | 43.7 | 5800.0 |
| 2001-11-09 13:30:00 | IWM | ETF | 43.665 | 43.73 | 43.66 | 43.675 | 7800.0 |
| 2001-11-09 14:00:00 | IWM | ETF | 43.715 | 43.715 | 43.565 | 43.565 | 13200.0 |
| 2001-11-09 14:30:00 | IWM | ETF | 43.59 | 43.64 | 43.535 | 43.535 | 38200.0 |
| 2001-11-09 15:00:00 | IWM | ETF | 43.59 | 43.725 | 43.54 | 43.64 | 29000.0 |
| 2001-11-09 15:30:00 | IWM | ETF | 43.6 | 43.64 | 43.545 | 43.55 | 182000.0 |
| 2001-11-09 16:00:00 | IWM | ETF | 43.64 | 43.7 | 43.64 | 43.7 | 15600.0 |
| 2001-11-09 09:30:00 | DIA | ETF | 95.77 | 96.22 | 95.5 | 95.65 | 567900.0 |
| 2001-11-09 10:00:00 | DIA | ETF | 95.64 | 95.89 | 95.28 | 95.76 | 221200.0 |
> showing 50 of 436 rows — these rows as CSV