PREVIEW / etf_30min / 2004-03-12
file: by_date/etf_30min/2004/2004-03-12.parquet size: 37 KB rows: 1,227
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-12 08:00:00 | SPY | ETF | 111.59 | 111.63 | 111.52 | 111.57 | 29800.0 |
| 2004-03-12 08:30:00 | SPY | ETF | 111.6 | 111.71 | 111.58 | 111.66 | 37100.0 |
| 2004-03-12 09:00:00 | SPY | ETF | 111.68 | 111.75 | 111.68 | 111.73 | 105200.0 |
| 2004-03-12 09:30:00 | SPY | ETF | 111.73 | 112.22 | 111.66 | 112.04 | 11557700.0 |
| 2004-03-12 10:00:00 | SPY | ETF | 112.08 | 112.26 | 111.77 | 111.82 | 9320600.0 |
| 2004-03-12 10:30:00 | SPY | ETF | 111.79 | 112.03 | 111.58 | 111.78 | 4395200.0 |
| 2004-03-12 11:00:00 | SPY | ETF | 111.77 | 112.22 | 111.76 | 112.2 | 2389400.0 |
| 2004-03-12 11:30:00 | SPY | ETF | 112.2 | 112.51 | 112.16 | 112.5 | 4247600.0 |
| 2004-03-12 12:00:00 | SPY | ETF | 112.51 | 112.54 | 112.21 | 112.33 | 2005100.0 |
| 2004-03-12 12:30:00 | SPY | ETF | 112.33 | 112.36 | 112.05 | 112.2 | 1660900.0 |
| 2004-03-12 13:00:00 | SPY | ETF | 112.21 | 112.35 | 112.1 | 112.13 | 753000.0 |
| 2004-03-12 13:30:00 | SPY | ETF | 112.14 | 112.31 | 112.04 | 112.25 | 1106700.0 |
| 2004-03-12 14:00:00 | SPY | ETF | 112.28 | 112.53 | 112.23 | 112.32 | 2323500.0 |
| 2004-03-12 14:30:00 | SPY | ETF | 112.33 | 112.53 | 112.21 | 112.34 | 1573900.0 |
| 2004-03-12 15:00:00 | SPY | ETF | 112.35 | 112.6 | 112.18 | 112.5 | 2280800.0 |
| 2004-03-12 15:30:00 | SPY | ETF | 112.51 | 112.7 | 112.31 | 112.69 | 3544500.0 |
| 2004-03-12 16:00:00 | SPY | ETF | 112.68 | 112.71 | 112.51 | 112.65 | 1634000.0 |
| 2004-03-12 16:30:00 | SPY | ETF | 112.61 | 112.7 | 112.61 | 112.67 | 60100.0 |
| 2004-03-12 17:00:00 | SPY | ETF | 112.67 | 112.7 | 112.67 | 112.69 | 6000.0 |
| 2004-03-12 17:30:00 | SPY | ETF | 112.59 | 112.73 | 112.59 | 112.73 | 13000.0 |
| 2004-03-12 18:30:00 | SPY | ETF | 112.74 | 112.74 | 112.74 | 112.74 | 1400.0 |
| 2004-03-12 19:30:00 | SPY | ETF | 112.74 | 112.74 | 112.74 | 112.74 | 500.0 |
| 2004-03-12 08:00:00 | QQQ | ETF | 35.08 | 35.11 | 35.06 | 35.09 | 83700.0 |
| 2004-03-12 08:30:00 | QQQ | ETF | 35.1 | 35.18 | 35.08 | 35.15 | 361400.0 |
| 2004-03-12 09:00:00 | QQQ | ETF | 35.15 | 35.2 | 35.14 | 35.18 | 244200.0 |
| 2004-03-12 09:30:00 | QQQ | ETF | 35.18 | 35.42 | 35.156 | 35.35 | 23286300.0 |
| 2004-03-12 10:00:00 | QQQ | ETF | 35.35 | 35.43 | 35.2 | 35.24 | 10676400.0 |
| 2004-03-12 10:30:00 | QQQ | ETF | 35.23 | 35.33 | 35.15 | 35.243 | 7998900.0 |
| 2004-03-12 11:00:00 | QQQ | ETF | 35.2422 | 35.43 | 35.23 | 35.428 | 5112600.0 |
| 2004-03-12 11:30:00 | QQQ | ETF | 35.431 | 35.524 | 35.37 | 35.5 | 9353900.0 |
| 2004-03-12 12:00:00 | QQQ | ETF | 35.523 | 35.53 | 35.381 | 35.421 | 4218300.0 |
| 2004-03-12 12:30:00 | QQQ | ETF | 35.42 | 35.44 | 35.27 | 35.31 | 5882600.0 |
| 2004-03-12 13:00:00 | QQQ | ETF | 35.31 | 35.39 | 35.26 | 35.3 | 3474000.0 |
| 2004-03-12 13:30:00 | QQQ | ETF | 35.29 | 35.422 | 35.28 | 35.36 | 2737400.0 |
| 2004-03-12 14:00:00 | QQQ | ETF | 35.35 | 35.47 | 35.35 | 35.36 | 4275700.0 |
| 2004-03-12 14:30:00 | QQQ | ETF | 35.365 | 35.49 | 35.33 | 35.38 | 5481400.0 |
| 2004-03-12 15:00:00 | QQQ | ETF | 35.39 | 35.46 | 35.32 | 35.42 | 6167100.0 |
| 2004-03-12 15:30:00 | QQQ | ETF | 35.44 | 35.58 | 35.34 | 35.56 | 16854200.0 |
| 2004-03-12 16:00:00 | QQQ | ETF | 35.556 | 35.58 | 35.48 | 35.53 | 3986300.0 |
| 2004-03-12 16:30:00 | QQQ | ETF | 35.51 | 35.59 | 35.5 | 35.51 | 126500.0 |
| 2004-03-12 17:00:00 | QQQ | ETF | 35.51 | 35.53 | 35.5 | 35.53 | 9400.0 |
| 2004-03-12 17:30:00 | QQQ | ETF | 35.53 | 35.54 | 35.501 | 35.53 | 14400.0 |
| 2004-03-12 18:00:00 | QQQ | ETF | 35.53 | 35.55 | 35.52 | 35.54 | 24200.0 |
| 2004-03-12 18:30:00 | QQQ | ETF | 35.53 | 35.53 | 35.51 | 35.52 | 5500.0 |
| 2004-03-12 19:00:00 | QQQ | ETF | 35.53 | 35.55 | 35.53 | 35.55 | 7000.0 |
| 2004-03-12 19:30:00 | QQQ | ETF | 35.54 | 35.55 | 35.54 | 35.54 | 4100.0 |
| 2004-03-12 08:30:00 | IWM | ETF | 56.985 | 57.05 | 56.955 | 57.02 | 19200.0 |
| 2004-03-12 09:00:00 | IWM | ETF | 57.0 | 57.045 | 56.975 | 57.04 | 30600.0 |
| 2004-03-12 09:30:00 | IWM | ETF | 57.0 | 57.325 | 56.95 | 57.17 | 2211400.0 |
| 2004-03-12 10:00:00 | IWM | ETF | 57.175 | 57.25 | 56.915 | 56.975 | 1397600.0 |
> showing 50 of 1,227 rows — these rows as CSV