PREVIEW / etf_30min / 2001-08-14
file: by_date/etf_30min/2001/2001-08-14.parquet size: 14 KB rows: 360
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-08-14 09:30:00 | SPY | ETF | 120.14 | 120.35 | 119.86 | 120.2 | 2499500.0 |
| 2001-08-14 10:00:00 | SPY | ETF | 120.2 | 120.22 | 119.69 | 119.75 | 1391100.0 |
| 2001-08-14 10:30:00 | SPY | ETF | 119.71 | 119.82 | 119.3 | 119.56 | 1102200.0 |
| 2001-08-14 11:00:00 | SPY | ETF | 119.53 | 119.65 | 119.44 | 119.44 | 443900.0 |
| 2001-08-14 11:30:00 | SPY | ETF | 119.5 | 119.76 | 119.42 | 119.56 | 340300.0 |
| 2001-08-14 12:00:00 | SPY | ETF | 119.55 | 119.71 | 119.45 | 119.7 | 356400.0 |
| 2001-08-14 12:30:00 | SPY | ETF | 119.71 | 119.78 | 119.55 | 119.56 | 181900.0 |
| 2001-08-14 13:00:00 | SPY | ETF | 119.53 | 119.56 | 119.19 | 119.3 | 340400.0 |
| 2001-08-14 13:30:00 | SPY | ETF | 119.29 | 119.35 | 119.06 | 119.35 | 770100.0 |
| 2001-08-14 14:00:00 | SPY | ETF | 119.33 | 119.4 | 119.2 | 119.21 | 178300.0 |
| 2001-08-14 14:30:00 | SPY | ETF | 119.18 | 119.52 | 119.16 | 119.26 | 515700.0 |
| 2001-08-14 15:00:00 | SPY | ETF | 119.29 | 119.36 | 119.08 | 119.12 | 317000.0 |
| 2001-08-14 15:30:00 | SPY | ETF | 119.15 | 119.22 | 118.8 | 119.11 | 1753300.0 |
| 2001-08-14 16:00:00 | SPY | ETF | 119.11 | 119.35 | 119.02 | 119.27 | 642400.0 |
| 2001-08-14 16:30:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 50000.0 |
| 2001-08-14 17:00:00 | SPY | ETF | 119.3 | 119.35 | 119.3 | 119.35 | 1000.0 |
| 2001-08-14 09:30:00 | QQQ | ETF | 41.49 | 41.63 | 41.26 | 41.56 | 8469400.0 |
| 2001-08-14 10:00:00 | QQQ | ETF | 41.56 | 41.7 | 41.27 | 41.31 | 4541500.0 |
| 2001-08-14 10:30:00 | QQQ | ETF | 41.32 | 41.38 | 40.92 | 41.11 | 5155900.0 |
| 2001-08-14 11:00:00 | QQQ | ETF | 41.13 | 41.21 | 40.97 | 41.03 | 3896100.0 |
| 2001-08-14 11:30:00 | QQQ | ETF | 41.05 | 41.23 | 40.98 | 41.15 | 2111900.0 |
| 2001-08-14 12:00:00 | QQQ | ETF | 41.14 | 41.2 | 41.03 | 41.17 | 1031000.0 |
| 2001-08-14 12:30:00 | QQQ | ETF | 41.17 | 41.39 | 41.13 | 41.23 | 1805300.0 |
| 2001-08-14 13:00:00 | QQQ | ETF | 41.26 | 41.26 | 40.97 | 41.0 | 2939500.0 |
| 2001-08-14 13:30:00 | QQQ | ETF | 41.0 | 41.02 | 40.74 | 40.94 | 3602000.0 |
| 2001-08-14 14:00:00 | QQQ | ETF | 40.95 | 41.07 | 40.85 | 40.88 | 3527900.0 |
| 2001-08-14 14:30:00 | QQQ | ETF | 40.95 | 41.15 | 40.87 | 40.91 | 2229900.0 |
| 2001-08-14 15:00:00 | QQQ | ETF | 40.93 | 40.99 | 40.77 | 40.83 | 2381700.0 |
| 2001-08-14 15:30:00 | QQQ | ETF | 40.81 | 40.9 | 40.54 | 40.66 | 4947300.0 |
| 2001-08-14 16:00:00 | QQQ | ETF | 40.64 | 41.03 | 40.54 | 40.65 | 2332500.0 |
| 2001-08-14 16:30:00 | QQQ | ETF | 40.61 | 40.68 | 40.0 | 40.55 | 157300.0 |
| 2001-08-14 17:00:00 | QQQ | ETF | 40.55 | 40.75 | 40.55 | 40.75 | 83500.0 |
| 2001-08-14 17:30:00 | QQQ | ETF | 40.75 | 40.85 | 40.66 | 40.85 | 127000.0 |
| 2001-08-14 18:00:00 | QQQ | ETF | 40.78 | 40.95 | 40.75 | 40.9 | 110000.0 |
| 2001-08-14 09:30:00 | IWM | ETF | 47.775 | 47.85 | 47.725 | 47.85 | 11200.0 |
| 2001-08-14 10:00:00 | IWM | ETF | 47.85 | 47.86 | 47.755 | 47.755 | 1400.0 |
| 2001-08-14 10:30:00 | IWM | ETF | 47.86 | 48.075 | 47.8 | 47.975 | 1424200.0 |
| 2001-08-14 11:00:00 | IWM | ETF | 47.975 | 48.1 | 47.975 | 48.025 | 1103600.0 |
| 2001-08-14 11:30:00 | IWM | ETF | 48.0 | 48.175 | 47.985 | 48.175 | 422600.0 |
| 2001-08-14 12:00:00 | IWM | ETF | 48.025 | 48.17 | 48.025 | 48.17 | 317200.0 |
| 2001-08-14 12:30:00 | IWM | ETF | 48.17 | 48.2 | 48.17 | 48.175 | 73000.0 |
| 2001-08-14 13:00:00 | IWM | ETF | 48.115 | 48.115 | 48.01 | 48.075 | 6000.0 |
| 2001-08-14 13:30:00 | IWM | ETF | 48.075 | 48.075 | 47.95 | 47.995 | 59400.0 |
| 2001-08-14 14:00:00 | IWM | ETF | 47.995 | 48.1 | 47.995 | 48.025 | 79400.0 |
| 2001-08-14 14:30:00 | IWM | ETF | 48.04 | 48.075 | 47.915 | 47.915 | 6000.0 |
| 2001-08-14 15:00:00 | IWM | ETF | 47.975 | 47.975 | 47.875 | 47.975 | 21800.0 |
| 2001-08-14 15:30:00 | IWM | ETF | 47.945 | 47.95 | 47.71 | 47.85 | 142000.0 |
| 2001-08-14 09:30:00 | DIA | ETF | 104.5 | 104.97 | 104.5 | 104.83 | 207700.0 |
| 2001-08-14 10:00:00 | DIA | ETF | 104.83 | 104.86 | 104.36 | 104.38 | 216400.0 |
| 2001-08-14 10:30:00 | DIA | ETF | 104.36 | 104.43 | 104.02 | 104.26 | 175600.0 |
> showing 50 of 360 rows — these rows as CSV