PREVIEW / etf_30min / 2001-05-07
file: by_date/etf_30min/2001/2001-05-07.parquet size: 14 KB rows: 358
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-05-07 09:30:00 | SPY | ETF | 127.0 | 127.26 | 126.58 | 127.21 | 651400.0 |
| 2001-05-07 10:00:00 | SPY | ETF | 127.2 | 127.38 | 126.84 | 126.98 | 773600.0 |
| 2001-05-07 10:30:00 | SPY | ETF | 126.86 | 127.22 | 126.26 | 126.37 | 707500.0 |
| 2001-05-07 11:00:00 | SPY | ETF | 126.36 | 126.79 | 126.35 | 126.5 | 295600.0 |
| 2001-05-07 11:30:00 | SPY | ETF | 126.46 | 126.63 | 126.26 | 126.5 | 311500.0 |
| 2001-05-07 12:00:00 | SPY | ETF | 126.53 | 126.69 | 126.42 | 126.59 | 131700.0 |
| 2001-05-07 12:30:00 | SPY | ETF | 126.5 | 126.68 | 126.32 | 126.55 | 319000.0 |
| 2001-05-07 13:00:00 | SPY | ETF | 126.55 | 126.71 | 126.23 | 126.39 | 307300.0 |
| 2001-05-07 13:30:00 | SPY | ETF | 126.39 | 126.87 | 126.23 | 126.85 | 342400.0 |
| 2001-05-07 14:00:00 | SPY | ETF | 126.85 | 127.24 | 126.71 | 127.24 | 467700.0 |
| 2001-05-07 14:30:00 | SPY | ETF | 127.24 | 127.27 | 126.81 | 126.9 | 313200.0 |
| 2001-05-07 15:00:00 | SPY | ETF | 126.96 | 127.07 | 126.58 | 126.68 | 413900.0 |
| 2001-05-07 15:30:00 | SPY | ETF | 126.69 | 126.96 | 126.45 | 126.57 | 474600.0 |
| 2001-05-07 16:00:00 | SPY | ETF | 126.56 | 126.96 | 126.24 | 126.33 | 656000.0 |
| 2001-05-07 16:30:00 | SPY | ETF | 126.34 | 126.56 | 126.34 | 126.5 | 1500.0 |
| 2001-05-07 09:30:00 | QQQ | ETF | 48.0 | 48.3 | 47.59 | 48.2 | 6928600.0 |
| 2001-05-07 10:00:00 | QQQ | ETF | 48.19 | 48.6 | 48.01 | 48.1 | 5654900.0 |
| 2001-05-07 10:30:00 | QQQ | ETF | 48.04 | 48.33 | 47.5 | 47.56 | 4722400.0 |
| 2001-05-07 11:00:00 | QQQ | ETF | 47.55 | 47.98 | 47.51 | 47.6 | 3018700.0 |
| 2001-05-07 11:30:00 | QQQ | ETF | 47.6 | 47.73 | 47.11 | 47.33 | 3064000.0 |
| 2001-05-07 12:00:00 | QQQ | ETF | 47.27 | 47.7 | 47.25 | 47.49 | 1655800.0 |
| 2001-05-07 12:30:00 | QQQ | ETF | 47.49 | 47.65 | 47.3 | 47.62 | 1256100.0 |
| 2001-05-07 13:00:00 | QQQ | ETF | 47.65 | 47.74 | 47.21 | 47.4 | 1255900.0 |
| 2001-05-07 13:30:00 | QQQ | ETF | 47.36 | 47.75 | 47.27 | 47.73 | 1399000.0 |
| 2001-05-07 14:00:00 | QQQ | ETF | 47.71 | 48.05 | 47.62 | 48.01 | 2499800.0 |
| 2001-05-07 14:30:00 | QQQ | ETF | 48.05 | 48.15 | 47.6 | 47.65 | 3058300.0 |
| 2001-05-07 15:00:00 | QQQ | ETF | 47.73 | 47.8 | 47.35 | 47.39 | 3150100.0 |
| 2001-05-07 15:30:00 | QQQ | ETF | 47.37 | 47.53 | 47.1 | 47.21 | 4053400.0 |
| 2001-05-07 16:00:00 | QQQ | ETF | 47.26 | 48.4 | 47.2 | 47.42 | 1265200.0 |
| 2001-05-07 16:30:00 | QQQ | ETF | 47.45 | 47.5 | 47.34 | 47.42 | 75300.0 |
| 2001-05-07 17:00:00 | QQQ | ETF | 47.4 | 47.5 | 47.38 | 47.41 | 13700.0 |
| 2001-05-07 17:30:00 | QQQ | ETF | 47.4 | 47.49 | 47.38 | 47.49 | 12200.0 |
| 2001-05-07 18:00:00 | QQQ | ETF | 47.45 | 47.47 | 47.4 | 47.47 | 4000.0 |
| 2001-05-07 09:30:00 | IWM | ETF | 49.3 | 49.3 | 49.1 | 49.15 | 7000.0 |
| 2001-05-07 10:00:00 | IWM | ETF | 49.4 | 49.5 | 49.35 | 49.35 | 6600.0 |
| 2001-05-07 10:30:00 | IWM | ETF | 49.3 | 49.37 | 49.005 | 49.005 | 23200.0 |
| 2001-05-07 11:00:00 | IWM | ETF | 49.085 | 49.15 | 49.0 | 49.075 | 107000.0 |
| 2001-05-07 11:30:00 | IWM | ETF | 49.045 | 49.175 | 48.97 | 48.97 | 26400.0 |
| 2001-05-07 12:00:00 | IWM | ETF | 48.955 | 49.21 | 48.955 | 49.03 | 9400.0 |
| 2001-05-07 12:30:00 | IWM | ETF | 49.15 | 49.15 | 48.975 | 49.145 | 7600.0 |
| 2001-05-07 13:00:00 | IWM | ETF | 49.145 | 49.145 | 49.125 | 49.145 | 3600.0 |
| 2001-05-07 13:30:00 | IWM | ETF | 49.145 | 49.145 | 49.14 | 49.14 | 600.0 |
| 2001-05-07 14:00:00 | IWM | ETF | 49.125 | 49.315 | 49.125 | 49.315 | 9000.0 |
| 2001-05-07 14:30:00 | IWM | ETF | 49.25 | 49.35 | 49.15 | 49.32 | 5200.0 |
| 2001-05-07 15:00:00 | IWM | ETF | 49.15 | 49.28 | 49.125 | 49.125 | 3200.0 |
| 2001-05-07 15:30:00 | IWM | ETF | 49.09 | 49.09 | 48.7 | 48.825 | 31600.0 |
| 2001-05-07 16:00:00 | IWM | ETF | 48.75 | 48.75 | 48.75 | 48.75 | 13800.0 |
| 2001-05-07 09:30:00 | DIA | ETF | 109.5 | 109.95 | 109.33 | 109.92 | 568500.0 |
| 2001-05-07 10:00:00 | DIA | ETF | 109.93 | 110.03 | 109.65 | 109.65 | 509500.0 |
| 2001-05-07 10:30:00 | DIA | ETF | 109.7 | 109.84 | 109.11 | 109.33 | 168400.0 |
> showing 50 of 358 rows — these rows as CSV