PREVIEW / etf_30min / 2004-10-27
file: by_date/etf_30min/2004/2004-10-27.parquet size: 41 KB rows: 1,294
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-10-27 08:00:00 | SPY | ETF | 111.47 | 111.47 | 111.36 | 111.36 | 35200.0 |
| 2004-10-27 08:30:00 | SPY | ETF | 111.44 | 111.53 | 111.34 | 111.47 | 319700.0 |
| 2004-10-27 09:00:00 | SPY | ETF | 111.39 | 111.45 | 111.36 | 111.4 | 42400.0 |
| 2004-10-27 09:30:00 | SPY | ETF | 111.38 | 111.44 | 111.16 | 111.18 | 6240000.0 |
| 2004-10-27 10:00:00 | SPY | ETF | 111.19 | 111.49 | 111.12 | 111.46 | 3709400.0 |
| 2004-10-27 10:30:00 | SPY | ETF | 111.46 | 111.91 | 111.31 | 111.89 | 8057000.0 |
| 2004-10-27 11:00:00 | SPY | ETF | 111.9 | 112.4 | 111.86 | 112.21 | 10541100.0 |
| 2004-10-27 11:30:00 | SPY | ETF | 112.2 | 112.43 | 112.17 | 112.32 | 4068100.0 |
| 2004-10-27 12:00:00 | SPY | ETF | 112.33 | 112.4 | 112.11 | 112.31 | 2702700.0 |
| 2004-10-27 12:30:00 | SPY | ETF | 112.3 | 112.33 | 112.13 | 112.29 | 2100500.0 |
| 2004-10-27 13:00:00 | SPY | ETF | 112.3 | 112.72 | 112.27 | 112.61 | 5808000.0 |
| 2004-10-27 13:30:00 | SPY | ETF | 112.59 | 112.68 | 112.5 | 112.65 | 3934700.0 |
| 2004-10-27 14:00:00 | SPY | ETF | 112.65 | 112.86 | 112.55 | 112.78 | 4607000.0 |
| 2004-10-27 14:30:00 | SPY | ETF | 112.77 | 112.92 | 112.71 | 112.9 | 2395300.0 |
| 2004-10-27 15:00:00 | SPY | ETF | 112.9 | 113.07 | 112.76 | 112.96 | 4422000.0 |
| 2004-10-27 15:30:00 | SPY | ETF | 112.95 | 113.1 | 112.85 | 112.96 | 5068200.0 |
| 2004-10-27 16:00:00 | SPY | ETF | 112.97 | 113.08 | 112.86 | 112.86 | 1769000.0 |
| 2004-10-27 16:30:00 | SPY | ETF | 112.86 | 112.88 | 112.78 | 112.87 | 122200.0 |
| 2004-10-27 17:00:00 | SPY | ETF | 112.9 | 112.9 | 112.87 | 112.87 | 6600.0 |
| 2004-10-27 17:30:00 | SPY | ETF | 112.88 | 112.88 | 112.88 | 112.88 | 700.0 |
| 2004-10-27 18:00:00 | SPY | ETF | 112.88 | 112.95 | 112.88 | 112.9 | 28800.0 |
| 2004-10-27 18:30:00 | SPY | ETF | 112.95 | 112.95 | 112.95 | 112.95 | 2900.0 |
| 2004-10-27 19:00:00 | SPY | ETF | 112.9 | 112.9 | 112.9 | 112.9 | 500.0 |
| 2004-10-27 19:30:00 | SPY | ETF | 112.9 | 112.9 | 112.9 | 112.9 | 700.0 |
| 2004-10-27 08:00:00 | QQQ | ETF | 35.88 | 35.88 | 35.78 | 35.8 | 49100.0 |
| 2004-10-27 08:30:00 | QQQ | ETF | 35.8 | 35.86 | 35.78 | 35.83 | 377300.0 |
| 2004-10-27 09:00:00 | QQQ | ETF | 35.83 | 35.85 | 35.81 | 35.84 | 451900.0 |
| 2004-10-27 09:30:00 | QQQ | ETF | 35.84 | 35.893 | 35.75 | 35.76 | 11259900.0 |
| 2004-10-27 10:00:00 | QQQ | ETF | 35.751 | 35.96 | 35.71 | 35.93 | 11172100.0 |
| 2004-10-27 10:30:00 | QQQ | ETF | 35.925 | 36.34 | 35.89 | 36.3 | 17826700.0 |
| 2004-10-27 11:00:00 | QQQ | ETF | 36.338 | 36.693 | 36.3 | 36.54 | 23062800.0 |
| 2004-10-27 11:30:00 | QQQ | ETF | 36.54 | 36.67 | 36.52 | 36.6 | 9703400.0 |
| 2004-10-27 12:00:00 | QQQ | ETF | 36.59 | 36.64 | 36.484 | 36.621 | 9628100.0 |
| 2004-10-27 12:30:00 | QQQ | ETF | 36.63 | 36.63 | 36.55 | 36.61 | 4001600.0 |
| 2004-10-27 13:00:00 | QQQ | ETF | 36.61 | 36.79 | 36.6 | 36.69 | 12121800.0 |
| 2004-10-27 13:30:00 | QQQ | ETF | 36.69 | 36.74 | 36.646 | 36.71 | 4586500.0 |
| 2004-10-27 14:00:00 | QQQ | ETF | 36.71 | 36.78 | 36.67 | 36.7 | 8133500.0 |
| 2004-10-27 14:30:00 | QQQ | ETF | 36.71 | 36.78 | 36.67 | 36.78 | 5753000.0 |
| 2004-10-27 15:00:00 | QQQ | ETF | 36.78 | 36.87 | 36.73 | 36.827 | 12149600.0 |
| 2004-10-27 15:30:00 | QQQ | ETF | 36.821 | 36.89 | 36.72 | 36.79 | 12906900.0 |
| 2004-10-27 16:00:00 | QQQ | ETF | 36.771 | 36.8 | 36.71 | 36.8 | 3291000.0 |
| 2004-10-27 16:30:00 | QQQ | ETF | 36.719 | 36.72 | 36.697 | 36.7 | 287400.0 |
| 2004-10-27 17:00:00 | QQQ | ETF | 36.71 | 36.73 | 36.7 | 36.72 | 292500.0 |
| 2004-10-27 17:30:00 | QQQ | ETF | 36.71 | 36.74 | 36.7 | 36.71 | 39200.0 |
| 2004-10-27 18:00:00 | QQQ | ETF | 36.72 | 36.75 | 36.71 | 36.75 | 65300.0 |
| 2004-10-27 18:30:00 | QQQ | ETF | 36.77 | 36.78 | 36.76 | 36.78 | 68400.0 |
| 2004-10-27 19:00:00 | QQQ | ETF | 36.77 | 36.78 | 36.76 | 36.76 | 17400.0 |
| 2004-10-27 19:30:00 | QQQ | ETF | 36.76 | 36.78 | 36.76 | 36.78 | 12100.0 |
| 2004-10-27 08:00:00 | IWM | ETF | 57.71 | 57.71 | 57.675 | 57.675 | 4200.0 |
| 2004-10-27 08:30:00 | IWM | ETF | 57.755 | 57.755 | 57.755 | 57.755 | 4000.0 |
> showing 50 of 1,294 rows — these rows as CSV