PREVIEW / etf_30min / 2001-10-04
file: by_date/etf_30min/2001/2001-10-04.parquet size: 17 KB rows: 428
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-04 09:30:00 | SPY | ETF | 108.29 | 108.29 | 107.18 | 107.62 | 3382100.0 |
| 2001-10-04 10:00:00 | SPY | ETF | 107.65 | 108.28 | 107.23 | 107.6 | 3659200.0 |
| 2001-10-04 10:30:00 | SPY | ETF | 107.61 | 108.28 | 107.27 | 108.25 | 1973700.0 |
| 2001-10-04 11:00:00 | SPY | ETF | 108.22 | 108.68 | 108.1 | 108.52 | 2031800.0 |
| 2001-10-04 11:30:00 | SPY | ETF | 108.59 | 108.75 | 108.25 | 108.38 | 2155500.0 |
| 2001-10-04 12:00:00 | SPY | ETF | 108.42 | 108.67 | 108.16 | 108.39 | 740400.0 |
| 2001-10-04 12:30:00 | SPY | ETF | 108.37 | 108.64 | 108.3 | 108.42 | 1507300.0 |
| 2001-10-04 13:00:00 | SPY | ETF | 108.41 | 108.75 | 108.21 | 108.28 | 870900.0 |
| 2001-10-04 13:30:00 | SPY | ETF | 108.27 | 108.48 | 107.95 | 108.22 | 1577700.0 |
| 2001-10-04 14:00:00 | SPY | ETF | 108.18 | 108.25 | 107.6 | 107.61 | 3056900.0 |
| 2001-10-04 14:30:00 | SPY | ETF | 107.63 | 108.08 | 107.38 | 107.95 | 2806500.0 |
| 2001-10-04 15:00:00 | SPY | ETF | 108.03 | 108.18 | 107.56 | 107.75 | 1422400.0 |
| 2001-10-04 15:30:00 | SPY | ETF | 107.77 | 107.93 | 106.75 | 107.1 | 3758200.0 |
| 2001-10-04 16:00:00 | SPY | ETF | 107.18 | 107.8 | 107.13 | 107.44 | 971900.0 |
| 2001-10-04 16:30:00 | SPY | ETF | 107.54 | 107.54 | 107.42 | 107.45 | 2100.0 |
| 2001-10-04 17:00:00 | SPY | ETF | 107.45 | 107.45 | 107.45 | 107.45 | 200.0 |
| 2001-10-04 17:30:00 | SPY | ETF | 107.44 | 107.44 | 107.43 | 107.43 | 1200.0 |
| 2001-10-04 18:00:00 | SPY | ETF | 107.25 | 107.44 | 107.25 | 107.25 | 700.0 |
| 2001-10-04 09:30:00 | QQQ | ETF | 31.65 | 31.7 | 30.94 | 31.55 | 18834900.0 |
| 2001-10-04 10:00:00 | QQQ | ETF | 31.54 | 32.05 | 31.5 | 31.8 | 16426000.0 |
| 2001-10-04 10:30:00 | QQQ | ETF | 31.75 | 32.25 | 31.61 | 32.2 | 10004300.0 |
| 2001-10-04 11:00:00 | QQQ | ETF | 32.21 | 32.67 | 32.13 | 32.64 | 9978400.0 |
| 2001-10-04 11:30:00 | QQQ | ETF | 32.64 | 32.74 | 32.33 | 32.39 | 8430600.0 |
| 2001-10-04 12:00:00 | QQQ | ETF | 32.38 | 32.6 | 32.14 | 32.18 | 6895500.0 |
| 2001-10-04 12:30:00 | QQQ | ETF | 32.2 | 32.45 | 32.18 | 32.28 | 2846800.0 |
| 2001-10-04 13:00:00 | QQQ | ETF | 32.29 | 32.63 | 32.21 | 32.32 | 3470600.0 |
| 2001-10-04 13:30:00 | QQQ | ETF | 32.33 | 32.39 | 32.06 | 32.2 | 5486300.0 |
| 2001-10-04 14:00:00 | QQQ | ETF | 32.22 | 32.25 | 31.71 | 31.72 | 8373900.0 |
| 2001-10-04 14:30:00 | QQQ | ETF | 31.75 | 32.05 | 31.59 | 32.0 | 7698900.0 |
| 2001-10-04 15:00:00 | QQQ | ETF | 32.01 | 32.19 | 31.78 | 31.94 | 6607600.0 |
| 2001-10-04 15:30:00 | QQQ | ETF | 31.97 | 32.04 | 31.26 | 31.38 | 13891800.0 |
| 2001-10-04 16:00:00 | QQQ | ETF | 31.38 | 32.63 | 31.25 | 31.33 | 2488200.0 |
| 2001-10-04 16:30:00 | QQQ | ETF | 31.31 | 31.54 | 31.26 | 31.37 | 149200.0 |
| 2001-10-04 17:00:00 | QQQ | ETF | 31.37 | 31.55 | 31.34 | 31.34 | 35600.0 |
| 2001-10-04 17:30:00 | QQQ | ETF | 31.35 | 31.36 | 31.3 | 31.3 | 4800.0 |
| 2001-10-04 18:00:00 | QQQ | ETF | 31.33 | 31.39 | 31.28 | 31.29 | 15700.0 |
| 2001-10-04 09:30:00 | IWM | ETF | 41.25 | 41.395 | 41.025 | 41.255 | 383200.0 |
| 2001-10-04 10:00:00 | IWM | ETF | 41.345 | 41.5 | 41.2 | 41.325 | 186000.0 |
| 2001-10-04 10:30:00 | IWM | ETF | 41.435 | 41.6 | 41.405 | 41.6 | 40200.0 |
| 2001-10-04 11:00:00 | IWM | ETF | 41.5 | 41.775 | 41.5 | 41.75 | 63600.0 |
| 2001-10-04 11:30:00 | IWM | ETF | 41.75 | 41.85 | 41.65 | 41.81 | 76800.0 |
| 2001-10-04 12:00:00 | IWM | ETF | 41.8 | 41.825 | 41.675 | 41.77 | 28000.0 |
| 2001-10-04 12:30:00 | IWM | ETF | 41.82 | 41.82 | 41.755 | 41.77 | 33200.0 |
| 2001-10-04 13:00:00 | IWM | ETF | 41.81 | 41.97 | 41.81 | 41.855 | 146000.0 |
| 2001-10-04 13:30:00 | IWM | ETF | 41.925 | 41.925 | 41.7 | 41.745 | 89000.0 |
| 2001-10-04 14:00:00 | IWM | ETF | 41.75 | 41.79 | 41.545 | 41.7 | 261800.0 |
| 2001-10-04 14:30:00 | IWM | ETF | 41.65 | 41.7 | 41.5 | 41.7 | 328800.0 |
| 2001-10-04 15:00:00 | IWM | ETF | 41.695 | 41.72 | 41.51 | 41.56 | 46400.0 |
| 2001-10-04 15:30:00 | IWM | ETF | 41.5 | 41.575 | 41.31 | 41.4 | 218800.0 |
| 2001-10-04 16:00:00 | IWM | ETF | 41.355 | 41.51 | 41.355 | 41.51 | 4400.0 |
> showing 50 of 428 rows — these rows as CSV