PREVIEW / etf_30min / 2001-10-23
file: by_date/etf_30min/2001/2001-10-23.parquet size: 17 KB rows: 428
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-10-23 09:30:00 | SPY | ETF | 109.96 | 109.99 | 108.95 | 109.4 | 2650800.0 |
| 2001-10-23 10:00:00 | SPY | ETF | 109.39 | 110.08 | 109.36 | 110.04 | 2456900.0 |
| 2001-10-23 10:30:00 | SPY | ETF | 110.01 | 110.28 | 109.8 | 109.98 | 2323400.0 |
| 2001-10-23 11:00:00 | SPY | ETF | 109.97 | 110.13 | 109.79 | 110.11 | 776600.0 |
| 2001-10-23 11:30:00 | SPY | ETF | 110.13 | 110.15 | 109.35 | 109.38 | 1725900.0 |
| 2001-10-23 12:00:00 | SPY | ETF | 109.4 | 109.48 | 108.87 | 109.09 | 1234600.0 |
| 2001-10-23 12:30:00 | SPY | ETF | 109.1 | 109.35 | 108.82 | 109.12 | 1716400.0 |
| 2001-10-23 13:00:00 | SPY | ETF | 109.12 | 109.2 | 108.84 | 109.0 | 739200.0 |
| 2001-10-23 13:30:00 | SPY | ETF | 109.05 | 109.31 | 108.95 | 109.28 | 575500.0 |
| 2001-10-23 14:00:00 | SPY | ETF | 109.23 | 109.29 | 108.51 | 108.75 | 843800.0 |
| 2001-10-23 14:30:00 | SPY | ETF | 108.73 | 108.85 | 108.47 | 108.65 | 1139600.0 |
| 2001-10-23 15:00:00 | SPY | ETF | 108.63 | 109.08 | 108.46 | 109.03 | 1548800.0 |
| 2001-10-23 15:30:00 | SPY | ETF | 109.0 | 109.18 | 108.37 | 108.8 | 1762600.0 |
| 2001-10-23 16:00:00 | SPY | ETF | 108.72 | 108.99 | 108.72 | 108.9 | 1175400.0 |
| 2001-10-23 16:30:00 | SPY | ETF | 108.9 | 108.95 | 108.8 | 108.9 | 32700.0 |
| 2001-10-23 17:00:00 | SPY | ETF | 108.96 | 109.0 | 108.9 | 108.9 | 1900.0 |
| 2001-10-23 09:30:00 | QQQ | ETF | 34.82 | 34.91 | 34.45 | 34.86 | 12354200.0 |
| 2001-10-23 10:00:00 | QQQ | ETF | 34.89 | 35.35 | 34.8 | 35.28 | 12884700.0 |
| 2001-10-23 10:30:00 | QQQ | ETF | 35.27 | 35.4 | 35.06 | 35.2 | 9337100.0 |
| 2001-10-23 11:00:00 | QQQ | ETF | 35.2 | 35.33 | 35.06 | 35.28 | 3595100.0 |
| 2001-10-23 11:30:00 | QQQ | ETF | 35.29 | 35.29 | 34.85 | 34.89 | 6485500.0 |
| 2001-10-23 12:00:00 | QQQ | ETF | 34.9 | 34.98 | 34.6 | 34.71 | 6784100.0 |
| 2001-10-23 12:30:00 | QQQ | ETF | 34.71 | 34.93 | 34.54 | 34.8 | 7101000.0 |
| 2001-10-23 13:00:00 | QQQ | ETF | 34.8 | 34.88 | 34.55 | 34.73 | 3175300.0 |
| 2001-10-23 13:30:00 | QQQ | ETF | 34.73 | 34.99 | 34.67 | 34.97 | 5333200.0 |
| 2001-10-23 14:00:00 | QQQ | ETF | 34.94 | 34.96 | 34.4 | 34.52 | 5332400.0 |
| 2001-10-23 14:30:00 | QQQ | ETF | 34.52 | 34.54 | 34.23 | 34.33 | 8441500.0 |
| 2001-10-23 15:00:00 | QQQ | ETF | 34.33 | 34.64 | 34.12 | 34.61 | 6837500.0 |
| 2001-10-23 15:30:00 | QQQ | ETF | 34.6 | 34.7 | 34.2 | 34.56 | 9996600.0 |
| 2001-10-23 16:00:00 | QQQ | ETF | 34.54 | 34.64 | 34.25 | 34.58 | 1181600.0 |
| 2001-10-23 16:30:00 | QQQ | ETF | 34.57 | 34.64 | 34.46 | 34.51 | 497300.0 |
| 2001-10-23 17:00:00 | QQQ | ETF | 34.52 | 34.6 | 34.48 | 34.51 | 28100.0 |
| 2001-10-23 17:30:00 | QQQ | ETF | 34.51 | 34.57 | 34.5 | 34.51 | 7800.0 |
| 2001-10-23 18:00:00 | QQQ | ETF | 34.5 | 34.54 | 34.47 | 34.54 | 18100.0 |
| 2001-10-23 09:30:00 | IWM | ETF | 43.005 | 43.145 | 42.71 | 42.79 | 49800.0 |
| 2001-10-23 10:00:00 | IWM | ETF | 42.805 | 43.0 | 42.805 | 43.0 | 104400.0 |
| 2001-10-23 10:30:00 | IWM | ETF | 43.06 | 43.06 | 42.975 | 42.98 | 32200.0 |
| 2001-10-23 11:00:00 | IWM | ETF | 42.93 | 43.02 | 42.925 | 43.015 | 47600.0 |
| 2001-10-23 11:30:00 | IWM | ETF | 43.025 | 43.025 | 42.84 | 42.855 | 13000.0 |
| 2001-10-23 12:00:00 | IWM | ETF | 42.79 | 42.79 | 42.75 | 42.75 | 40200.0 |
| 2001-10-23 12:30:00 | IWM | ETF | 42.74 | 42.765 | 42.715 | 42.715 | 6600.0 |
| 2001-10-23 13:00:00 | IWM | ETF | 42.785 | 42.785 | 42.675 | 42.675 | 40400.0 |
| 2001-10-23 13:30:00 | IWM | ETF | 42.715 | 42.835 | 42.715 | 42.825 | 8600.0 |
| 2001-10-23 14:00:00 | IWM | ETF | 42.78 | 42.8 | 42.745 | 42.8 | 61400.0 |
| 2001-10-23 14:30:00 | IWM | ETF | 42.725 | 42.725 | 42.585 | 42.6 | 95800.0 |
| 2001-10-23 15:00:00 | IWM | ETF | 42.65 | 42.65 | 42.5 | 42.585 | 128400.0 |
| 2001-10-23 15:30:00 | IWM | ETF | 42.625 | 42.705 | 42.5 | 42.5 | 179600.0 |
| 2001-10-23 16:00:00 | IWM | ETF | 42.5 | 42.505 | 42.4 | 42.4 | 32800.0 |
| 2001-10-23 09:30:00 | DIA | ETF | 94.4 | 94.45 | 93.58 | 93.79 | 548700.0 |
| 2001-10-23 10:00:00 | DIA | ETF | 93.8 | 94.4 | 93.8 | 94.3 | 481800.0 |
> showing 50 of 428 rows — these rows as CSV