PREVIEW / etf_30min / 2003-08-05
file: by_date/etf_30min/2003/2003-08-05.parquet size: 24 KB rows: 699
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-05 08:00:00 | SPY | ETF | 98.48 | 98.58 | 98.48 | 98.56 | 4300.0 |
| 2003-08-05 08:30:00 | SPY | ETF | 98.7 | 98.75 | 98.65 | 98.66 | 6700.0 |
| 2003-08-05 09:00:00 | SPY | ETF | 98.66 | 98.68 | 98.37 | 98.52 | 11500.0 |
| 2003-08-05 09:30:00 | SPY | ETF | 98.411 | 98.66 | 98.23 | 98.34 | 4168900.0 |
| 2003-08-05 10:00:00 | SPY | ETF | 98.35 | 98.76 | 97.85 | 98.08 | 6547100.0 |
| 2003-08-05 10:30:00 | SPY | ETF | 98.08 | 98.225 | 97.701 | 98.1 | 3553300.0 |
| 2003-08-05 11:00:00 | SPY | ETF | 98.09 | 98.13 | 97.83 | 98.01 | 1455600.0 |
| 2003-08-05 11:30:00 | SPY | ETF | 98.03 | 98.33 | 97.954 | 98.22 | 1688500.0 |
| 2003-08-05 12:00:00 | SPY | ETF | 98.21 | 98.46 | 98.14 | 98.3 | 842500.0 |
| 2003-08-05 12:30:00 | SPY | ETF | 98.31 | 98.37 | 98.04 | 98.15 | 1332300.0 |
| 2003-08-05 13:00:00 | SPY | ETF | 98.12 | 98.17 | 97.943 | 98.03 | 1465000.0 |
| 2003-08-05 13:30:00 | SPY | ETF | 98.01 | 98.21 | 97.81 | 97.89 | 1602900.0 |
| 2003-08-05 14:00:00 | SPY | ETF | 97.88 | 97.98 | 97.65 | 97.85 | 2470400.0 |
| 2003-08-05 14:30:00 | SPY | ETF | 97.8 | 98.05 | 97.57 | 97.75 | 5764300.0 |
| 2003-08-05 15:00:00 | SPY | ETF | 97.75 | 97.8 | 97.25 | 97.39 | 5934900.0 |
| 2003-08-05 15:30:00 | SPY | ETF | 97.39 | 97.42 | 96.84 | 96.85 | 10210000.0 |
| 2003-08-05 16:00:00 | SPY | ETF | 96.85 | 96.97 | 96.34 | 96.49 | 3786700.0 |
| 2003-08-05 16:30:00 | SPY | ETF | 96.49 | 98.6868 | 96.4 | 96.41 | 2149600.0 |
| 2003-08-05 17:00:00 | SPY | ETF | 96.4 | 96.91 | 96.38 | 96.44 | 551200.0 |
| 2003-08-05 17:30:00 | SPY | ETF | 96.42 | 96.47 | 96.37 | 96.43 | 127600.0 |
| 2003-08-05 18:00:00 | SPY | ETF | 96.42 | 96.47 | 96.4 | 96.44 | 27200.0 |
| 2003-08-05 18:30:00 | SPY | ETF | 96.4 | 96.47 | 96.4 | 96.47 | 800.0 |
| 2003-08-05 19:00:00 | SPY | ETF | 96.47 | 96.5 | 96.43 | 96.5 | 4700.0 |
| 2003-08-05 19:30:00 | SPY | ETF | 96.47 | 96.51 | 96.47 | 96.48 | 6900.0 |
| 2003-08-05 08:00:00 | QQQ | ETF | 31.44 | 31.46 | 31.4 | 31.46 | 18300.0 |
| 2003-08-05 08:30:00 | QQQ | ETF | 31.48 | 31.49 | 31.46 | 31.47 | 29700.0 |
| 2003-08-05 09:00:00 | QQQ | ETF | 31.46 | 31.46 | 31.39 | 31.42 | 65500.0 |
| 2003-08-05 09:30:00 | QQQ | ETF | 31.41 | 31.48 | 31.21 | 31.242 | 8293200.0 |
| 2003-08-05 10:00:00 | QQQ | ETF | 31.24 | 31.46 | 31.0 | 31.11 | 10055000.0 |
| 2003-08-05 10:30:00 | QQQ | ETF | 31.1 | 31.17 | 30.995 | 31.141 | 8790600.0 |
| 2003-08-05 11:00:00 | QQQ | ETF | 31.148 | 31.16 | 31.01 | 31.09 | 3120100.0 |
| 2003-08-05 11:30:00 | QQQ | ETF | 31.089 | 31.2 | 31.05 | 31.11 | 2831800.0 |
| 2003-08-05 12:00:00 | QQQ | ETF | 31.13 | 31.2 | 31.09 | 31.14 | 1685400.0 |
| 2003-08-05 12:30:00 | QQQ | ETF | 31.13 | 31.19 | 31.05 | 31.11 | 2081100.0 |
| 2003-08-05 13:00:00 | QQQ | ETF | 31.121 | 31.14 | 31.03 | 31.05 | 2022700.0 |
| 2003-08-05 13:30:00 | QQQ | ETF | 31.05 | 31.11 | 30.9 | 30.97 | 4564800.0 |
| 2003-08-05 14:00:00 | QQQ | ETF | 30.97 | 31.02 | 30.821 | 30.91 | 4802300.0 |
| 2003-08-05 14:30:00 | QQQ | ETF | 30.9 | 31.036 | 30.82 | 30.86 | 7310600.0 |
| 2003-08-05 15:00:00 | QQQ | ETF | 30.868 | 30.89 | 30.69 | 30.75 | 9532700.0 |
| 2003-08-05 15:30:00 | QQQ | ETF | 30.754 | 30.776 | 30.48 | 30.55 | 17414900.0 |
| 2003-08-05 16:00:00 | QQQ | ETF | 30.53 | 30.57 | 30.1 | 30.11 | 8407000.0 |
| 2003-08-05 16:30:00 | QQQ | ETF | 30.13 | 30.249 | 30.1 | 30.21 | 1869800.0 |
| 2003-08-05 17:00:00 | QQQ | ETF | 30.2 | 30.3 | 30.12 | 30.127 | 1953000.0 |
| 2003-08-05 17:30:00 | QQQ | ETF | 30.14 | 31.51 | 30.11 | 30.17 | 2753900.0 |
| 2003-08-05 18:00:00 | QQQ | ETF | 30.17 | 30.18 | 30.14 | 30.15 | 29800.0 |
| 2003-08-05 18:30:00 | QQQ | ETF | 30.16 | 30.21 | 30.16 | 30.18 | 17600.0 |
| 2003-08-05 19:00:00 | QQQ | ETF | 30.18 | 30.2 | 30.18 | 30.19 | 7900.0 |
| 2003-08-05 19:30:00 | QQQ | ETF | 30.19 | 30.21 | 30.18 | 30.2 | 13100.0 |
| 2003-08-05 09:00:00 | IWM | ETF | 46.3 | 46.3 | 46.3 | 46.3 | 600.0 |
| 2003-08-05 09:30:00 | IWM | ETF | 46.22 | 46.325 | 46.09 | 46.13 | 401000.0 |
> showing 50 of 699 rows — these rows as CSV