PREVIEW / etf_30min / 2001-06-11
file: by_date/etf_30min/2001/2001-06-11.parquet size: 14 KB rows: 353
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-06-11 09:30:00 | SPY | ETF | 126.71 | 126.99 | 126.47 | 126.57 | 1607800.0 |
| 2001-06-11 10:00:00 | SPY | ETF | 126.58 | 126.89 | 126.4 | 126.5 | 478400.0 |
| 2001-06-11 10:30:00 | SPY | ETF | 126.49 | 126.57 | 125.96 | 126.0 | 618400.0 |
| 2001-06-11 11:00:00 | SPY | ETF | 126.05 | 126.05 | 125.6 | 125.76 | 430400.0 |
| 2001-06-11 11:30:00 | SPY | ETF | 125.79 | 125.87 | 125.56 | 125.83 | 314500.0 |
| 2001-06-11 12:00:00 | SPY | ETF | 125.8 | 125.91 | 125.63 | 125.78 | 308500.0 |
| 2001-06-11 12:30:00 | SPY | ETF | 125.84 | 125.92 | 125.72 | 125.78 | 173800.0 |
| 2001-06-11 13:00:00 | SPY | ETF | 125.73 | 125.98 | 125.61 | 125.67 | 230600.0 |
| 2001-06-11 13:30:00 | SPY | ETF | 125.72 | 125.72 | 125.42 | 125.55 | 324900.0 |
| 2001-06-11 14:00:00 | SPY | ETF | 125.57 | 125.68 | 125.41 | 125.53 | 505700.0 |
| 2001-06-11 14:30:00 | SPY | ETF | 125.53 | 125.91 | 125.51 | 125.83 | 421300.0 |
| 2001-06-11 15:00:00 | SPY | ETF | 125.8 | 126.13 | 125.68 | 126.06 | 680400.0 |
| 2001-06-11 15:30:00 | SPY | ETF | 126.01 | 126.22 | 125.83 | 125.94 | 483000.0 |
| 2001-06-11 16:00:00 | SPY | ETF | 125.94 | 126.16 | 125.52 | 125.52 | 146600.0 |
| 2001-06-11 16:30:00 | SPY | ETF | 126.15 | 126.17 | 126.15 | 126.17 | 10100.0 |
| 2001-06-11 09:30:00 | QQQ | ETF | 46.9 | 47.0 | 46.4 | 46.55 | 8168100.0 |
| 2001-06-11 10:00:00 | QQQ | ETF | 46.55 | 46.68 | 46.25 | 46.31 | 5143300.0 |
| 2001-06-11 10:30:00 | QQQ | ETF | 46.34 | 46.4 | 45.9 | 45.95 | 4217700.0 |
| 2001-06-11 11:00:00 | QQQ | ETF | 45.95 | 45.98 | 45.73 | 45.83 | 4184500.0 |
| 2001-06-11 11:30:00 | QQQ | ETF | 45.83 | 45.87 | 45.6 | 45.87 | 3835200.0 |
| 2001-06-11 12:00:00 | QQQ | ETF | 45.84 | 45.9 | 45.7 | 45.76 | 1218900.0 |
| 2001-06-11 12:30:00 | QQQ | ETF | 45.76 | 45.98 | 45.75 | 45.83 | 1696600.0 |
| 2001-06-11 13:00:00 | QQQ | ETF | 45.85 | 45.98 | 45.66 | 45.75 | 1611400.0 |
| 2001-06-11 13:30:00 | QQQ | ETF | 45.78 | 45.78 | 45.51 | 45.55 | 2970800.0 |
| 2001-06-11 14:00:00 | QQQ | ETF | 45.55 | 45.73 | 45.49 | 45.64 | 1736100.0 |
| 2001-06-11 14:30:00 | QQQ | ETF | 45.7 | 45.95 | 45.63 | 45.9 | 2740600.0 |
| 2001-06-11 15:00:00 | QQQ | ETF | 45.88 | 46.2 | 45.73 | 46.11 | 4059100.0 |
| 2001-06-11 15:30:00 | QQQ | ETF | 46.1 | 46.25 | 45.99 | 46.04 | 4186000.0 |
| 2001-06-11 16:00:00 | QQQ | ETF | 46.04 | 46.1 | 45.8 | 45.94 | 988900.0 |
| 2001-06-11 16:30:00 | QQQ | ETF | 46.0 | 46.25 | 45.94 | 46.04 | 13500.0 |
| 2001-06-11 17:00:00 | QQQ | ETF | 46.08 | 46.11 | 46.06 | 46.1 | 24300.0 |
| 2001-06-11 17:30:00 | QQQ | ETF | 46.1 | 46.18 | 46.1 | 46.18 | 10100.0 |
| 2001-06-11 18:00:00 | QQQ | ETF | 46.12 | 46.18 | 46.12 | 46.18 | 4300.0 |
| 2001-06-11 09:30:00 | IWM | ETF | 50.95 | 50.95 | 50.75 | 50.75 | 8000.0 |
| 2001-06-11 10:00:00 | IWM | ETF | 50.75 | 50.75 | 50.75 | 50.75 | 400.0 |
| 2001-06-11 10:30:00 | IWM | ETF | 50.55 | 50.675 | 50.545 | 50.545 | 14200.0 |
| 2001-06-11 11:00:00 | IWM | ETF | 50.54 | 50.545 | 50.475 | 50.475 | 101600.0 |
| 2001-06-11 11:30:00 | IWM | ETF | 50.45 | 50.49 | 50.3 | 50.305 | 11800.0 |
| 2001-06-11 12:00:00 | IWM | ETF | 50.4 | 50.4 | 50.35 | 50.4 | 53600.0 |
| 2001-06-11 12:30:00 | IWM | ETF | 50.525 | 50.545 | 50.38 | 50.475 | 78600.0 |
| 2001-06-11 13:00:00 | IWM | ETF | 50.375 | 50.53 | 50.375 | 50.375 | 10800.0 |
| 2001-06-11 13:30:00 | IWM | ETF | 50.475 | 50.475 | 50.25 | 50.255 | 55400.0 |
| 2001-06-11 14:00:00 | IWM | ETF | 50.33 | 50.33 | 50.25 | 50.28 | 16600.0 |
| 2001-06-11 14:30:00 | IWM | ETF | 50.345 | 50.415 | 50.255 | 50.275 | 17400.0 |
| 2001-06-11 15:00:00 | IWM | ETF | 50.285 | 50.595 | 50.275 | 50.55 | 58600.0 |
| 2001-06-11 15:30:00 | IWM | ETF | 50.55 | 50.55 | 50.4 | 50.42 | 63800.0 |
| 2001-06-11 16:00:00 | IWM | ETF | 50.3 | 50.3 | 50.275 | 50.275 | 21000.0 |
| 2001-06-11 09:30:00 | DIA | ETF | 109.55 | 109.85 | 109.37 | 109.58 | 542500.0 |
| 2001-06-11 10:00:00 | DIA | ETF | 109.5 | 109.85 | 109.41 | 109.55 | 203300.0 |
| 2001-06-11 10:30:00 | DIA | ETF | 109.55 | 109.65 | 109.12 | 109.15 | 344300.0 |
> showing 50 of 353 rows — these rows as CSV