PREVIEW / etf_30min / 2001-10-29
file: by_date/etf_30min/2001/2001-10-29.parquet size: 17 KB rows: 425
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-10-29 09:30:00 | SPY | ETF | 110.16 | 110.55 | 109.67 | 109.89 | 2840000.0 |
| 2001-10-29 10:00:00 | SPY | ETF | 109.89 | 109.89 | 109.17 | 109.45 | 2375800.0 |
| 2001-10-29 10:30:00 | SPY | ETF | 109.54 | 109.9 | 109.28 | 109.84 | 1223900.0 |
| 2001-10-29 11:00:00 | SPY | ETF | 109.8 | 109.85 | 109.05 | 109.3 | 2250100.0 |
| 2001-10-29 11:30:00 | SPY | ETF | 109.31 | 109.53 | 108.86 | 109.08 | 925700.0 |
| 2001-10-29 12:00:00 | SPY | ETF | 109.08 | 109.28 | 108.87 | 109.2 | 331300.0 |
| 2001-10-29 12:30:00 | SPY | ETF | 109.25 | 109.25 | 108.88 | 109.14 | 438600.0 |
| 2001-10-29 13:00:00 | SPY | ETF | 109.1 | 109.16 | 108.6 | 108.66 | 867500.0 |
| 2001-10-29 13:30:00 | SPY | ETF | 108.65 | 109.05 | 108.62 | 108.77 | 695700.0 |
| 2001-10-29 14:00:00 | SPY | ETF | 108.77 | 108.9 | 108.55 | 108.78 | 942600.0 |
| 2001-10-29 14:30:00 | SPY | ETF | 108.74 | 108.99 | 108.62 | 108.92 | 634900.0 |
| 2001-10-29 15:00:00 | SPY | ETF | 108.9 | 108.97 | 108.4 | 108.58 | 1433600.0 |
| 2001-10-29 15:30:00 | SPY | ETF | 108.55 | 108.63 | 108.06 | 108.23 | 2097000.0 |
| 2001-10-29 16:00:00 | SPY | ETF | 108.27 | 108.29 | 107.0 | 107.5 | 1260500.0 |
| 2001-10-29 16:30:00 | SPY | ETF | 107.45 | 109.48 | 107.35 | 107.52 | 43900.0 |
| 2001-10-29 17:00:00 | SPY | ETF | 107.49 | 107.5 | 107.1 | 107.4 | 38700.0 |
| 2001-10-29 17:30:00 | SPY | ETF | 107.45 | 107.45 | 106.95 | 107.01 | 4300.0 |
| 2001-10-29 18:00:00 | SPY | ETF | 107.0 | 107.0 | 106.6 | 106.9 | 12500.0 |
| 2001-10-29 09:30:00 | QQQ | ETF | 36.0 | 36.15 | 35.56 | 35.68 | 15806400.0 |
| 2001-10-29 10:00:00 | QQQ | ETF | 35.67 | 35.7 | 35.35 | 35.54 | 8536500.0 |
| 2001-10-29 10:30:00 | QQQ | ETF | 35.52 | 35.83 | 35.45 | 35.75 | 5361800.0 |
| 2001-10-29 11:00:00 | QQQ | ETF | 35.75 | 35.76 | 35.35 | 35.49 | 5660800.0 |
| 2001-10-29 11:30:00 | QQQ | ETF | 35.44 | 35.65 | 35.19 | 35.33 | 4726300.0 |
| 2001-10-29 12:00:00 | QQQ | ETF | 35.33 | 35.42 | 35.16 | 35.39 | 3863900.0 |
| 2001-10-29 12:30:00 | QQQ | ETF | 35.37 | 35.4 | 35.08 | 35.2 | 4074800.0 |
| 2001-10-29 13:00:00 | QQQ | ETF | 35.18 | 35.23 | 34.8 | 34.83 | 6011300.0 |
| 2001-10-29 13:30:00 | QQQ | ETF | 34.85 | 35.02 | 34.8 | 34.87 | 5823900.0 |
| 2001-10-29 14:00:00 | QQQ | ETF | 34.85 | 34.91 | 34.56 | 34.7 | 6701400.0 |
| 2001-10-29 14:30:00 | QQQ | ETF | 34.72 | 34.95 | 34.63 | 34.92 | 6236600.0 |
| 2001-10-29 15:00:00 | QQQ | ETF | 34.92 | 34.94 | 34.5 | 34.63 | 6284000.0 |
| 2001-10-29 15:30:00 | QQQ | ETF | 34.61 | 34.64 | 34.2 | 34.25 | 10032500.0 |
| 2001-10-29 16:00:00 | QQQ | ETF | 34.22 | 34.52 | 34.0 | 34.05 | 2114300.0 |
| 2001-10-29 16:30:00 | QQQ | ETF | 34.08 | 35.52 | 33.95 | 33.99 | 108900.0 |
| 2001-10-29 17:00:00 | QQQ | ETF | 33.96 | 34.0 | 33.8 | 33.88 | 87500.0 |
| 2001-10-29 17:30:00 | QQQ | ETF | 33.88 | 33.9 | 33.6 | 33.6 | 149600.0 |
| 2001-10-29 18:00:00 | QQQ | ETF | 33.61 | 33.69 | 33.4 | 33.4 | 39000.0 |
| 2001-10-29 09:30:00 | IWM | ETF | 43.505 | 43.51 | 43.43 | 43.43 | 15200.0 |
| 2001-10-29 10:00:00 | IWM | ETF | 43.395 | 43.46 | 43.15 | 43.26 | 144200.0 |
| 2001-10-29 10:30:00 | IWM | ETF | 43.31 | 43.345 | 43.31 | 43.345 | 5800.0 |
| 2001-10-29 11:00:00 | IWM | ETF | 43.34 | 43.34 | 43.25 | 43.25 | 10800.0 |
| 2001-10-29 11:30:00 | IWM | ETF | 43.24 | 43.275 | 43.16 | 43.16 | 80000.0 |
| 2001-10-29 12:00:00 | IWM | ETF | 43.21 | 43.22 | 43.16 | 43.22 | 12600.0 |
| 2001-10-29 12:30:00 | IWM | ETF | 43.21 | 43.24 | 43.165 | 43.235 | 20000.0 |
| 2001-10-29 13:00:00 | IWM | ETF | 43.165 | 43.165 | 43.105 | 43.105 | 12800.0 |
| 2001-10-29 13:30:00 | IWM | ETF | 43.075 | 43.165 | 43.075 | 43.135 | 12000.0 |
| 2001-10-29 14:00:00 | IWM | ETF | 43.15 | 43.15 | 42.985 | 43.045 | 35000.0 |
| 2001-10-29 14:30:00 | IWM | ETF | 43.045 | 43.115 | 43.005 | 43.115 | 16600.0 |
| 2001-10-29 15:00:00 | IWM | ETF | 43.135 | 43.2 | 42.94 | 42.955 | 30200.0 |
| 2001-10-29 15:30:00 | IWM | ETF | 43.0 | 43.0 | 42.7 | 42.8 | 77400.0 |
| 2001-10-29 16:00:00 | IWM | ETF | 42.705 | 42.75 | 42.705 | 42.75 | 3800.0 |
> showing 50 of 425 rows — these rows as CSV