PREVIEW / etf_30min / 2001-11-07
file: by_date/etf_30min/2001/2001-11-07.parquet size: 17 KB rows: 448
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-07 09:30:00 | SPY | ETF | 111.77 | 112.4 | 111.7 | 112.12 | 2521300.0 |
| 2001-11-07 10:00:00 | SPY | ETF | 112.14 | 112.22 | 111.75 | 111.95 | 1112800.0 |
| 2001-11-07 10:30:00 | SPY | ETF | 111.94 | 112.7 | 111.94 | 112.3 | 1942100.0 |
| 2001-11-07 11:00:00 | SPY | ETF | 112.28 | 112.63 | 112.25 | 112.33 | 1190100.0 |
| 2001-11-07 11:30:00 | SPY | ETF | 112.29 | 112.46 | 112.0 | 112.1 | 1172100.0 |
| 2001-11-07 12:00:00 | SPY | ETF | 112.07 | 112.33 | 112.03 | 112.11 | 870000.0 |
| 2001-11-07 12:30:00 | SPY | ETF | 112.1 | 112.68 | 112.1 | 112.59 | 740600.0 |
| 2001-11-07 13:00:00 | SPY | ETF | 112.53 | 113.05 | 112.5 | 112.82 | 1538000.0 |
| 2001-11-07 13:30:00 | SPY | ETF | 112.78 | 113.12 | 112.57 | 112.58 | 645900.0 |
| 2001-11-07 14:00:00 | SPY | ETF | 112.57 | 112.65 | 112.01 | 112.09 | 2490200.0 |
| 2001-11-07 14:30:00 | SPY | ETF | 112.08 | 112.45 | 111.83 | 112.45 | 631100.0 |
| 2001-11-07 15:00:00 | SPY | ETF | 112.42 | 112.45 | 112.0 | 112.36 | 1208000.0 |
| 2001-11-07 15:30:00 | SPY | ETF | 112.35 | 112.38 | 111.64 | 111.96 | 1677100.0 |
| 2001-11-07 16:00:00 | SPY | ETF | 111.87 | 112.29 | 111.82 | 112.29 | 1252300.0 |
| 2001-11-07 16:30:00 | SPY | ETF | 112.3 | 112.3 | 112.2 | 112.25 | 5400.0 |
| 2001-11-07 17:00:00 | SPY | ETF | 112.24 | 112.24 | 112.2 | 112.2 | 900.0 |
| 2001-11-07 18:00:00 | SPY | ETF | 112.1 | 112.1 | 112.1 | 112.1 | 1000.0 |
| 2001-11-07 09:30:00 | QQQ | ETF | 37.61 | 38.29 | 37.53 | 38.1 | 15077800.0 |
| 2001-11-07 10:00:00 | QQQ | ETF | 38.07 | 38.14 | 37.63 | 37.86 | 9873400.0 |
| 2001-11-07 10:30:00 | QQQ | ETF | 37.85 | 38.43 | 37.84 | 38.05 | 9917900.0 |
| 2001-11-07 11:00:00 | QQQ | ETF | 38.08 | 38.36 | 38.05 | 38.11 | 4736400.0 |
| 2001-11-07 11:30:00 | QQQ | ETF | 38.11 | 38.19 | 37.91 | 37.97 | 4438100.0 |
| 2001-11-07 12:00:00 | QQQ | ETF | 37.99 | 38.19 | 37.93 | 38.05 | 1853900.0 |
| 2001-11-07 12:30:00 | QQQ | ETF | 38.06 | 38.49 | 38.05 | 38.4 | 3479800.0 |
| 2001-11-07 13:00:00 | QQQ | ETF | 38.43 | 38.7 | 38.39 | 38.55 | 6716000.0 |
| 2001-11-07 13:30:00 | QQQ | ETF | 38.58 | 38.84 | 38.53 | 38.53 | 4938100.0 |
| 2001-11-07 14:00:00 | QQQ | ETF | 38.57 | 38.6 | 38.12 | 38.18 | 6374600.0 |
| 2001-11-07 14:30:00 | QQQ | ETF | 38.18 | 38.4 | 37.95 | 38.37 | 7123700.0 |
| 2001-11-07 15:00:00 | QQQ | ETF | 38.37 | 38.42 | 38.0 | 38.3 | 5400500.0 |
| 2001-11-07 15:30:00 | QQQ | ETF | 38.29 | 38.3 | 37.7 | 37.95 | 8455800.0 |
| 2001-11-07 16:00:00 | QQQ | ETF | 37.97 | 38.2 | 37.9 | 38.2 | 3734000.0 |
| 2001-11-07 16:30:00 | QQQ | ETF | 38.2 | 38.21 | 37.99 | 38.1 | 342800.0 |
| 2001-11-07 17:00:00 | QQQ | ETF | 38.1 | 38.11 | 38.0 | 38.0 | 38700.0 |
| 2001-11-07 17:30:00 | QQQ | ETF | 38.02 | 38.05 | 37.94 | 37.95 | 48200.0 |
| 2001-11-07 18:00:00 | QQQ | ETF | 37.95 | 38.2 | 37.95 | 37.96 | 20700.0 |
| 2001-11-07 09:30:00 | IWM | ETF | 43.85 | 44.25 | 43.805 | 44.125 | 113000.0 |
| 2001-11-07 10:00:00 | IWM | ETF | 44.125 | 44.195 | 44.0 | 44.05 | 31600.0 |
| 2001-11-07 10:30:00 | IWM | ETF | 44.08 | 44.325 | 44.07 | 44.12 | 11600.0 |
| 2001-11-07 11:00:00 | IWM | ETF | 44.105 | 44.2 | 44.055 | 44.1 | 46000.0 |
| 2001-11-07 11:30:00 | IWM | ETF | 44.11 | 44.2 | 44.015 | 44.065 | 111200.0 |
| 2001-11-07 12:00:00 | IWM | ETF | 44.0 | 44.055 | 43.965 | 44.05 | 13200.0 |
| 2001-11-07 12:30:00 | IWM | ETF | 43.99 | 44.225 | 43.99 | 44.225 | 123400.0 |
| 2001-11-07 13:00:00 | IWM | ETF | 44.215 | 44.29 | 44.1 | 44.1 | 29400.0 |
| 2001-11-07 13:30:00 | IWM | ETF | 44.16 | 44.195 | 44.145 | 44.155 | 5400.0 |
| 2001-11-07 14:00:00 | IWM | ETF | 44.19 | 44.2 | 44.035 | 44.075 | 4600.0 |
| 2001-11-07 14:30:00 | IWM | ETF | 44.04 | 44.13 | 43.895 | 44.13 | 41400.0 |
| 2001-11-07 15:00:00 | IWM | ETF | 44.11 | 44.11 | 43.99 | 44.05 | 29400.0 |
| 2001-11-07 15:30:00 | IWM | ETF | 43.99 | 44.1 | 43.935 | 44.0 | 16000.0 |
| 2001-11-07 16:00:00 | IWM | ETF | 43.805 | 43.95 | 43.805 | 43.95 | 8000.0 |
| 2001-11-07 09:30:00 | DIA | ETF | 95.38 | 96.0 | 95.35 | 95.71 | 680700.0 |
> showing 50 of 448 rows — these rows as CSV