PREVIEW / etf_30min / 2001-11-14
file: by_date/etf_30min/2001/2001-11-14.parquet size: 17 KB rows: 457
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-14 09:30:00 | SPY | ETF | 115.17 | 115.4 | 114.88 | 114.9 | 3736900.0 |
| 2001-11-14 10:00:00 | SPY | ETF | 114.88 | 114.92 | 114.31 | 114.54 | 1784400.0 |
| 2001-11-14 10:30:00 | SPY | ETF | 114.56 | 114.65 | 113.71 | 113.95 | 1459600.0 |
| 2001-11-14 11:00:00 | SPY | ETF | 113.99 | 114.5 | 113.92 | 114.44 | 1092300.0 |
| 2001-11-14 11:30:00 | SPY | ETF | 114.45 | 114.58 | 114.28 | 114.56 | 852800.0 |
| 2001-11-14 12:00:00 | SPY | ETF | 114.54 | 114.56 | 114.22 | 114.4 | 412600.0 |
| 2001-11-14 12:30:00 | SPY | ETF | 114.39 | 114.5 | 114.11 | 114.14 | 615400.0 |
| 2001-11-14 13:00:00 | SPY | ETF | 114.11 | 114.3 | 114.0 | 114.13 | 560500.0 |
| 2001-11-14 13:30:00 | SPY | ETF | 114.13 | 114.27 | 113.96 | 114.17 | 700000.0 |
| 2001-11-14 14:00:00 | SPY | ETF | 114.17 | 114.34 | 113.91 | 114.19 | 712200.0 |
| 2001-11-14 14:30:00 | SPY | ETF | 114.17 | 114.77 | 114.07 | 114.7 | 1658200.0 |
| 2001-11-14 15:00:00 | SPY | ETF | 114.7 | 115.0 | 114.5 | 114.84 | 1582800.0 |
| 2001-11-14 15:30:00 | SPY | ETF | 114.84 | 114.9 | 114.31 | 114.62 | 1577700.0 |
| 2001-11-14 16:00:00 | SPY | ETF | 114.59 | 114.78 | 114.53 | 114.78 | 720000.0 |
| 2001-11-14 16:30:00 | SPY | ETF | 114.65 | 114.65 | 114.5 | 114.5 | 20600.0 |
| 2001-11-14 17:00:00 | SPY | ETF | 114.49 | 114.6 | 114.39 | 114.54 | 7700.0 |
| 2001-11-14 17:30:00 | SPY | ETF | 114.6 | 114.61 | 114.35 | 114.59 | 14000.0 |
| 2001-11-14 18:00:00 | SPY | ETF | 114.46 | 114.59 | 114.35 | 114.59 | 4100.0 |
| 2001-11-14 09:30:00 | QQQ | ETF | 39.96 | 40.24 | 39.72 | 39.75 | 15543200.0 |
| 2001-11-14 10:00:00 | QQQ | ETF | 39.73 | 39.8 | 39.3 | 39.46 | 11937300.0 |
| 2001-11-14 10:30:00 | QQQ | ETF | 39.46 | 39.57 | 38.74 | 38.96 | 9144100.0 |
| 2001-11-14 11:00:00 | QQQ | ETF | 38.96 | 39.43 | 38.95 | 39.37 | 6632900.0 |
| 2001-11-14 11:30:00 | QQQ | ETF | 39.36 | 39.45 | 39.14 | 39.39 | 3881000.0 |
| 2001-11-14 12:00:00 | QQQ | ETF | 39.38 | 39.4 | 39.07 | 39.19 | 3628100.0 |
| 2001-11-14 12:30:00 | QQQ | ETF | 39.19 | 39.29 | 38.96 | 38.97 | 3543000.0 |
| 2001-11-14 13:00:00 | QQQ | ETF | 38.99 | 39.18 | 38.9 | 38.96 | 2873500.0 |
| 2001-11-14 13:30:00 | QQQ | ETF | 39.0 | 39.1 | 38.82 | 39.03 | 3371600.0 |
| 2001-11-14 14:00:00 | QQQ | ETF | 39.02 | 39.24 | 38.9 | 39.16 | 3967800.0 |
| 2001-11-14 14:30:00 | QQQ | ETF | 39.17 | 39.57 | 39.09 | 39.51 | 6388100.0 |
| 2001-11-14 15:00:00 | QQQ | ETF | 39.5 | 39.83 | 39.32 | 39.68 | 7563800.0 |
| 2001-11-14 15:30:00 | QQQ | ETF | 39.69 | 39.75 | 39.31 | 39.5 | 7317900.0 |
| 2001-11-14 16:00:00 | QQQ | ETF | 39.49 | 39.68 | 39.41 | 39.52 | 1362000.0 |
| 2001-11-14 16:30:00 | QQQ | ETF | 39.56 | 39.58 | 39.28 | 39.3 | 211800.0 |
| 2001-11-14 17:00:00 | QQQ | ETF | 39.29 | 39.39 | 39.25 | 39.32 | 134700.0 |
| 2001-11-14 17:30:00 | QQQ | ETF | 39.33 | 39.44 | 39.28 | 39.32 | 73500.0 |
| 2001-11-14 18:00:00 | QQQ | ETF | 39.32 | 39.4 | 39.25 | 39.25 | 34600.0 |
| 2001-11-14 09:30:00 | IWM | ETF | 45.0 | 45.085 | 44.83 | 44.885 | 103400.0 |
| 2001-11-14 10:00:00 | IWM | ETF | 44.88 | 44.88 | 44.69 | 44.74 | 27000.0 |
| 2001-11-14 10:30:00 | IWM | ETF | 44.74 | 44.84 | 44.62 | 44.645 | 11800.0 |
| 2001-11-14 11:00:00 | IWM | ETF | 44.65 | 44.82 | 44.64 | 44.81 | 28600.0 |
| 2001-11-14 11:30:00 | IWM | ETF | 44.81 | 44.875 | 44.77 | 44.835 | 10400.0 |
| 2001-11-14 12:00:00 | IWM | ETF | 44.84 | 44.87 | 44.77 | 44.79 | 9800.0 |
| 2001-11-14 12:30:00 | IWM | ETF | 44.79 | 44.85 | 44.74 | 44.755 | 6800.0 |
| 2001-11-14 13:00:00 | IWM | ETF | 44.755 | 44.77 | 44.75 | 44.75 | 7600.0 |
| 2001-11-14 13:30:00 | IWM | ETF | 44.74 | 44.79 | 44.71 | 44.79 | 2800.0 |
| 2001-11-14 14:00:00 | IWM | ETF | 44.74 | 44.82 | 44.74 | 44.76 | 14800.0 |
| 2001-11-14 14:30:00 | IWM | ETF | 44.83 | 44.94 | 44.775 | 44.94 | 17600.0 |
| 2001-11-14 15:00:00 | IWM | ETF | 45.0 | 45.105 | 44.91 | 45.08 | 9600.0 |
| 2001-11-14 15:30:00 | IWM | ETF | 45.08 | 45.09 | 44.85 | 45.05 | 26200.0 |
| 2001-11-14 16:00:00 | IWM | ETF | 44.975 | 45.12 | 44.975 | 45.12 | 4800.0 |
> showing 50 of 457 rows — these rows as CSV