PREVIEW / etf_30min / 2002-03-21
file: by_date/etf_30min/2002/2002-03-21.parquet size: 19 KB rows: 500
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-21 09:30:00 | SPY | ETF | 115.3 | 115.37 | 114.9 | 114.93 | 2112800.0 |
| 2002-03-21 10:00:00 | SPY | ETF | 114.94 | 115.09 | 114.76 | 114.86 | 3063700.0 |
| 2002-03-21 10:30:00 | SPY | ETF | 114.85 | 115.35 | 114.82 | 115.03 | 1813700.0 |
| 2002-03-21 11:00:00 | SPY | ETF | 115.05 | 115.13 | 114.93 | 115.0 | 1351900.0 |
| 2002-03-21 11:30:00 | SPY | ETF | 114.97 | 115.03 | 114.6 | 114.71 | 1621500.0 |
| 2002-03-21 12:00:00 | SPY | ETF | 114.69 | 114.71 | 114.17 | 114.2 | 3265300.0 |
| 2002-03-21 12:30:00 | SPY | ETF | 114.14 | 114.68 | 114.12 | 114.67 | 1098100.0 |
| 2002-03-21 13:00:00 | SPY | ETF | 114.66 | 114.95 | 114.65 | 114.87 | 1814900.0 |
| 2002-03-21 13:30:00 | SPY | ETF | 114.89 | 115.09 | 114.7 | 114.76 | 923200.0 |
| 2002-03-21 14:00:00 | SPY | ETF | 114.78 | 114.85 | 114.52 | 114.79 | 837800.0 |
| 2002-03-21 14:30:00 | SPY | ETF | 114.8 | 115.49 | 114.68 | 115.38 | 2094400.0 |
| 2002-03-21 15:00:00 | SPY | ETF | 115.4 | 115.51 | 115.21 | 115.32 | 1844700.0 |
| 2002-03-21 15:30:00 | SPY | ETF | 115.35 | 115.83 | 115.32 | 115.6 | 2460900.0 |
| 2002-03-21 16:00:00 | SPY | ETF | 115.6 | 115.66 | 115.02 | 115.38 | 1373700.0 |
| 2002-03-21 16:30:00 | SPY | ETF | 115.38 | 115.38 | 115.35 | 115.35 | 7400.0 |
| 2002-03-21 17:00:00 | SPY | ETF | 115.3 | 115.3 | 115.2 | 115.2 | 6700.0 |
| 2002-03-21 17:30:00 | SPY | ETF | 115.18 | 115.3 | 115.15 | 115.3 | 6700.0 |
| 2002-03-21 18:00:00 | SPY | ETF | 115.3 | 115.35 | 115.28 | 115.31 | 3600.0 |
| 2002-03-21 09:30:00 | QQQ | ETF | 36.15 | 36.21 | 35.95 | 36.05 | 10632000.0 |
| 2002-03-21 10:00:00 | QQQ | ETF | 36.05 | 36.23 | 35.9 | 36.12 | 10630600.0 |
| 2002-03-21 10:30:00 | QQQ | ETF | 36.12 | 36.49 | 36.1 | 36.3 | 8134900.0 |
| 2002-03-21 11:00:00 | QQQ | ETF | 36.3 | 36.38 | 36.27 | 36.32 | 2646900.0 |
| 2002-03-21 11:30:00 | QQQ | ETF | 36.32 | 36.36 | 36.15 | 36.2 | 2955900.0 |
| 2002-03-21 12:00:00 | QQQ | ETF | 36.21 | 36.23 | 35.93 | 35.99 | 8460800.0 |
| 2002-03-21 12:30:00 | QQQ | ETF | 35.99 | 36.33 | 35.96 | 36.3 | 5541500.0 |
| 2002-03-21 13:00:00 | QQQ | ETF | 36.32 | 36.45 | 36.25 | 36.4 | 3657400.0 |
| 2002-03-21 13:30:00 | QQQ | ETF | 36.4 | 36.5 | 36.27 | 36.34 | 3553200.0 |
| 2002-03-21 14:00:00 | QQQ | ETF | 36.34 | 36.46 | 36.25 | 36.45 | 2889000.0 |
| 2002-03-21 14:30:00 | QQQ | ETF | 36.45 | 36.83 | 36.37 | 36.8 | 7664900.0 |
| 2002-03-21 15:00:00 | QQQ | ETF | 36.78 | 36.88 | 36.69 | 36.82 | 6760700.0 |
| 2002-03-21 15:30:00 | QQQ | ETF | 36.84 | 37.14 | 36.8 | 37.1 | 10581300.0 |
| 2002-03-21 16:00:00 | QQQ | ETF | 37.1 | 37.11 | 36.94 | 37.06 | 2311100.0 |
| 2002-03-21 16:30:00 | QQQ | ETF | 37.07 | 37.08 | 37.04 | 37.06 | 35800.0 |
| 2002-03-21 17:00:00 | QQQ | ETF | 37.04 | 37.05 | 36.8 | 36.86 | 361400.0 |
| 2002-03-21 17:30:00 | QQQ | ETF | 36.83 | 37.0 | 36.76 | 37.0 | 115900.0 |
| 2002-03-21 18:00:00 | QQQ | ETF | 36.95 | 37.01 | 36.9 | 37.01 | 53600.0 |
| 2002-03-21 09:30:00 | IWM | ETF | 49.775 | 49.775 | 49.555 | 49.66 | 50000.0 |
| 2002-03-21 10:00:00 | IWM | ETF | 49.64 | 49.64 | 49.515 | 49.57 | 34800.0 |
| 2002-03-21 10:30:00 | IWM | ETF | 49.58 | 49.87 | 49.565 | 49.79 | 151000.0 |
| 2002-03-21 11:00:00 | IWM | ETF | 49.76 | 49.81 | 49.735 | 49.78 | 29800.0 |
| 2002-03-21 11:30:00 | IWM | ETF | 49.78 | 49.78 | 49.575 | 49.675 | 43800.0 |
| 2002-03-21 12:00:00 | IWM | ETF | 49.585 | 49.67 | 49.505 | 49.55 | 121200.0 |
| 2002-03-21 12:30:00 | IWM | ETF | 49.525 | 49.625 | 49.5 | 49.625 | 9400.0 |
| 2002-03-21 13:00:00 | IWM | ETF | 49.625 | 49.73 | 49.615 | 49.73 | 31800.0 |
| 2002-03-21 13:30:00 | IWM | ETF | 49.7 | 49.79 | 49.7 | 49.79 | 73000.0 |
| 2002-03-21 14:00:00 | IWM | ETF | 49.725 | 49.77 | 49.72 | 49.74 | 4600.0 |
| 2002-03-21 14:30:00 | IWM | ETF | 49.755 | 50.075 | 49.75 | 50.04 | 91000.0 |
| 2002-03-21 15:00:00 | IWM | ETF | 50.01 | 50.04 | 49.925 | 49.985 | 46400.0 |
| 2002-03-21 15:30:00 | IWM | ETF | 50.04 | 50.31 | 50.03 | 50.27 | 247600.0 |
| 2002-03-21 16:00:00 | IWM | ETF | 50.265 | 50.275 | 50.11 | 50.265 | 14400.0 |
> showing 50 of 500 rows — these rows as CSV