PREVIEW / etf_30min / 2001-11-28
file: by_date/etf_30min/2001/2001-11-28.parquet size: 17 KB rows: 445
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-28 09:30:00 | SPY | ETF | 114.74 | 114.95 | 114.55 | 114.74 | 2169100.0 |
| 2001-11-28 10:00:00 | SPY | ETF | 114.75 | 114.93 | 114.25 | 114.8 | 1875500.0 |
| 2001-11-28 10:30:00 | SPY | ETF | 114.8 | 115.17 | 114.32 | 114.32 | 1852800.0 |
| 2001-11-28 11:00:00 | SPY | ETF | 114.38 | 114.65 | 114.3 | 114.5 | 1455200.0 |
| 2001-11-28 11:30:00 | SPY | ETF | 114.54 | 114.69 | 114.08 | 114.41 | 1280500.0 |
| 2001-11-28 12:00:00 | SPY | ETF | 114.37 | 114.68 | 114.31 | 114.59 | 729300.0 |
| 2001-11-28 12:30:00 | SPY | ETF | 114.57 | 114.66 | 114.16 | 114.16 | 558600.0 |
| 2001-11-28 13:00:00 | SPY | ETF | 114.16 | 114.49 | 114.08 | 114.27 | 670100.0 |
| 2001-11-28 13:30:00 | SPY | ETF | 114.28 | 114.6 | 114.0 | 114.2 | 962200.0 |
| 2001-11-28 14:00:00 | SPY | ETF | 114.23 | 114.23 | 113.65 | 114.01 | 1455200.0 |
| 2001-11-28 14:30:00 | SPY | ETF | 113.98 | 114.17 | 113.69 | 113.85 | 798200.0 |
| 2001-11-28 15:00:00 | SPY | ETF | 113.85 | 114.09 | 113.6 | 113.74 | 2301200.0 |
| 2001-11-28 15:30:00 | SPY | ETF | 113.8 | 113.9 | 113.25 | 113.34 | 2417300.0 |
| 2001-11-28 16:00:00 | SPY | ETF | 113.35 | 113.37 | 113.2 | 113.2 | 1339200.0 |
| 2001-11-28 16:30:00 | SPY | ETF | 113.0 | 113.35 | 113.0 | 113.34 | 30600.0 |
| 2001-11-28 17:00:00 | SPY | ETF | 113.25 | 113.27 | 113.25 | 113.25 | 2500.0 |
| 2001-11-28 17:30:00 | SPY | ETF | 113.39 | 113.39 | 113.39 | 113.39 | 25000.0 |
| 2001-11-28 09:30:00 | QQQ | ETF | 39.73 | 39.93 | 39.58 | 39.75 | 12195500.0 |
| 2001-11-28 10:00:00 | QQQ | ETF | 39.73 | 40.06 | 39.44 | 39.95 | 10138000.0 |
| 2001-11-28 10:30:00 | QQQ | ETF | 39.97 | 40.37 | 39.54 | 39.55 | 10545200.0 |
| 2001-11-28 11:00:00 | QQQ | ETF | 39.56 | 39.96 | 39.56 | 39.85 | 4391100.0 |
| 2001-11-28 11:30:00 | QQQ | ETF | 39.85 | 40.0 | 39.56 | 39.75 | 5458900.0 |
| 2001-11-28 12:00:00 | QQQ | ETF | 39.77 | 40.0 | 39.71 | 39.9 | 2879200.0 |
| 2001-11-28 12:30:00 | QQQ | ETF | 39.9 | 39.92 | 39.5 | 39.55 | 4193600.0 |
| 2001-11-28 13:00:00 | QQQ | ETF | 39.55 | 39.68 | 39.38 | 39.5 | 6222600.0 |
| 2001-11-28 13:30:00 | QQQ | ETF | 39.52 | 39.65 | 39.24 | 39.31 | 7299600.0 |
| 2001-11-28 14:00:00 | QQQ | ETF | 39.3 | 39.35 | 38.92 | 39.23 | 11152400.0 |
| 2001-11-28 14:30:00 | QQQ | ETF | 39.17 | 39.3 | 38.89 | 38.98 | 7147400.0 |
| 2001-11-28 15:00:00 | QQQ | ETF | 38.92 | 39.22 | 38.87 | 39.06 | 7354300.0 |
| 2001-11-28 15:30:00 | QQQ | ETF | 39.05 | 39.18 | 38.74 | 38.75 | 7491900.0 |
| 2001-11-28 16:00:00 | QQQ | ETF | 38.76 | 39.07 | 38.69 | 38.7 | 2441800.0 |
| 2001-11-28 16:30:00 | QQQ | ETF | 38.65 | 38.75 | 38.61 | 38.65 | 72200.0 |
| 2001-11-28 17:00:00 | QQQ | ETF | 38.66 | 38.66 | 38.6 | 38.65 | 627800.0 |
| 2001-11-28 17:30:00 | QQQ | ETF | 38.62 | 38.75 | 38.6 | 38.72 | 170200.0 |
| 2001-11-28 18:00:00 | QQQ | ETF | 38.71 | 38.8 | 38.7 | 38.74 | 93400.0 |
| 2001-11-28 09:30:00 | IWM | ETF | 45.6 | 45.8 | 45.535 | 45.695 | 19800.0 |
| 2001-11-28 10:00:00 | IWM | ETF | 45.46 | 45.675 | 45.375 | 45.675 | 307000.0 |
| 2001-11-28 10:30:00 | IWM | ETF | 45.775 | 45.87 | 45.55 | 45.55 | 9400.0 |
| 2001-11-28 11:00:00 | IWM | ETF | 45.645 | 45.685 | 45.5 | 45.65 | 3800.0 |
| 2001-11-28 11:30:00 | IWM | ETF | 45.66 | 45.75 | 45.53 | 45.725 | 35800.0 |
| 2001-11-28 12:00:00 | IWM | ETF | 45.745 | 45.75 | 45.55 | 45.665 | 13600.0 |
| 2001-11-28 12:30:00 | IWM | ETF | 45.75 | 45.75 | 45.565 | 45.595 | 11200.0 |
| 2001-11-28 13:00:00 | IWM | ETF | 45.525 | 45.625 | 45.525 | 45.625 | 14800.0 |
| 2001-11-28 13:30:00 | IWM | ETF | 45.615 | 45.615 | 45.545 | 45.585 | 6000.0 |
| 2001-11-28 14:00:00 | IWM | ETF | 45.52 | 45.545 | 45.425 | 45.465 | 13200.0 |
| 2001-11-28 14:30:00 | IWM | ETF | 45.455 | 45.485 | 45.435 | 45.47 | 44000.0 |
| 2001-11-28 15:00:00 | IWM | ETF | 45.42 | 45.465 | 45.34 | 45.375 | 53800.0 |
| 2001-11-28 15:30:00 | IWM | ETF | 45.385 | 45.385 | 45.1 | 45.1 | 83400.0 |
| 2001-11-28 16:00:00 | IWM | ETF | 45.1 | 45.1 | 45.005 | 45.025 | 19800.0 |
| 2001-11-28 09:30:00 | DIA | ETF | 98.42 | 98.42 | 97.95 | 98.09 | 348000.0 |
> showing 50 of 445 rows — these rows as CSV