PREVIEW / etf_30min / 2001-08-31
file: by_date/etf_30min/2001/2001-08-31.parquet size: 15 KB rows: 380
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-08-31 09:30:00 | SPY | ETF | 113.4 | 113.6 | 113.13 | 113.4 | 2193100.0 |
| 2001-08-31 10:00:00 | SPY | ETF | 113.4 | 114.77 | 113.4 | 114.4 | 3423600.0 |
| 2001-08-31 10:30:00 | SPY | ETF | 114.4 | 114.45 | 113.87 | 113.89 | 764200.0 |
| 2001-08-31 11:00:00 | SPY | ETF | 113.86 | 113.92 | 113.63 | 113.9 | 790400.0 |
| 2001-08-31 11:30:00 | SPY | ETF | 113.91 | 113.92 | 113.35 | 113.37 | 964400.0 |
| 2001-08-31 12:00:00 | SPY | ETF | 113.41 | 113.78 | 113.2 | 113.73 | 906900.0 |
| 2001-08-31 12:30:00 | SPY | ETF | 113.74 | 114.11 | 113.63 | 113.91 | 682400.0 |
| 2001-08-31 13:00:00 | SPY | ETF | 113.95 | 114.29 | 113.84 | 114.17 | 799700.0 |
| 2001-08-31 13:30:00 | SPY | ETF | 114.15 | 114.2 | 113.92 | 114.09 | 364600.0 |
| 2001-08-31 14:00:00 | SPY | ETF | 114.09 | 114.2 | 113.94 | 114.03 | 720200.0 |
| 2001-08-31 14:30:00 | SPY | ETF | 114.03 | 114.11 | 113.72 | 113.72 | 510300.0 |
| 2001-08-31 15:00:00 | SPY | ETF | 113.7 | 113.82 | 113.61 | 113.72 | 1015300.0 |
| 2001-08-31 15:30:00 | SPY | ETF | 113.71 | 114.07 | 113.7 | 113.92 | 1365900.0 |
| 2001-08-31 16:00:00 | SPY | ETF | 113.9 | 114.2 | 113.88 | 114.2 | 599100.0 |
| 2001-08-31 16:30:00 | SPY | ETF | 114.15 | 114.3 | 114.15 | 114.3 | 102600.0 |
| 2001-08-31 17:00:00 | SPY | ETF | 114.18 | 114.18 | 114.18 | 114.18 | 500.0 |
| 2001-08-31 17:30:00 | SPY | ETF | 114.21 | 114.21 | 114.15 | 114.15 | 300.0 |
| 2001-08-31 09:30:00 | QQQ | ETF | 36.03 | 36.32 | 35.94 | 36.06 | 8462800.0 |
| 2001-08-31 10:00:00 | QQQ | ETF | 36.06 | 37.03 | 36.03 | 36.7 | 12929400.0 |
| 2001-08-31 10:30:00 | QQQ | ETF | 36.7 | 36.8 | 36.37 | 36.4 | 5188900.0 |
| 2001-08-31 11:00:00 | QQQ | ETF | 36.39 | 36.62 | 36.35 | 36.58 | 3664900.0 |
| 2001-08-31 11:30:00 | QQQ | ETF | 36.57 | 36.63 | 36.2 | 36.24 | 2486100.0 |
| 2001-08-31 12:00:00 | QQQ | ETF | 36.24 | 36.55 | 36.11 | 36.43 | 4182600.0 |
| 2001-08-31 12:30:00 | QQQ | ETF | 36.43 | 36.59 | 36.36 | 36.53 | 1442300.0 |
| 2001-08-31 13:00:00 | QQQ | ETF | 36.5 | 36.76 | 36.46 | 36.6 | 2316000.0 |
| 2001-08-31 13:30:00 | QQQ | ETF | 36.61 | 36.68 | 36.5 | 36.61 | 1019900.0 |
| 2001-08-31 14:00:00 | QQQ | ETF | 36.61 | 36.74 | 36.46 | 36.56 | 1712800.0 |
| 2001-08-31 14:30:00 | QQQ | ETF | 36.54 | 36.61 | 36.37 | 36.38 | 1352100.0 |
| 2001-08-31 15:00:00 | QQQ | ETF | 36.38 | 36.48 | 36.33 | 36.43 | 2036500.0 |
| 2001-08-31 15:30:00 | QQQ | ETF | 36.45 | 36.68 | 36.41 | 36.59 | 4569300.0 |
| 2001-08-31 16:00:00 | QQQ | ETF | 36.59 | 36.73 | 36.43 | 36.65 | 839100.0 |
| 2001-08-31 16:30:00 | QQQ | ETF | 36.65 | 36.69 | 36.63 | 36.63 | 16500.0 |
| 2001-08-31 17:00:00 | QQQ | ETF | 36.6 | 37.25 | 36.6 | 36.6 | 50400.0 |
| 2001-08-31 17:30:00 | QQQ | ETF | 36.58 | 36.73 | 36.55 | 36.6 | 6800.0 |
| 2001-08-31 18:00:00 | QQQ | ETF | 36.6 | 36.63 | 36.6 | 36.62 | 8700.0 |
| 2001-08-31 09:30:00 | IWM | ETF | 46.7 | 46.74 | 46.63 | 46.655 | 255800.0 |
| 2001-08-31 10:00:00 | IWM | ETF | 46.69 | 47.0 | 46.69 | 47.0 | 518200.0 |
| 2001-08-31 10:30:00 | IWM | ETF | 47.015 | 47.015 | 46.915 | 46.99 | 91800.0 |
| 2001-08-31 11:00:00 | IWM | ETF | 46.93 | 46.93 | 46.81 | 46.85 | 17600.0 |
| 2001-08-31 11:30:00 | IWM | ETF | 46.835 | 46.87 | 46.825 | 46.86 | 1200.0 |
| 2001-08-31 12:00:00 | IWM | ETF | 46.75 | 46.87 | 46.63 | 46.87 | 5000.0 |
| 2001-08-31 12:30:00 | IWM | ETF | 46.875 | 46.895 | 46.725 | 46.895 | 5800.0 |
| 2001-08-31 13:00:00 | IWM | ETF | 46.8 | 46.97 | 46.79 | 46.97 | 2200.0 |
| 2001-08-31 13:30:00 | IWM | ETF | 46.97 | 46.97 | 46.97 | 46.97 | 9000.0 |
| 2001-08-31 14:00:00 | IWM | ETF | 46.965 | 46.965 | 46.945 | 46.945 | 4200.0 |
| 2001-08-31 14:30:00 | IWM | ETF | 46.91 | 47.025 | 46.885 | 47.025 | 5800.0 |
| 2001-08-31 15:00:00 | IWM | ETF | 46.845 | 46.945 | 46.8 | 46.92 | 7400.0 |
| 2001-08-31 15:30:00 | IWM | ETF | 46.825 | 47.07 | 46.825 | 46.825 | 52600.0 |
| 2001-08-31 16:00:00 | IWM | ETF | 46.945 | 46.945 | 46.945 | 46.945 | 2000.0 |
| 2001-08-31 09:30:00 | DIA | ETF | 99.4 | 99.59 | 99.07 | 99.45 | 481000.0 |
> showing 50 of 380 rows — these rows as CSV