PREVIEW / etf_30min / 2004-07-23
file: by_date/etf_30min/2004/2004-07-23.parquet size: 35 KB rows: 1,151
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-07-23 08:00:00 | SPY | ETF | 109.69 | 109.75 | 109.59 | 109.59 | 10400.0 |
| 2004-07-23 08:30:00 | SPY | ETF | 109.64 | 109.82 | 109.64 | 109.69 | 43000.0 |
| 2004-07-23 09:00:00 | SPY | ETF | 109.69 | 109.69 | 109.61 | 109.68 | 55100.0 |
| 2004-07-23 09:30:00 | SPY | ETF | 109.62 | 109.7 | 109.35 | 109.41 | 4961400.0 |
| 2004-07-23 10:00:00 | SPY | ETF | 109.41 | 109.47 | 109.03 | 109.28 | 5151900.0 |
| 2004-07-23 10:30:00 | SPY | ETF | 109.27 | 109.64 | 109.26 | 109.55 | 3943300.0 |
| 2004-07-23 11:00:00 | SPY | ETF | 109.55 | 109.56 | 109.25 | 109.31 | 3864400.0 |
| 2004-07-23 11:30:00 | SPY | ETF | 109.32 | 109.42 | 109.18 | 109.4 | 1307300.0 |
| 2004-07-23 12:00:00 | SPY | ETF | 109.41 | 109.41 | 109.06 | 109.11 | 1841900.0 |
| 2004-07-23 12:30:00 | SPY | ETF | 109.11 | 109.29 | 109.01 | 109.2 | 1553600.0 |
| 2004-07-23 13:00:00 | SPY | ETF | 109.21 | 109.45 | 109.19 | 109.4 | 1215600.0 |
| 2004-07-23 13:30:00 | SPY | ETF | 109.4 | 109.44 | 109.21 | 109.23 | 1354600.0 |
| 2004-07-23 14:00:00 | SPY | ETF | 109.24 | 109.24 | 108.84 | 109.21 | 4097600.0 |
| 2004-07-23 14:30:00 | SPY | ETF | 109.23 | 109.23 | 108.9 | 109.01 | 2410900.0 |
| 2004-07-23 15:00:00 | SPY | ETF | 109.0 | 109.22 | 108.69 | 109.21 | 6030200.0 |
| 2004-07-23 15:30:00 | SPY | ETF | 109.21 | 109.39 | 108.91 | 108.92 | 5536100.0 |
| 2004-07-23 16:00:00 | SPY | ETF | 108.92 | 109.05 | 108.82 | 108.9 | 1771400.0 |
| 2004-07-23 16:30:00 | SPY | ETF | 108.99 | 109.11 | 108.93 | 109.0 | 58800.0 |
| 2004-07-23 17:00:00 | SPY | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 1000.0 |
| 2004-07-23 18:00:00 | SPY | ETF | 108.97 | 108.97 | 108.97 | 108.97 | 100.0 |
| 2004-07-23 18:30:00 | SPY | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 100.0 |
| 2004-07-23 19:00:00 | SPY | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 1000.0 |
| 2004-07-23 08:00:00 | QQQ | ETF | 34.68 | 34.68 | 34.63 | 34.65 | 205400.0 |
| 2004-07-23 08:30:00 | QQQ | ETF | 34.65 | 34.69 | 34.65 | 34.67 | 82200.0 |
| 2004-07-23 09:00:00 | QQQ | ETF | 34.66 | 34.67 | 34.64 | 34.64 | 62000.0 |
| 2004-07-23 09:30:00 | QQQ | ETF | 34.63 | 34.66 | 34.503 | 34.51 | 12378600.0 |
| 2004-07-23 10:00:00 | QQQ | ETF | 34.51 | 34.64 | 34.36 | 34.48 | 13591700.0 |
| 2004-07-23 10:30:00 | QQQ | ETF | 34.48 | 34.631 | 34.45 | 34.58 | 7360000.0 |
| 2004-07-23 11:00:00 | QQQ | ETF | 34.58 | 34.61 | 34.43 | 34.47 | 6460900.0 |
| 2004-07-23 11:30:00 | QQQ | ETF | 34.47 | 34.5 | 34.37 | 34.5 | 4110700.0 |
| 2004-07-23 12:00:00 | QQQ | ETF | 34.49 | 34.5 | 34.32 | 34.36 | 4856000.0 |
| 2004-07-23 12:30:00 | QQQ | ETF | 34.36 | 34.38 | 34.24 | 34.327 | 4818900.0 |
| 2004-07-23 13:00:00 | QQQ | ETF | 34.32 | 34.45 | 34.31 | 34.42 | 3393800.0 |
| 2004-07-23 13:30:00 | QQQ | ETF | 34.4185 | 34.45 | 34.31 | 34.32 | 3202900.0 |
| 2004-07-23 14:00:00 | QQQ | ETF | 34.32 | 34.32 | 34.14 | 34.257 | 8187600.0 |
| 2004-07-23 14:30:00 | QQQ | ETF | 34.26 | 34.26 | 34.15 | 34.23 | 5899100.0 |
| 2004-07-23 15:00:00 | QQQ | ETF | 34.232 | 34.29 | 34.03 | 34.29 | 11584700.0 |
| 2004-07-23 15:30:00 | QQQ | ETF | 34.29 | 34.37 | 34.16 | 34.16 | 12631500.0 |
| 2004-07-23 16:00:00 | QQQ | ETF | 34.174 | 34.23 | 34.15 | 34.22 | 4656600.0 |
| 2004-07-23 16:30:00 | QQQ | ETF | 34.24 | 34.24 | 34.2 | 34.24 | 28600.0 |
| 2004-07-23 17:00:00 | QQQ | ETF | 34.23 | 34.24 | 34.22 | 34.24 | 26000.0 |
| 2004-07-23 17:30:00 | QQQ | ETF | 34.23 | 34.24 | 34.22 | 34.22 | 6700.0 |
| 2004-07-23 18:00:00 | QQQ | ETF | 34.23 | 34.3 | 34.22 | 34.3 | 24600.0 |
| 2004-07-23 19:00:00 | QQQ | ETF | 34.23 | 34.23 | 34.23 | 34.23 | 1500.0 |
| 2004-07-23 19:30:00 | QQQ | ETF | 34.25 | 34.25 | 34.25 | 34.25 | 500.0 |
| 2004-07-23 08:00:00 | IWM | ETF | 54.265 | 54.265 | 54.265 | 54.265 | 200.0 |
| 2004-07-23 09:00:00 | IWM | ETF | 54.355 | 54.355 | 54.345 | 54.345 | 2000.0 |
| 2004-07-23 09:30:00 | IWM | ETF | 54.335 | 54.345 | 53.845 | 53.87 | 1177200.0 |
| 2004-07-23 10:00:00 | IWM | ETF | 53.865 | 54.175 | 53.75 | 54.0 | 1424800.0 |
| 2004-07-23 10:30:00 | IWM | ETF | 53.985 | 54.435 | 53.975 | 54.4 | 1301800.0 |
> showing 50 of 1,151 rows — these rows as CSV