PREVIEW / etf_30min / 2003-04-08
file: by_date/etf_30min/2003/2003-04-08.parquet size: 21 KB rows: 649
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-04-08 08:00:00 | SPY | ETF | 88.84 | 88.84 | 88.53 | 88.53 | 58000.0 |
| 2003-04-08 08:30:00 | SPY | ETF | 88.52 | 88.55 | 88.4 | 88.45 | 58700.0 |
| 2003-04-08 09:00:00 | SPY | ETF | 88.43 | 88.48 | 88.29 | 88.3 | 26300.0 |
| 2003-04-08 09:30:00 | SPY | ETF | 88.3 | 88.44 | 87.83 | 87.9 | 5776000.0 |
| 2003-04-08 10:00:00 | SPY | ETF | 87.93 | 88.25 | 87.75 | 87.82 | 3241200.0 |
| 2003-04-08 10:30:00 | SPY | ETF | 87.84 | 88.5 | 87.71 | 88.44 | 3607800.0 |
| 2003-04-08 11:00:00 | SPY | ETF | 88.46 | 88.51 | 87.79 | 88.0 | 5043300.0 |
| 2003-04-08 11:30:00 | SPY | ETF | 87.93 | 88.34 | 87.89 | 88.16 | 1708100.0 |
| 2003-04-08 12:00:00 | SPY | ETF | 88.15 | 88.23 | 87.95 | 88.17 | 1408900.0 |
| 2003-04-08 12:30:00 | SPY | ETF | 88.16 | 88.46 | 88.02 | 88.27 | 1734000.0 |
| 2003-04-08 13:00:00 | SPY | ETF | 88.27 | 88.45 | 88.1 | 88.26 | 1469900.0 |
| 2003-04-08 13:30:00 | SPY | ETF | 88.3 | 88.4 | 88.14 | 88.35 | 948500.0 |
| 2003-04-08 14:00:00 | SPY | ETF | 88.33 | 88.65 | 88.3 | 88.36 | 2594500.0 |
| 2003-04-08 14:30:00 | SPY | ETF | 88.39 | 88.45 | 88.02 | 88.09 | 2035500.0 |
| 2003-04-08 15:00:00 | SPY | ETF | 88.08 | 88.27 | 87.95 | 88.11 | 2349300.0 |
| 2003-04-08 15:30:00 | SPY | ETF | 88.16 | 88.33 | 88.02 | 88.13 | 2856000.0 |
| 2003-04-08 16:00:00 | SPY | ETF | 88.09 | 88.25 | 88.06 | 88.19 | 1928700.0 |
| 2003-04-08 16:30:00 | SPY | ETF | 88.19 | 88.26 | 88.09 | 88.25 | 231500.0 |
| 2003-04-08 17:00:00 | SPY | ETF | 88.25 | 88.28 | 88.16 | 88.18 | 19200.0 |
| 2003-04-08 17:30:00 | SPY | ETF | 88.2 | 88.23 | 88.18 | 88.23 | 1500.0 |
| 2003-04-08 18:00:00 | SPY | ETF | 88.24 | 88.24 | 88.13 | 88.17 | 13900.0 |
| 2003-04-08 18:30:00 | SPY | ETF | 88.21 | 88.25 | 88.17 | 88.17 | 2800.0 |
| 2003-04-08 19:00:00 | SPY | ETF | 88.13 | 88.24 | 88.13 | 88.24 | 800.0 |
| 2003-04-08 19:30:00 | SPY | ETF | 88.19 | 88.19 | 88.13 | 88.13 | 10500.0 |
| 2003-04-08 08:00:00 | QQQ | ETF | 26.35 | 26.41 | 26.22 | 26.22 | 109600.0 |
| 2003-04-08 08:30:00 | QQQ | ETF | 26.22 | 26.25 | 26.11 | 26.16 | 126100.0 |
| 2003-04-08 09:00:00 | QQQ | ETF | 26.16 | 26.2 | 26.14 | 26.15 | 33700.0 |
| 2003-04-08 09:30:00 | QQQ | ETF | 26.15 | 26.2 | 25.93 | 25.95 | 9493100.0 |
| 2003-04-08 10:00:00 | QQQ | ETF | 25.96 | 26.1 | 25.9 | 25.94 | 5951400.0 |
| 2003-04-08 10:30:00 | QQQ | ETF | 25.92 | 26.21 | 25.88 | 26.2 | 5388800.0 |
| 2003-04-08 11:00:00 | QQQ | ETF | 26.17 | 26.22 | 25.98 | 26.04 | 4040500.0 |
| 2003-04-08 11:30:00 | QQQ | ETF | 26.05 | 26.19 | 26.03 | 26.1 | 2045800.0 |
| 2003-04-08 12:00:00 | QQQ | ETF | 26.1 | 26.13 | 26.01 | 26.11 | 1705900.0 |
| 2003-04-08 12:30:00 | QQQ | ETF | 26.11 | 26.2 | 26.06 | 26.15 | 1462700.0 |
| 2003-04-08 13:00:00 | QQQ | ETF | 26.14 | 26.19 | 26.07 | 26.15 | 1828100.0 |
| 2003-04-08 13:30:00 | QQQ | ETF | 26.15 | 26.18 | 26.07 | 26.16 | 1736700.0 |
| 2003-04-08 14:00:00 | QQQ | ETF | 26.16 | 26.29 | 26.13 | 26.18 | 3865700.0 |
| 2003-04-08 14:30:00 | QQQ | ETF | 26.19 | 26.22 | 26.02 | 26.03 | 4001900.0 |
| 2003-04-08 15:00:00 | QQQ | ETF | 26.03 | 26.12 | 25.96 | 26.03 | 2731900.0 |
| 2003-04-08 15:30:00 | QQQ | ETF | 26.04 | 26.11 | 25.98 | 26.0 | 3188400.0 |
| 2003-04-08 16:00:00 | QQQ | ETF | 26.0 | 26.14 | 25.95 | 26.06 | 866700.0 |
| 2003-04-08 16:30:00 | QQQ | ETF | 26.06 | 26.08 | 25.07 | 26.08 | 279600.0 |
| 2003-04-08 17:00:00 | QQQ | ETF | 26.09 | 26.09 | 26.05 | 26.08 | 47000.0 |
| 2003-04-08 17:30:00 | QQQ | ETF | 26.08 | 26.08 | 26.05 | 26.06 | 9500.0 |
| 2003-04-08 18:00:00 | QQQ | ETF | 26.07 | 26.07 | 26.05 | 26.07 | 14600.0 |
| 2003-04-08 18:30:00 | QQQ | ETF | 26.07 | 26.07 | 26.06 | 26.06 | 3800.0 |
| 2003-04-08 19:00:00 | QQQ | ETF | 26.07 | 26.09 | 26.06 | 26.06 | 2300.0 |
| 2003-04-08 19:30:00 | QQQ | ETF | 26.08 | 26.08 | 26.04 | 26.05 | 5800.0 |
| 2003-04-08 09:30:00 | IWM | ETF | 37.35 | 37.45 | 37.275 | 37.275 | 228200.0 |
| 2003-04-08 10:00:00 | IWM | ETF | 37.295 | 37.31 | 37.19 | 37.19 | 198800.0 |
> showing 50 of 649 rows — these rows as CSV