PREVIEW / etf_30min / 2001-01-29
file: by_date/etf_30min/2001/2001-01-29.parquet size: 14 KB rows: 335
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-01-29 09:30:00 | SPY | ETF | 135.5 | 136.1 | 135.37 | 135.87 | 869300.0 |
| 2001-01-29 10:00:00 | SPY | ETF | 135.86 | 136.0 | 135.54 | 135.72 | 685000.0 |
| 2001-01-29 10:30:00 | SPY | ETF | 135.73 | 136.0 | 135.61 | 135.98 | 353700.0 |
| 2001-01-29 11:00:00 | SPY | ETF | 135.87 | 136.1 | 135.53 | 136.03 | 660900.0 |
| 2001-01-29 11:30:00 | SPY | ETF | 136.14 | 136.35 | 135.96 | 136.16 | 453900.0 |
| 2001-01-29 12:00:00 | SPY | ETF | 136.14 | 136.2 | 135.95 | 136.14 | 255600.0 |
| 2001-01-29 12:30:00 | SPY | ETF | 136.16 | 136.21 | 136.0 | 136.14 | 197100.0 |
| 2001-01-29 13:00:00 | SPY | ETF | 136.08 | 136.42 | 136.0 | 136.27 | 437200.0 |
| 2001-01-29 13:30:00 | SPY | ETF | 136.27 | 136.49 | 136.13 | 136.49 | 153500.0 |
| 2001-01-29 14:00:00 | SPY | ETF | 136.37 | 136.75 | 136.28 | 136.65 | 201700.0 |
| 2001-01-29 14:30:00 | SPY | ETF | 136.68 | 136.82 | 136.51 | 136.79 | 201300.0 |
| 2001-01-29 15:00:00 | SPY | ETF | 136.79 | 136.9 | 136.57 | 136.79 | 473900.0 |
| 2001-01-29 15:30:00 | SPY | ETF | 136.71 | 136.88 | 136.53 | 136.65 | 603100.0 |
| 2001-01-29 16:00:00 | SPY | ETF | 136.61 | 136.73 | 136.16 | 136.16 | 405300.0 |
| 2001-01-29 16:30:00 | SPY | ETF | 136.6 | 136.6 | 136.6 | 136.6 | 900.0 |
| 2001-01-29 09:30:00 | QQQ | ETF | 64.75 | 65.42 | 64.25 | 65.21 | 4647500.0 |
| 2001-01-29 10:00:00 | QQQ | ETF | 65.27 | 65.39 | 64.75 | 64.76 | 2630400.0 |
| 2001-01-29 10:30:00 | QQQ | ETF | 64.87 | 65.19 | 64.53 | 65.05 | 1541700.0 |
| 2001-01-29 11:00:00 | QQQ | ETF | 65.07 | 65.49 | 64.75 | 65.4 | 1597900.0 |
| 2001-01-29 11:30:00 | QQQ | ETF | 65.43 | 65.87 | 65.25 | 65.65 | 2511000.0 |
| 2001-01-29 12:00:00 | QQQ | ETF | 65.69 | 65.79 | 65.35 | 65.6 | 1318300.0 |
| 2001-01-29 12:30:00 | QQQ | ETF | 65.62 | 65.83 | 65.49 | 65.79 | 1443200.0 |
| 2001-01-29 13:00:00 | QQQ | ETF | 65.8 | 66.15 | 65.65 | 66.09 | 1749200.0 |
| 2001-01-29 13:30:00 | QQQ | ETF | 66.05 | 66.4 | 65.9 | 66.4 | 1270600.0 |
| 2001-01-29 14:00:00 | QQQ | ETF | 66.41 | 67.15 | 66.3 | 66.91 | 3281900.0 |
| 2001-01-29 14:30:00 | QQQ | ETF | 66.9 | 67.05 | 66.63 | 66.83 | 2281400.0 |
| 2001-01-29 15:00:00 | QQQ | ETF | 66.85 | 67.15 | 66.78 | 67.04 | 2034900.0 |
| 2001-01-29 15:30:00 | QQQ | ETF | 67.07 | 67.25 | 66.75 | 67.1 | 2856100.0 |
| 2001-01-29 16:00:00 | QQQ | ETF | 67.08 | 67.13 | 66.95 | 67.07 | 585300.0 |
| 2001-01-29 16:30:00 | QQQ | ETF | 67.06 | 67.1 | 67.0 | 67.02 | 9700.0 |
| 2001-01-29 17:00:00 | QQQ | ETF | 67.05 | 67.15 | 67.02 | 67.1 | 5700.0 |
| 2001-01-29 17:30:00 | QQQ | ETF | 67.05 | 67.07 | 67.0 | 67.05 | 4800.0 |
| 2001-01-29 18:00:00 | QQQ | ETF | 67.05 | 67.1 | 67.0 | 67.1 | 6300.0 |
| 2001-01-29 09:30:00 | IWM | ETF | 49.695 | 50.15 | 49.695 | 50.15 | 9800.0 |
| 2001-01-29 10:00:00 | IWM | ETF | 50.15 | 50.225 | 50.03 | 50.055 | 144000.0 |
| 2001-01-29 10:30:00 | IWM | ETF | 50.03 | 50.195 | 50.025 | 50.195 | 29400.0 |
| 2001-01-29 11:00:00 | IWM | ETF | 50.22 | 50.275 | 50.205 | 50.25 | 43000.0 |
| 2001-01-29 11:30:00 | IWM | ETF | 50.275 | 50.45 | 50.275 | 50.45 | 20600.0 |
| 2001-01-29 12:00:00 | IWM | ETF | 50.45 | 50.475 | 50.45 | 50.475 | 7600.0 |
| 2001-01-29 12:30:00 | IWM | ETF | 50.475 | 50.475 | 50.47 | 50.47 | 3600.0 |
| 2001-01-29 13:00:00 | IWM | ETF | 50.465 | 50.47 | 50.38 | 50.47 | 88200.0 |
| 2001-01-29 13:30:00 | IWM | ETF | 50.525 | 50.575 | 50.5 | 50.5 | 67400.0 |
| 2001-01-29 14:00:00 | IWM | ETF | 50.5 | 50.605 | 50.5 | 50.605 | 6200.0 |
| 2001-01-29 14:30:00 | IWM | ETF | 50.645 | 50.645 | 50.515 | 50.515 | 54000.0 |
| 2001-01-29 15:00:00 | IWM | ETF | 50.62 | 50.62 | 50.5 | 50.5 | 8800.0 |
| 2001-01-29 15:30:00 | IWM | ETF | 50.565 | 50.725 | 50.375 | 50.7 | 40000.0 |
| 2001-01-29 16:00:00 | IWM | ETF | 50.7 | 50.825 | 50.7 | 50.825 | 3400.0 |
| 2001-01-29 09:30:00 | DIA | ETF | 106.61 | 106.86 | 106.58 | 106.7 | 92200.0 |
| 2001-01-29 10:00:00 | DIA | ETF | 106.65 | 106.79 | 106.33 | 106.39 | 28300.0 |
| 2001-01-29 10:30:00 | DIA | ETF | 106.41 | 106.49 | 106.32 | 106.32 | 60800.0 |
> showing 50 of 335 rows — these rows as CSV