PREVIEW / etf_30min / 2004-04-29
file: by_date/etf_30min/2004/2004-04-29.parquet size: 38 KB rows: 1,198
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-04-29 08:00:00 | SPY | ETF | 112.38 | 112.39 | 112.26 | 112.37 | 71700.0 |
| 2004-04-29 08:30:00 | SPY | ETF | 112.35 | 112.59 | 112.08 | 112.52 | 929700.0 |
| 2004-04-29 09:00:00 | SPY | ETF | 112.51 | 112.74 | 112.49 | 112.74 | 165300.0 |
| 2004-04-29 09:30:00 | SPY | ETF | 112.72 | 112.89 | 112.28 | 112.54 | 8297300.0 |
| 2004-04-29 10:00:00 | SPY | ETF | 112.53 | 113.32 | 112.44 | 113.05 | 5636700.0 |
| 2004-04-29 10:30:00 | SPY | ETF | 113.05 | 113.19 | 112.91 | 113.15 | 1742000.0 |
| 2004-04-29 11:00:00 | SPY | ETF | 113.14 | 113.3 | 112.79 | 112.84 | 2243000.0 |
| 2004-04-29 11:30:00 | SPY | ETF | 112.84 | 112.89 | 112.43 | 112.54 | 3031400.0 |
| 2004-04-29 12:00:00 | SPY | ETF | 112.54 | 112.63 | 112.07 | 112.21 | 4479800.0 |
| 2004-04-29 12:30:00 | SPY | ETF | 112.21 | 112.41 | 112.04 | 112.25 | 3434800.0 |
| 2004-04-29 13:00:00 | SPY | ETF | 112.28 | 112.44 | 112.12 | 112.21 | 1766900.0 |
| 2004-04-29 13:30:00 | SPY | ETF | 112.21 | 112.63 | 112.17 | 112.36 | 2803900.0 |
| 2004-04-29 14:00:00 | SPY | ETF | 112.36 | 112.54 | 111.62 | 111.75 | 4798300.0 |
| 2004-04-29 14:30:00 | SPY | ETF | 111.73 | 111.81 | 111.5 | 111.68 | 5619300.0 |
| 2004-04-29 15:00:00 | SPY | ETF | 111.67 | 111.67 | 111.16 | 111.3 | 4474900.0 |
| 2004-04-29 15:30:00 | SPY | ETF | 111.3 | 111.99 | 111.24 | 111.85 | 6065800.0 |
| 2004-04-29 16:00:00 | SPY | ETF | 111.84 | 111.97 | 111.67 | 111.74 | 1610900.0 |
| 2004-04-29 16:30:00 | SPY | ETF | 111.79 | 111.99 | 111.53 | 111.92 | 330200.0 |
| 2004-04-29 17:00:00 | SPY | ETF | 111.91 | 111.96 | 111.88 | 111.88 | 10300.0 |
| 2004-04-29 17:30:00 | SPY | ETF | 111.84 | 111.87 | 111.83 | 111.83 | 3800.0 |
| 2004-04-29 18:00:00 | SPY | ETF | 111.86 | 111.86 | 111.75 | 111.75 | 9400.0 |
| 2004-04-29 18:30:00 | SPY | ETF | 111.76 | 111.76 | 111.72 | 111.72 | 2200.0 |
| 2004-04-29 19:00:00 | SPY | ETF | 111.7 | 111.7 | 111.7 | 111.7 | 4900.0 |
| 2004-04-29 08:00:00 | QQQ | ETF | 36.19 | 36.19 | 35.95 | 36.02 | 176600.0 |
| 2004-04-29 08:30:00 | QQQ | ETF | 36.02 | 36.07 | 35.87 | 35.98 | 574200.0 |
| 2004-04-29 09:00:00 | QQQ | ETF | 35.97 | 36.08 | 35.96 | 36.07 | 348100.0 |
| 2004-04-29 09:30:00 | QQQ | ETF | 36.09 | 36.21 | 35.846 | 35.96 | 18264900.0 |
| 2004-04-29 10:00:00 | QQQ | ETF | 35.95 | 36.34 | 35.9 | 36.166 | 15614200.0 |
| 2004-04-29 10:30:00 | QQQ | ETF | 36.17 | 36.23 | 36.09 | 36.16 | 7692700.0 |
| 2004-04-29 11:00:00 | QQQ | ETF | 36.159 | 36.23 | 36.01 | 36.03 | 4487300.0 |
| 2004-04-29 11:30:00 | QQQ | ETF | 36.04 | 36.07 | 35.893 | 35.919 | 7191000.0 |
| 2004-04-29 12:00:00 | QQQ | ETF | 35.917 | 35.95 | 35.68 | 35.757 | 8413200.0 |
| 2004-04-29 12:30:00 | QQQ | ETF | 35.78 | 35.86 | 35.7 | 35.78 | 6323000.0 |
| 2004-04-29 13:00:00 | QQQ | ETF | 35.78 | 35.87 | 35.71 | 35.728 | 5983200.0 |
| 2004-04-29 13:30:00 | QQQ | ETF | 35.727 | 35.91 | 35.727 | 35.82 | 4694500.0 |
| 2004-04-29 14:00:00 | QQQ | ETF | 35.82 | 35.88 | 35.49 | 35.52 | 12659500.0 |
| 2004-04-29 14:30:00 | QQQ | ETF | 35.53 | 35.549 | 35.37 | 35.46 | 11797200.0 |
| 2004-04-29 15:00:00 | QQQ | ETF | 35.457 | 35.48 | 35.3 | 35.38 | 10838300.0 |
| 2004-04-29 15:30:00 | QQQ | ETF | 35.4 | 35.7 | 35.35 | 35.62 | 14058100.0 |
| 2004-04-29 16:00:00 | QQQ | ETF | 35.64 | 35.7925 | 35.56 | 35.57 | 4071700.0 |
| 2004-04-29 16:30:00 | QQQ | ETF | 35.57 | 35.63 | 35.57 | 35.63 | 309200.0 |
| 2004-04-29 17:00:00 | QQQ | ETF | 35.62 | 35.64 | 35.59 | 35.62 | 79500.0 |
| 2004-04-29 17:30:00 | QQQ | ETF | 35.62 | 35.62 | 35.56 | 35.56 | 38200.0 |
| 2004-04-29 18:00:00 | QQQ | ETF | 35.58 | 35.59 | 35.55 | 35.55 | 34100.0 |
| 2004-04-29 18:30:00 | QQQ | ETF | 35.55 | 35.55 | 35.54 | 35.55 | 10800.0 |
| 2004-04-29 19:00:00 | QQQ | ETF | 35.55 | 35.55 | 35.51 | 35.52 | 50900.0 |
| 2004-04-29 19:30:00 | QQQ | ETF | 35.54 | 35.56 | 35.52 | 35.55 | 7800.0 |
| 2004-04-29 08:30:00 | IWM | ETF | 57.3 | 57.3 | 57.18 | 57.26 | 4400.0 |
| 2004-04-29 09:00:00 | IWM | ETF | 57.395 | 57.57 | 57.36 | 57.57 | 9600.0 |
| 2004-04-29 09:30:00 | IWM | ETF | 57.65 | 57.795 | 57.115 | 57.325 | 3051200.0 |
> showing 50 of 1,198 rows — these rows as CSV