PREVIEW / etf_30min / 2001-12-21
file: by_date/etf_30min/2001/2001-12-21.parquet size: 18 KB rows: 490
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-12-21 09:30:00 | SPY | ETF | 115.03 | 115.07 | 114.68 | 114.75 | 2728100.0 |
| 2001-12-21 10:00:00 | SPY | ETF | 114.74 | 114.81 | 114.48 | 114.57 | 1180100.0 |
| 2001-12-21 10:30:00 | SPY | ETF | 114.62 | 114.89 | 114.56 | 114.84 | 882000.0 |
| 2001-12-21 11:00:00 | SPY | ETF | 114.83 | 114.84 | 114.58 | 114.71 | 397400.0 |
| 2001-12-21 11:30:00 | SPY | ETF | 114.73 | 114.76 | 114.43 | 114.47 | 515100.0 |
| 2001-12-21 12:00:00 | SPY | ETF | 114.47 | 114.47 | 114.26 | 114.38 | 369100.0 |
| 2001-12-21 12:30:00 | SPY | ETF | 114.42 | 114.51 | 114.3 | 114.35 | 517200.0 |
| 2001-12-21 13:00:00 | SPY | ETF | 114.36 | 114.41 | 114.2 | 114.37 | 656300.0 |
| 2001-12-21 13:30:00 | SPY | ETF | 114.32 | 114.62 | 114.25 | 114.54 | 760500.0 |
| 2001-12-21 14:00:00 | SPY | ETF | 114.58 | 114.76 | 114.53 | 114.75 | 1278900.0 |
| 2001-12-21 14:30:00 | SPY | ETF | 114.75 | 114.9 | 114.69 | 114.84 | 535500.0 |
| 2001-12-21 15:00:00 | SPY | ETF | 114.83 | 114.86 | 114.7 | 114.81 | 790900.0 |
| 2001-12-21 15:30:00 | SPY | ETF | 114.82 | 114.99 | 114.64 | 114.66 | 1283500.0 |
| 2001-12-21 16:00:00 | SPY | ETF | 114.68 | 114.98 | 114.57 | 114.8 | 1132400.0 |
| 2001-12-21 16:30:00 | SPY | ETF | 114.94 | 114.95 | 114.79 | 114.95 | 500900.0 |
| 2001-12-21 17:00:00 | SPY | ETF | 114.75 | 114.75 | 114.75 | 114.75 | 600.0 |
| 2001-12-21 17:30:00 | SPY | ETF | 114.97 | 114.97 | 114.9 | 114.9 | 4500.0 |
| 2001-12-21 18:00:00 | SPY | ETF | 114.9 | 114.9 | 114.9 | 114.9 | 500.0 |
| 2001-12-21 09:30:00 | QQQ | ETF | 39.42 | 39.59 | 39.21 | 39.52 | 10190800.0 |
| 2001-12-21 10:00:00 | QQQ | ETF | 39.52 | 39.54 | 39.18 | 39.21 | 5244500.0 |
| 2001-12-21 10:30:00 | QQQ | ETF | 39.25 | 39.5 | 39.21 | 39.45 | 4910900.0 |
| 2001-12-21 11:00:00 | QQQ | ETF | 39.44 | 39.46 | 39.32 | 39.44 | 1795500.0 |
| 2001-12-21 11:30:00 | QQQ | ETF | 39.44 | 39.48 | 39.18 | 39.23 | 3145400.0 |
| 2001-12-21 12:00:00 | QQQ | ETF | 39.25 | 39.31 | 39.15 | 39.19 | 2711300.0 |
| 2001-12-21 12:30:00 | QQQ | ETF | 39.24 | 39.35 | 39.21 | 39.27 | 1755700.0 |
| 2001-12-21 13:00:00 | QQQ | ETF | 39.29 | 39.3 | 39.17 | 39.22 | 1363300.0 |
| 2001-12-21 13:30:00 | QQQ | ETF | 39.25 | 39.39 | 39.2 | 39.37 | 2297600.0 |
| 2001-12-21 14:00:00 | QQQ | ETF | 39.37 | 39.6 | 39.33 | 39.55 | 3837000.0 |
| 2001-12-21 14:30:00 | QQQ | ETF | 39.57 | 39.71 | 39.54 | 39.55 | 3836200.0 |
| 2001-12-21 15:00:00 | QQQ | ETF | 39.55 | 39.59 | 39.42 | 39.51 | 3379600.0 |
| 2001-12-21 15:30:00 | QQQ | ETF | 39.52 | 39.64 | 39.26 | 39.34 | 8369300.0 |
| 2001-12-21 16:00:00 | QQQ | ETF | 39.3 | 39.53 | 39.28 | 39.5 | 2293900.0 |
| 2001-12-21 16:30:00 | QQQ | ETF | 39.5 | 39.56 | 39.4 | 39.54 | 384300.0 |
| 2001-12-21 17:00:00 | QQQ | ETF | 39.54 | 39.55 | 39.42 | 39.42 | 21700.0 |
| 2001-12-21 17:30:00 | QQQ | ETF | 39.45 | 39.5 | 39.45 | 39.46 | 38400.0 |
| 2001-12-21 18:00:00 | QQQ | ETF | 39.46 | 39.49 | 39.45 | 39.46 | 502600.0 |
| 2001-12-21 09:30:00 | IWM | ETF | 47.45 | 47.47 | 47.205 | 47.385 | 63400.0 |
| 2001-12-21 10:00:00 | IWM | ETF | 47.38 | 47.38 | 47.21 | 47.21 | 77000.0 |
| 2001-12-21 10:30:00 | IWM | ETF | 47.34 | 47.405 | 47.265 | 47.365 | 10400.0 |
| 2001-12-21 11:00:00 | IWM | ETF | 47.325 | 47.41 | 47.325 | 47.365 | 65000.0 |
| 2001-12-21 11:30:00 | IWM | ETF | 47.41 | 47.41 | 47.375 | 47.41 | 85400.0 |
| 2001-12-21 12:00:00 | IWM | ETF | 47.41 | 47.44 | 47.305 | 47.37 | 546600.0 |
| 2001-12-21 12:30:00 | IWM | ETF | 47.37 | 47.695 | 47.37 | 47.65 | 128800.0 |
| 2001-12-21 13:00:00 | IWM | ETF | 47.7 | 47.7 | 47.505 | 47.555 | 52600.0 |
| 2001-12-21 13:30:00 | IWM | ETF | 47.65 | 47.875 | 47.625 | 47.655 | 83000.0 |
| 2001-12-21 14:00:00 | IWM | ETF | 47.8 | 47.915 | 47.705 | 47.895 | 95600.0 |
| 2001-12-21 14:30:00 | IWM | ETF | 47.875 | 47.9 | 47.83 | 47.855 | 42800.0 |
| 2001-12-21 15:00:00 | IWM | ETF | 47.9 | 47.9 | 47.725 | 47.815 | 73800.0 |
| 2001-12-21 15:30:00 | IWM | ETF | 47.95 | 48.24 | 47.91 | 48.125 | 85400.0 |
| 2001-12-21 16:00:00 | IWM | ETF | 48.15 | 48.2 | 48.1 | 48.1 | 115600.0 |
> showing 50 of 490 rows — these rows as CSV