PREVIEW / etf_30min / 2003-06-18
file: by_date/etf_30min/2003/2003-06-18.parquet size: 24 KB rows: 716
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-06-18 08:00:00 | SPY | ETF | 101.69 | 101.69 | 101.56 | 101.58 | 7700.0 |
| 2003-06-18 08:30:00 | SPY | ETF | 101.6 | 101.6 | 101.32 | 101.39 | 63100.0 |
| 2003-06-18 09:00:00 | SPY | ETF | 101.39 | 101.39 | 101.27 | 101.33 | 48500.0 |
| 2003-06-18 09:30:00 | SPY | ETF | 101.29 | 101.42 | 101.0 | 101.19 | 4507000.0 |
| 2003-06-18 10:00:00 | SPY | ETF | 101.18 | 101.58 | 101.15 | 101.18 | 2558600.0 |
| 2003-06-18 10:30:00 | SPY | ETF | 101.2 | 101.61 | 101.12 | 101.55 | 2320700.0 |
| 2003-06-18 11:00:00 | SPY | ETF | 101.52 | 102.08 | 101.42 | 101.94 | 3738500.0 |
| 2003-06-18 11:30:00 | SPY | ETF | 101.94 | 102.14 | 101.79 | 101.9 | 2335700.0 |
| 2003-06-18 12:00:00 | SPY | ETF | 101.899 | 102.03 | 101.61 | 101.65 | 1046400.0 |
| 2003-06-18 12:30:00 | SPY | ETF | 101.669 | 101.78 | 101.56 | 101.76 | 1728000.0 |
| 2003-06-18 13:00:00 | SPY | ETF | 101.77 | 101.86 | 101.64 | 101.791 | 1833900.0 |
| 2003-06-18 13:30:00 | SPY | ETF | 101.8 | 101.88 | 101.55 | 101.78 | 1004800.0 |
| 2003-06-18 14:00:00 | SPY | ETF | 101.784 | 101.81 | 101.51 | 101.56 | 1327700.0 |
| 2003-06-18 14:30:00 | SPY | ETF | 101.53 | 101.58 | 101.16 | 101.23 | 3113300.0 |
| 2003-06-18 15:00:00 | SPY | ETF | 101.27 | 101.39 | 101.12 | 101.3 | 1613800.0 |
| 2003-06-18 15:30:00 | SPY | ETF | 101.28 | 101.57 | 101.2 | 101.55 | 2760000.0 |
| 2003-06-18 16:00:00 | SPY | ETF | 101.57 | 101.64 | 101.4395 | 101.56 | 1535800.0 |
| 2003-06-18 16:30:00 | SPY | ETF | 101.59 | 101.64 | 101.5 | 101.505 | 71300.0 |
| 2003-06-18 17:00:00 | SPY | ETF | 101.5 | 101.62 | 101.5 | 101.6 | 83400.0 |
| 2003-06-18 17:30:00 | SPY | ETF | 101.58 | 101.62 | 101.56 | 101.57 | 16400.0 |
| 2003-06-18 18:00:00 | SPY | ETF | 101.6 | 101.63 | 101.57 | 101.57 | 7700.0 |
| 2003-06-18 18:30:00 | SPY | ETF | 101.52 | 101.6 | 101.52 | 101.6 | 1700.0 |
| 2003-06-18 08:00:00 | QQQ | ETF | 30.8 | 30.8 | 30.75 | 30.75 | 50900.0 |
| 2003-06-18 08:30:00 | QQQ | ETF | 30.77 | 30.77 | 30.66 | 30.69 | 45900.0 |
| 2003-06-18 09:00:00 | QQQ | ETF | 30.69 | 30.69 | 30.63 | 30.65 | 95700.0 |
| 2003-06-18 09:30:00 | QQQ | ETF | 30.66 | 30.7 | 30.45 | 30.6 | 10781800.0 |
| 2003-06-18 10:00:00 | QQQ | ETF | 30.601 | 30.75 | 30.576 | 30.63 | 7998400.0 |
| 2003-06-18 10:30:00 | QQQ | ETF | 30.63 | 31.03 | 30.58 | 31.0 | 9080400.0 |
| 2003-06-18 11:00:00 | QQQ | ETF | 30.972 | 31.2 | 30.92 | 31.14 | 8868000.0 |
| 2003-06-18 11:30:00 | QQQ | ETF | 31.13 | 31.22 | 31.07 | 31.13 | 5577200.0 |
| 2003-06-18 12:00:00 | QQQ | ETF | 31.138 | 31.2 | 31.026 | 31.04 | 2951600.0 |
| 2003-06-18 12:30:00 | QQQ | ETF | 31.03 | 31.09 | 31.0 | 31.07 | 2445100.0 |
| 2003-06-18 13:00:00 | QQQ | ETF | 31.08 | 31.18 | 31.03 | 31.15 | 2068700.0 |
| 2003-06-18 13:30:00 | QQQ | ETF | 31.146 | 31.18 | 31.01 | 31.12 | 2868100.0 |
| 2003-06-18 14:00:00 | QQQ | ETF | 31.12 | 31.13 | 30.97 | 31.01 | 3167200.0 |
| 2003-06-18 14:30:00 | QQQ | ETF | 31.0 | 31.02 | 30.82 | 30.909 | 4918800.0 |
| 2003-06-18 15:00:00 | QQQ | ETF | 30.89 | 30.97 | 30.86 | 30.903 | 3566100.0 |
| 2003-06-18 15:30:00 | QQQ | ETF | 30.9 | 31.02 | 30.87 | 30.999 | 5660800.0 |
| 2003-06-18 16:00:00 | QQQ | ETF | 31.0 | 31.036 | 30.906 | 30.97 | 1808400.0 |
| 2003-06-18 16:30:00 | QQQ | ETF | 30.98 | 30.98 | 30.9 | 30.9 | 270900.0 |
| 2003-06-18 17:00:00 | QQQ | ETF | 30.901 | 31.02 | 30.9 | 31.0 | 191600.0 |
| 2003-06-18 17:30:00 | QQQ | ETF | 31.0 | 31.01 | 30.97 | 30.97 | 25700.0 |
| 2003-06-18 18:00:00 | QQQ | ETF | 30.98 | 31.0 | 30.969 | 30.998 | 7000.0 |
| 2003-06-18 18:30:00 | QQQ | ETF | 31.0 | 31.0 | 30.97 | 31.0 | 600.0 |
| 2003-06-18 19:00:00 | QQQ | ETF | 31.0 | 31.0 | 30.96 | 31.0 | 7000.0 |
| 2003-06-18 19:30:00 | QQQ | ETF | 31.0 | 31.02 | 30.98 | 31.02 | 5300.0 |
| 2003-06-18 20:00:00 | QQQ | ETF | 31.02 | 31.03 | 31.02 | 31.03 | 800.0 |
| 2003-06-18 09:30:00 | IWM | ETF | 45.49 | 45.575 | 45.285 | 45.4 | 359400.0 |
| 2003-06-18 10:00:00 | IWM | ETF | 45.405 | 45.545 | 45.405 | 45.42 | 320000.0 |
| 2003-06-18 10:30:00 | IWM | ETF | 45.415 | 45.51 | 45.395 | 45.51 | 87800.0 |
> showing 50 of 716 rows — these rows as CSV