PREVIEW / etf_30min / 2003-06-11
file: by_date/etf_30min/2003/2003-06-11.parquet size: 24 KB rows: 721
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-11 08:00:00 | SPY | ETF | 99.0 | 99.13 | 99.0 | 99.13 | 11800.0 |
| 2003-06-11 08:30:00 | SPY | ETF | 99.17 | 99.29 | 99.17 | 99.17 | 30600.0 |
| 2003-06-11 09:00:00 | SPY | ETF | 99.19 | 99.22 | 99.17 | 99.17 | 11100.0 |
| 2003-06-11 09:30:00 | SPY | ETF | 99.16 | 99.16 | 98.71 | 99.07 | 5021900.0 |
| 2003-06-11 10:00:00 | SPY | ETF | 99.06 | 99.38 | 98.88 | 99.28 | 3451500.0 |
| 2003-06-11 10:30:00 | SPY | ETF | 99.29 | 99.59 | 99.28 | 99.52 | 3148800.0 |
| 2003-06-11 11:00:00 | SPY | ETF | 99.5 | 99.64 | 99.27 | 99.38 | 2122600.0 |
| 2003-06-11 11:30:00 | SPY | ETF | 99.39 | 99.46 | 99.07 | 99.22 | 1597200.0 |
| 2003-06-11 12:00:00 | SPY | ETF | 99.23 | 99.44 | 99.1 | 99.43 | 1084500.0 |
| 2003-06-11 12:30:00 | SPY | ETF | 99.41 | 99.59 | 99.34 | 99.49 | 1028100.0 |
| 2003-06-11 13:00:00 | SPY | ETF | 99.5 | 99.62 | 99.44 | 99.52 | 1164000.0 |
| 2003-06-11 13:30:00 | SPY | ETF | 99.56 | 99.6 | 99.26 | 99.36 | 1804000.0 |
| 2003-06-11 14:00:00 | SPY | ETF | 99.36 | 99.77 | 99.29 | 99.74 | 3352200.0 |
| 2003-06-11 14:30:00 | SPY | ETF | 99.71 | 100.04 | 99.5 | 99.95 | 3466500.0 |
| 2003-06-11 15:00:00 | SPY | ETF | 99.95 | 100.28 | 99.9 | 100.25 | 4285200.0 |
| 2003-06-11 15:30:00 | SPY | ETF | 100.26 | 100.38 | 100.07 | 100.33 | 2368000.0 |
| 2003-06-11 16:00:00 | SPY | ETF | 100.33 | 100.39 | 100.27 | 100.35 | 2044200.0 |
| 2003-06-11 16:30:00 | SPY | ETF | 100.33 | 100.36 | 100.27 | 100.29 | 13400.0 |
| 2003-06-11 17:00:00 | SPY | ETF | 100.29 | 100.38 | 100.29 | 100.37 | 7400.0 |
| 2003-06-11 17:30:00 | SPY | ETF | 100.33 | 100.35 | 100.31 | 100.35 | 2000.0 |
| 2003-06-11 18:00:00 | SPY | ETF | 100.36 | 100.38 | 100.32 | 100.36 | 4100.0 |
| 2003-06-11 18:30:00 | SPY | ETF | 100.36 | 100.36 | 100.36 | 100.36 | 2000.0 |
| 2003-06-11 19:00:00 | SPY | ETF | 100.36 | 100.39 | 100.36 | 100.38 | 11700.0 |
| 2003-06-11 19:30:00 | SPY | ETF | 100.39 | 100.41 | 100.38 | 100.38 | 10900.0 |
| 2003-06-11 08:00:00 | QQQ | ETF | 29.96 | 30.0 | 29.95 | 30.0 | 21900.0 |
| 2003-06-11 08:30:00 | QQQ | ETF | 30.0 | 30.06 | 29.98 | 30.04 | 84400.0 |
| 2003-06-11 09:00:00 | QQQ | ETF | 30.04 | 30.06 | 30.02 | 30.05 | 58600.0 |
| 2003-06-11 09:30:00 | QQQ | ETF | 30.07 | 30.09 | 29.8 | 30.06 | 11363400.0 |
| 2003-06-11 10:00:00 | QQQ | ETF | 30.02 | 30.2 | 29.95 | 30.11 | 9965500.0 |
| 2003-06-11 10:30:00 | QQQ | ETF | 30.11 | 30.35 | 30.11 | 30.27 | 7497400.0 |
| 2003-06-11 11:00:00 | QQQ | ETF | 30.28 | 30.34 | 30.14 | 30.18 | 4240500.0 |
| 2003-06-11 11:30:00 | QQQ | ETF | 30.17 | 30.21 | 29.97 | 30.01 | 6057900.0 |
| 2003-06-11 12:00:00 | QQQ | ETF | 30.02 | 30.14 | 29.98 | 30.1 | 3162900.0 |
| 2003-06-11 12:30:00 | QQQ | ETF | 30.11 | 30.23 | 30.05 | 30.16 | 2238300.0 |
| 2003-06-11 13:00:00 | QQQ | ETF | 30.18 | 30.2 | 30.05 | 30.19 | 1971900.0 |
| 2003-06-11 13:30:00 | QQQ | ETF | 30.18 | 30.22 | 30.03 | 30.09 | 2542800.0 |
| 2003-06-11 14:00:00 | QQQ | ETF | 30.09 | 30.28 | 30.05 | 30.25 | 4771200.0 |
| 2003-06-11 14:30:00 | QQQ | ETF | 30.24 | 30.43 | 30.15 | 30.36 | 8317400.0 |
| 2003-06-11 15:00:00 | QQQ | ETF | 30.38 | 30.58 | 30.34 | 30.55 | 8460000.0 |
| 2003-06-11 15:30:00 | QQQ | ETF | 30.55 | 30.64 | 30.42 | 30.53 | 8507600.0 |
| 2003-06-11 16:00:00 | QQQ | ETF | 30.52 | 30.56 | 30.49 | 30.5 | 1106100.0 |
| 2003-06-11 16:30:00 | QQQ | ETF | 30.49 | 30.52 | 30.49 | 30.51 | 44900.0 |
| 2003-06-11 17:00:00 | QQQ | ETF | 30.53 | 30.56 | 30.52 | 30.53 | 61700.0 |
| 2003-06-11 17:30:00 | QQQ | ETF | 30.54 | 30.55 | 30.53 | 30.53 | 12600.0 |
| 2003-06-11 18:00:00 | QQQ | ETF | 30.54 | 30.56 | 30.52 | 30.53 | 40400.0 |
| 2003-06-11 18:30:00 | QQQ | ETF | 30.53 | 30.55 | 30.51 | 30.54 | 11400.0 |
| 2003-06-11 19:00:00 | QQQ | ETF | 30.53 | 30.55 | 30.53 | 30.55 | 10500.0 |
| 2003-06-11 19:30:00 | QQQ | ETF | 30.55 | 30.6 | 30.54 | 30.59 | 19700.0 |
| 2003-06-11 09:30:00 | IWM | ETF | 45.0 | 45.05 | 44.64 | 44.845 | 370800.0 |
| 2003-06-11 10:00:00 | IWM | ETF | 44.845 | 45.045 | 44.805 | 45.045 | 479200.0 |
> showing 50 of 721 rows — these rows as CSV