PREVIEW / etf_30min / 2001-11-23
file: by_date/etf_30min/2001/2001-11-23.parquet size: 12 KB rows: 234
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-23 09:30:00 | SPY | ETF | 114.04 | 114.46 | 114.0 | 114.27 | 775700.0 |
| 2001-11-23 10:00:00 | SPY | ETF | 114.28 | 114.5 | 114.13 | 114.47 | 685400.0 |
| 2001-11-23 10:30:00 | SPY | ETF | 114.46 | 114.59 | 114.41 | 114.59 | 401200.0 |
| 2001-11-23 11:00:00 | SPY | ETF | 114.59 | 115.01 | 114.54 | 114.98 | 471100.0 |
| 2001-11-23 11:30:00 | SPY | ETF | 114.96 | 115.24 | 114.83 | 115.17 | 850900.0 |
| 2001-11-23 12:00:00 | SPY | ETF | 115.19 | 115.57 | 115.15 | 115.45 | 354100.0 |
| 2001-11-23 12:30:00 | SPY | ETF | 115.46 | 115.66 | 115.38 | 115.46 | 2040000.0 |
| 2001-11-23 13:00:00 | SPY | ETF | 115.49 | 115.75 | 115.38 | 115.68 | 598700.0 |
| 2001-11-23 09:30:00 | QQQ | ETF | 38.76 | 38.9 | 38.57 | 38.69 | 4355000.0 |
| 2001-11-23 10:00:00 | QQQ | ETF | 38.67 | 38.88 | 38.57 | 38.86 | 3014100.0 |
| 2001-11-23 10:30:00 | QQQ | ETF | 38.84 | 38.88 | 38.7 | 38.75 | 1633100.0 |
| 2001-11-23 11:00:00 | QQQ | ETF | 38.75 | 39.05 | 38.72 | 39.01 | 4404300.0 |
| 2001-11-23 11:30:00 | QQQ | ETF | 39.0 | 39.28 | 38.96 | 39.22 | 4406400.0 |
| 2001-11-23 12:00:00 | QQQ | ETF | 39.23 | 39.38 | 39.16 | 39.27 | 3374500.0 |
| 2001-11-23 12:30:00 | QQQ | ETF | 39.27 | 39.43 | 39.2 | 39.27 | 3433700.0 |
| 2001-11-23 13:00:00 | QQQ | ETF | 39.25 | 39.32 | 39.2 | 39.28 | 1071400.0 |
| 2001-11-23 09:30:00 | IWM | ETF | 45.025 | 45.225 | 45.025 | 45.225 | 6600.0 |
| 2001-11-23 10:00:00 | IWM | ETF | 45.225 | 45.39 | 45.065 | 45.39 | 8200.0 |
| 2001-11-23 10:30:00 | IWM | ETF | 45.44 | 45.44 | 45.315 | 45.43 | 10400.0 |
| 2001-11-23 11:00:00 | IWM | ETF | 45.42 | 45.59 | 45.41 | 45.55 | 23200.0 |
| 2001-11-23 11:30:00 | IWM | ETF | 45.56 | 45.58 | 45.46 | 45.56 | 12600.0 |
| 2001-11-23 12:00:00 | IWM | ETF | 45.7 | 45.71 | 45.5 | 45.7 | 101000.0 |
| 2001-11-23 12:30:00 | IWM | ETF | 45.69 | 45.775 | 45.525 | 45.74 | 61600.0 |
| 2001-11-23 13:00:00 | IWM | ETF | 45.74 | 45.74 | 45.74 | 45.74 | 1000.0 |
| 2001-11-23 09:30:00 | DIA | ETF | 98.55 | 98.97 | 98.45 | 98.79 | 180100.0 |
| 2001-11-23 10:00:00 | DIA | ETF | 98.84 | 98.95 | 98.66 | 98.88 | 107600.0 |
| 2001-11-23 10:30:00 | DIA | ETF | 98.95 | 98.99 | 98.88 | 98.92 | 57400.0 |
| 2001-11-23 11:00:00 | DIA | ETF | 98.97 | 99.3 | 98.89 | 99.27 | 128900.0 |
| 2001-11-23 11:30:00 | DIA | ETF | 99.23 | 99.47 | 99.09 | 99.38 | 66600.0 |
| 2001-11-23 12:00:00 | DIA | ETF | 99.43 | 99.74 | 99.33 | 99.63 | 103000.0 |
| 2001-11-23 12:30:00 | DIA | ETF | 99.63 | 99.81 | 99.55 | 99.71 | 142200.0 |
| 2001-11-23 13:00:00 | DIA | ETF | 99.7 | 99.95 | 99.68 | 99.9 | 81300.0 |
> showing 32 of 234 rows — these rows as CSV