PREVIEW / etf_30min / 2001-12-07
file: by_date/etf_30min/2001/2001-12-07.parquet size: 17 KB rows: 450
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-12-07 09:30:00 | SPY | ETF | 116.9 | 116.9 | 116.48 | 116.66 | 2344600.0 |
| 2001-12-07 10:00:00 | SPY | ETF | 116.61 | 116.96 | 116.51 | 116.76 | 2064400.0 |
| 2001-12-07 10:30:00 | SPY | ETF | 116.78 | 117.09 | 116.62 | 116.97 | 743000.0 |
| 2001-12-07 11:00:00 | SPY | ETF | 116.97 | 117.06 | 116.51 | 116.72 | 2207800.0 |
| 2001-12-07 11:30:00 | SPY | ETF | 116.73 | 116.75 | 116.14 | 116.33 | 866000.0 |
| 2001-12-07 12:00:00 | SPY | ETF | 116.3 | 116.46 | 116.17 | 116.22 | 2616600.0 |
| 2001-12-07 12:30:00 | SPY | ETF | 116.17 | 116.33 | 116.12 | 116.27 | 606500.0 |
| 2001-12-07 13:00:00 | SPY | ETF | 116.28 | 116.54 | 116.23 | 116.51 | 510400.0 |
| 2001-12-07 13:30:00 | SPY | ETF | 116.55 | 116.55 | 116.02 | 116.02 | 745700.0 |
| 2001-12-07 14:00:00 | SPY | ETF | 116.1 | 116.1 | 115.75 | 115.97 | 1699100.0 |
| 2001-12-07 14:30:00 | SPY | ETF | 116.0 | 116.2 | 115.7 | 116.1 | 1232200.0 |
| 2001-12-07 15:00:00 | SPY | ETF | 116.07 | 116.39 | 115.97 | 116.33 | 812500.0 |
| 2001-12-07 15:30:00 | SPY | ETF | 116.33 | 116.49 | 116.15 | 116.45 | 1189000.0 |
| 2001-12-07 16:00:00 | SPY | ETF | 116.42 | 116.62 | 116.19 | 116.56 | 1134800.0 |
| 2001-12-07 16:30:00 | SPY | ETF | 116.42 | 116.5 | 116.42 | 116.5 | 52000.0 |
| 2001-12-07 17:30:00 | SPY | ETF | 116.45 | 116.45 | 116.4 | 116.4 | 200.0 |
| 2001-12-07 09:30:00 | QQQ | ETF | 42.48 | 42.6 | 42.15 | 42.34 | 11906700.0 |
| 2001-12-07 10:00:00 | QQQ | ETF | 42.34 | 42.51 | 42.16 | 42.31 | 9179800.0 |
| 2001-12-07 10:30:00 | QQQ | ETF | 42.32 | 42.5 | 42.22 | 42.42 | 4905600.0 |
| 2001-12-07 11:00:00 | QQQ | ETF | 42.43 | 42.53 | 42.15 | 42.27 | 4560800.0 |
| 2001-12-07 11:30:00 | QQQ | ETF | 42.27 | 42.3 | 41.8 | 41.91 | 6609700.0 |
| 2001-12-07 12:00:00 | QQQ | ETF | 41.9 | 41.98 | 41.72 | 41.75 | 3485600.0 |
| 2001-12-07 12:30:00 | QQQ | ETF | 41.75 | 41.86 | 41.7 | 41.85 | 2502900.0 |
| 2001-12-07 13:00:00 | QQQ | ETF | 41.84 | 42.04 | 41.78 | 42.01 | 3322100.0 |
| 2001-12-07 13:30:00 | QQQ | ETF | 42.01 | 42.04 | 41.65 | 41.65 | 4326600.0 |
| 2001-12-07 14:00:00 | QQQ | ETF | 41.65 | 41.75 | 41.3 | 41.41 | 7589000.0 |
| 2001-12-07 14:30:00 | QQQ | ETF | 41.41 | 41.49 | 41.14 | 41.42 | 7288900.0 |
| 2001-12-07 15:00:00 | QQQ | ETF | 41.41 | 41.7 | 41.3 | 41.65 | 4843900.0 |
| 2001-12-07 15:30:00 | QQQ | ETF | 41.66 | 41.93 | 41.56 | 41.72 | 7808400.0 |
| 2001-12-07 16:00:00 | QQQ | ETF | 41.73 | 41.84 | 41.7 | 41.79 | 1576400.0 |
| 2001-12-07 16:30:00 | QQQ | ETF | 41.7 | 41.8 | 41.7 | 41.77 | 476200.0 |
| 2001-12-07 17:00:00 | QQQ | ETF | 41.76 | 41.8 | 41.76 | 41.8 | 7600.0 |
| 2001-12-07 17:30:00 | QQQ | ETF | 41.8 | 41.85 | 41.7 | 41.8 | 11600.0 |
| 2001-12-07 18:00:00 | QQQ | ETF | 41.8 | 41.85 | 41.8 | 41.85 | 3400.0 |
| 2001-12-07 09:30:00 | IWM | ETF | 48.075 | 48.075 | 47.85 | 47.915 | 62200.0 |
| 2001-12-07 10:00:00 | IWM | ETF | 47.89 | 48.07 | 47.78 | 48.01 | 16400.0 |
| 2001-12-07 10:30:00 | IWM | ETF | 48.0 | 48.19 | 47.975 | 48.19 | 9600.0 |
| 2001-12-07 11:00:00 | IWM | ETF | 48.185 | 48.24 | 47.93 | 47.96 | 46400.0 |
| 2001-12-07 11:30:00 | IWM | ETF | 48.085 | 48.115 | 47.925 | 47.94 | 9800.0 |
| 2001-12-07 12:00:00 | IWM | ETF | 47.945 | 47.995 | 47.85 | 47.995 | 11200.0 |
| 2001-12-07 12:30:00 | IWM | ETF | 47.875 | 48.05 | 47.85 | 48.05 | 23400.0 |
| 2001-12-07 13:00:00 | IWM | ETF | 48.03 | 48.145 | 47.945 | 48.145 | 26000.0 |
| 2001-12-07 13:30:00 | IWM | ETF | 48.15 | 48.175 | 47.955 | 48.12 | 15000.0 |
| 2001-12-07 14:00:00 | IWM | ETF | 47.95 | 48.05 | 47.875 | 48.04 | 37800.0 |
| 2001-12-07 14:30:00 | IWM | ETF | 48.09 | 48.09 | 47.825 | 48.0 | 40000.0 |
| 2001-12-07 15:00:00 | IWM | ETF | 47.905 | 48.0 | 47.83 | 48.0 | 127000.0 |
| 2001-12-07 15:30:00 | IWM | ETF | 47.975 | 48.15 | 47.875 | 48.06 | 99000.0 |
| 2001-12-07 16:00:00 | IWM | ETF | 48.055 | 48.055 | 47.885 | 47.885 | 1800.0 |
| 2001-12-07 09:30:00 | DIA | ETF | 100.82 | 101.0 | 100.6 | 100.87 | 444700.0 |
| 2001-12-07 10:00:00 | DIA | ETF | 100.85 | 101.06 | 100.67 | 100.91 | 126800.0 |
> showing 50 of 450 rows — these rows as CSV