PREVIEW / etf_30min / 2003-09-12
file: by_date/etf_30min/2003/2003-09-12.parquet size: 24 KB rows: 713
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-09-12 08:00:00 | SPY | ETF | 102.3 | 102.3 | 102.23 | 102.29 | 59100.0 |
| 2003-09-12 08:30:00 | SPY | ETF | 102.22 | 102.29 | 101.89 | 102.03 | 128100.0 |
| 2003-09-12 09:00:00 | SPY | ETF | 102.04 | 102.04 | 101.91 | 101.95 | 37900.0 |
| 2003-09-12 09:30:00 | SPY | ETF | 101.91 | 102.09 | 101.35 | 101.44 | 5893900.0 |
| 2003-09-12 10:00:00 | SPY | ETF | 101.43 | 101.67 | 101.37 | 101.53 | 3521300.0 |
| 2003-09-12 10:30:00 | SPY | ETF | 101.54 | 101.75 | 101.44 | 101.57 | 3264800.0 |
| 2003-09-12 11:00:00 | SPY | ETF | 101.64 | 102.18 | 101.56 | 101.96 | 4565800.0 |
| 2003-09-12 11:30:00 | SPY | ETF | 101.96 | 101.99 | 101.697 | 101.878 | 1494800.0 |
| 2003-09-12 12:00:00 | SPY | ETF | 101.88 | 101.9 | 101.73 | 101.75 | 520500.0 |
| 2003-09-12 12:30:00 | SPY | ETF | 101.76 | 101.85 | 101.55 | 101.78 | 2292600.0 |
| 2003-09-12 13:00:00 | SPY | ETF | 101.807 | 101.89 | 101.72 | 101.8 | 610500.0 |
| 2003-09-12 13:30:00 | SPY | ETF | 101.78 | 101.8 | 101.65 | 101.77 | 944500.0 |
| 2003-09-12 14:00:00 | SPY | ETF | 101.77 | 102.16 | 101.76 | 102.0 | 3292600.0 |
| 2003-09-12 14:30:00 | SPY | ETF | 102.05 | 102.48 | 101.93 | 102.38 | 3353700.0 |
| 2003-09-12 15:00:00 | SPY | ETF | 102.38 | 102.64 | 102.33 | 102.52 | 2044900.0 |
| 2003-09-12 15:30:00 | SPY | ETF | 102.52 | 102.64 | 102.33 | 102.52 | 2049700.0 |
| 2003-09-12 16:00:00 | SPY | ETF | 102.52 | 102.58 | 101.6928 | 102.55 | 1916300.0 |
| 2003-09-12 16:30:00 | SPY | ETF | 102.52 | 102.54 | 102.49 | 102.54 | 110900.0 |
| 2003-09-12 17:00:00 | SPY | ETF | 102.54 | 102.57 | 102.54 | 102.57 | 8500.0 |
| 2003-09-12 17:30:00 | SPY | ETF | 102.57 | 102.62 | 102.57 | 102.61 | 5300.0 |
| 2003-09-12 18:00:00 | SPY | ETF | 102.61 | 102.61 | 102.61 | 102.61 | 3900.0 |
| 2003-09-12 18:30:00 | SPY | ETF | 102.62 | 102.66 | 102.62 | 102.66 | 2000.0 |
| 2003-09-12 08:00:00 | QQQ | ETF | 33.47 | 33.53 | 33.47 | 33.51 | 75700.0 |
| 2003-09-12 08:30:00 | QQQ | ETF | 33.51 | 33.58 | 33.29 | 33.33 | 386700.0 |
| 2003-09-12 09:00:00 | QQQ | ETF | 33.33 | 33.36 | 33.32 | 33.34 | 117300.0 |
| 2003-09-12 09:30:00 | QQQ | ETF | 33.34 | 33.4 | 33.05 | 33.11 | 13736900.0 |
| 2003-09-12 10:00:00 | QQQ | ETF | 33.11 | 33.36 | 33.08 | 33.19 | 10115600.0 |
| 2003-09-12 10:30:00 | QQQ | ETF | 33.197 | 33.37 | 33.164 | 33.29 | 7320000.0 |
| 2003-09-12 11:00:00 | QQQ | ETF | 33.29 | 33.48 | 33.25 | 33.34 | 8435000.0 |
| 2003-09-12 11:30:00 | QQQ | ETF | 33.33 | 33.39 | 33.22 | 33.304 | 3345300.0 |
| 2003-09-12 12:00:00 | QQQ | ETF | 33.31 | 33.33 | 33.21 | 33.26 | 1873900.0 |
| 2003-09-12 12:30:00 | QQQ | ETF | 33.25 | 33.3 | 33.14 | 33.29 | 8528500.0 |
| 2003-09-12 13:00:00 | QQQ | ETF | 33.27 | 33.33 | 33.24 | 33.3 | 1931200.0 |
| 2003-09-12 13:30:00 | QQQ | ETF | 33.305 | 33.34 | 33.2018 | 33.32 | 5388500.0 |
| 2003-09-12 14:00:00 | QQQ | ETF | 33.33 | 33.501 | 33.31 | 33.47 | 6773900.0 |
| 2003-09-12 14:30:00 | QQQ | ETF | 33.47 | 33.72 | 33.41 | 33.63 | 7990100.0 |
| 2003-09-12 15:00:00 | QQQ | ETF | 33.63 | 33.74 | 33.56 | 33.68 | 5399000.0 |
| 2003-09-12 15:30:00 | QQQ | ETF | 33.67 | 33.74 | 33.57 | 33.74 | 6226200.0 |
| 2003-09-12 16:00:00 | QQQ | ETF | 33.74 | 33.84 | 33.45 | 33.84 | 1892500.0 |
| 2003-09-12 16:30:00 | QQQ | ETF | 33.84 | 33.88 | 33.83 | 33.84 | 126900.0 |
| 2003-09-12 17:00:00 | QQQ | ETF | 33.85 | 33.85 | 33.81 | 33.83 | 69400.0 |
| 2003-09-12 17:30:00 | QQQ | ETF | 33.84 | 33.89 | 33.83 | 33.87 | 32400.0 |
| 2003-09-12 18:00:00 | QQQ | ETF | 33.82 | 33.85 | 33.82 | 33.84 | 20600.0 |
| 2003-09-12 18:30:00 | QQQ | ETF | 33.81 | 33.83 | 33.81 | 33.83 | 1800.0 |
| 2003-09-12 19:00:00 | QQQ | ETF | 33.82 | 33.82 | 33.82 | 33.82 | 700.0 |
| 2003-09-12 19:30:00 | QQQ | ETF | 33.84 | 33.86 | 33.82 | 33.86 | 5200.0 |
| 2003-09-12 08:30:00 | IWM | ETF | 50.27 | 50.305 | 50.27 | 50.295 | 6600.0 |
| 2003-09-12 09:30:00 | IWM | ETF | 50.355 | 50.375 | 49.9 | 49.945 | 1049200.0 |
| 2003-09-12 10:00:00 | IWM | ETF | 49.945 | 50.255 | 49.9 | 50.165 | 590200.0 |
| 2003-09-12 10:30:00 | IWM | ETF | 50.155 | 50.255 | 50.14 | 50.195 | 234800.0 |
> showing 50 of 713 rows — these rows as CSV