PREVIEW / etf_30min / 2001-11-21
file: by_date/etf_30min/2001/2001-11-21.parquet size: 16 KB rows: 427
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-21 09:30:00 | SPY | ETF | 114.5 | 114.67 | 114.18 | 114.4 | 2260200.0 |
| 2001-11-21 10:00:00 | SPY | ETF | 114.39 | 114.64 | 114.12 | 114.3 | 1095300.0 |
| 2001-11-21 10:30:00 | SPY | ETF | 114.26 | 114.3 | 113.66 | 113.84 | 1214600.0 |
| 2001-11-21 11:00:00 | SPY | ETF | 113.81 | 113.97 | 113.71 | 113.88 | 486700.0 |
| 2001-11-21 11:30:00 | SPY | ETF | 113.9 | 114.04 | 113.73 | 113.75 | 622900.0 |
| 2001-11-21 12:00:00 | SPY | ETF | 113.73 | 114.04 | 113.71 | 113.94 | 964800.0 |
| 2001-11-21 12:30:00 | SPY | ETF | 113.97 | 114.07 | 113.7 | 113.73 | 617100.0 |
| 2001-11-21 13:00:00 | SPY | ETF | 113.72 | 113.94 | 113.51 | 113.94 | 694600.0 |
| 2001-11-21 13:30:00 | SPY | ETF | 113.9 | 114.25 | 113.86 | 114.24 | 924200.0 |
| 2001-11-21 14:00:00 | SPY | ETF | 114.24 | 114.29 | 113.88 | 114.08 | 553800.0 |
| 2001-11-21 14:30:00 | SPY | ETF | 114.08 | 114.12 | 113.8 | 113.97 | 331300.0 |
| 2001-11-21 15:00:00 | SPY | ETF | 113.98 | 114.0 | 113.68 | 113.98 | 334500.0 |
| 2001-11-21 15:30:00 | SPY | ETF | 113.95 | 114.22 | 113.85 | 114.15 | 692800.0 |
| 2001-11-21 16:00:00 | SPY | ETF | 114.12 | 114.45 | 113.9 | 114.45 | 546000.0 |
| 2001-11-21 17:00:00 | SPY | ETF | 114.4 | 114.4 | 114.25 | 114.25 | 900.0 |
| 2001-11-21 09:30:00 | QQQ | ETF | 38.47 | 38.76 | 38.47 | 38.68 | 12004500.0 |
| 2001-11-21 10:00:00 | QQQ | ETF | 38.65 | 38.95 | 38.43 | 38.53 | 8619700.0 |
| 2001-11-21 10:30:00 | QQQ | ETF | 38.51 | 38.55 | 37.98 | 38.15 | 9371400.0 |
| 2001-11-21 11:00:00 | QQQ | ETF | 38.15 | 38.33 | 38.02 | 38.25 | 5303100.0 |
| 2001-11-21 11:30:00 | QQQ | ETF | 38.27 | 38.4 | 38.15 | 38.17 | 2799600.0 |
| 2001-11-21 12:00:00 | QQQ | ETF | 38.17 | 38.34 | 38.11 | 38.25 | 1715100.0 |
| 2001-11-21 12:30:00 | QQQ | ETF | 38.22 | 38.3 | 38.1 | 38.13 | 1549400.0 |
| 2001-11-21 13:00:00 | QQQ | ETF | 38.13 | 38.53 | 38.05 | 38.48 | 3911600.0 |
| 2001-11-21 13:30:00 | QQQ | ETF | 38.49 | 38.74 | 38.41 | 38.72 | 4198800.0 |
| 2001-11-21 14:00:00 | QQQ | ETF | 38.72 | 38.76 | 38.48 | 38.63 | 2628500.0 |
| 2001-11-21 14:30:00 | QQQ | ETF | 38.68 | 38.73 | 38.4 | 38.54 | 2218800.0 |
| 2001-11-21 15:00:00 | QQQ | ETF | 38.53 | 38.55 | 38.3 | 38.51 | 2384200.0 |
| 2001-11-21 15:30:00 | QQQ | ETF | 38.51 | 38.66 | 38.45 | 38.66 | 2863900.0 |
| 2001-11-21 16:00:00 | QQQ | ETF | 38.68 | 38.73 | 38.46 | 38.63 | 676200.0 |
| 2001-11-21 16:30:00 | QQQ | ETF | 38.65 | 39.0 | 38.6 | 38.8 | 202800.0 |
| 2001-11-21 17:00:00 | QQQ | ETF | 38.82 | 38.82 | 38.73 | 38.79 | 23700.0 |
| 2001-11-21 17:30:00 | QQQ | ETF | 38.78 | 38.8 | 38.75 | 38.76 | 14700.0 |
| 2001-11-21 18:00:00 | QQQ | ETF | 38.75 | 38.75 | 38.6 | 38.61 | 41100.0 |
| 2001-11-21 09:30:00 | IWM | ETF | 45.15 | 45.225 | 45.0 | 45.01 | 28000.0 |
| 2001-11-21 10:00:00 | IWM | ETF | 45.09 | 45.175 | 45.0 | 45.14 | 27400.0 |
| 2001-11-21 10:30:00 | IWM | ETF | 45.025 | 45.14 | 44.68 | 44.9 | 36400.0 |
| 2001-11-21 11:00:00 | IWM | ETF | 44.875 | 44.94 | 44.875 | 44.94 | 4800.0 |
| 2001-11-21 11:30:00 | IWM | ETF | 44.755 | 44.975 | 44.755 | 44.86 | 26600.0 |
| 2001-11-21 12:00:00 | IWM | ETF | 44.92 | 44.92 | 44.73 | 44.745 | 1600.0 |
| 2001-11-21 12:30:00 | IWM | ETF | 44.945 | 44.945 | 44.78 | 44.92 | 600.0 |
| 2001-11-21 13:00:00 | IWM | ETF | 44.9 | 44.92 | 44.81 | 44.92 | 3600.0 |
| 2001-11-21 13:30:00 | IWM | ETF | 44.94 | 45.01 | 44.94 | 45.01 | 68400.0 |
| 2001-11-21 14:00:00 | IWM | ETF | 45.035 | 45.065 | 44.895 | 45.025 | 100400.0 |
| 2001-11-21 14:30:00 | IWM | ETF | 45.04 | 45.04 | 44.91 | 44.91 | 63400.0 |
| 2001-11-21 15:00:00 | IWM | ETF | 45.015 | 45.015 | 44.905 | 45.015 | 2600.0 |
| 2001-11-21 15:30:00 | IWM | ETF | 44.95 | 45.085 | 44.895 | 45.085 | 14800.0 |
| 2001-11-21 09:30:00 | DIA | ETF | 99.1 | 99.1 | 98.6 | 98.75 | 622400.0 |
| 2001-11-21 10:00:00 | DIA | ETF | 98.75 | 98.96 | 98.55 | 98.75 | 701500.0 |
| 2001-11-21 10:30:00 | DIA | ETF | 98.67 | 98.78 | 98.3 | 98.4 | 291900.0 |
| 2001-11-21 11:00:00 | DIA | ETF | 98.45 | 98.54 | 98.31 | 98.34 | 351600.0 |
> showing 50 of 427 rows — these rows as CSV