PREVIEW / etf_30min / 2004-09-21
file: by_date/etf_30min/2004/2004-09-21.parquet size: 35 KB rows: 1,170
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-09-21 08:00:00 | SPY | ETF | 112.74 | 112.79 | 112.74 | 112.79 | 9700.0 |
| 2004-09-21 08:30:00 | SPY | ETF | 112.8 | 112.83 | 112.75 | 112.8 | 14200.0 |
| 2004-09-21 09:00:00 | SPY | ETF | 112.79 | 112.8 | 112.69 | 112.74 | 78100.0 |
| 2004-09-21 09:30:00 | SPY | ETF | 112.75 | 112.79 | 112.59 | 112.6 | 3490800.0 |
| 2004-09-21 10:00:00 | SPY | ETF | 112.61 | 112.75 | 112.54 | 112.6 | 2527000.0 |
| 2004-09-21 10:30:00 | SPY | ETF | 112.6 | 112.72 | 112.57 | 112.71 | 1240900.0 |
| 2004-09-21 11:00:00 | SPY | ETF | 112.71 | 112.86 | 112.7 | 112.75 | 1780700.0 |
| 2004-09-21 11:30:00 | SPY | ETF | 112.73 | 112.84 | 112.73 | 112.76 | 1627800.0 |
| 2004-09-21 12:00:00 | SPY | ETF | 112.78 | 112.84 | 112.73 | 112.76 | 859300.0 |
| 2004-09-21 12:30:00 | SPY | ETF | 112.76 | 112.87 | 112.76 | 112.85 | 627000.0 |
| 2004-09-21 13:00:00 | SPY | ETF | 112.8215 | 112.92 | 112.81 | 112.82 | 1254300.0 |
| 2004-09-21 13:30:00 | SPY | ETF | 112.82 | 112.96 | 112.8 | 112.94 | 888500.0 |
| 2004-09-21 14:00:00 | SPY | ETF | 112.94 | 113.14 | 112.79 | 112.88 | 6681500.0 |
| 2004-09-21 14:30:00 | SPY | ETF | 112.89 | 113.43 | 112.85 | 113.39 | 5195800.0 |
| 2004-09-21 15:00:00 | SPY | ETF | 113.39 | 113.47 | 113.26 | 113.26 | 5020800.0 |
| 2004-09-21 15:30:00 | SPY | ETF | 113.26 | 113.31 | 113.16 | 113.24 | 4255000.0 |
| 2004-09-21 16:00:00 | SPY | ETF | 113.24 | 113.25 | 112.93 | 112.97 | 1913600.0 |
| 2004-09-21 16:30:00 | SPY | ETF | 112.96 | 112.97 | 112.89 | 112.95 | 145800.0 |
| 2004-09-21 17:00:00 | SPY | ETF | 112.95 | 112.95 | 112.92 | 112.94 | 18300.0 |
| 2004-09-21 17:30:00 | SPY | ETF | 112.96 | 112.96 | 112.93 | 112.93 | 1400.0 |
| 2004-09-21 18:00:00 | SPY | ETF | 112.96 | 112.96 | 112.95 | 112.95 | 5400.0 |
| 2004-09-21 18:30:00 | SPY | ETF | 112.93 | 112.93 | 112.88 | 112.88 | 12900.0 |
| 2004-09-21 08:00:00 | QQQ | ETF | 35.53 | 35.59 | 35.53 | 35.59 | 76400.0 |
| 2004-09-21 08:30:00 | QQQ | ETF | 35.59 | 35.6 | 35.57 | 35.58 | 106000.0 |
| 2004-09-21 09:00:00 | QQQ | ETF | 35.58 | 35.6 | 35.54 | 35.54 | 264200.0 |
| 2004-09-21 09:30:00 | QQQ | ETF | 35.543 | 35.602 | 35.45 | 35.52 | 12225000.0 |
| 2004-09-21 10:00:00 | QQQ | ETF | 35.517 | 35.564 | 35.44 | 35.51 | 7321700.0 |
| 2004-09-21 10:30:00 | QQQ | ETF | 35.51 | 35.56 | 35.467 | 35.53 | 3811100.0 |
| 2004-09-21 11:00:00 | QQQ | ETF | 35.53 | 35.61 | 35.52 | 35.56 | 4025900.0 |
| 2004-09-21 11:30:00 | QQQ | ETF | 35.56 | 35.592 | 35.53 | 35.55 | 1637300.0 |
| 2004-09-21 12:00:00 | QQQ | ETF | 35.54 | 35.59 | 35.52 | 35.54 | 2106500.0 |
| 2004-09-21 12:30:00 | QQQ | ETF | 35.53 | 35.58 | 35.53 | 35.58 | 1448500.0 |
| 2004-09-21 13:00:00 | QQQ | ETF | 35.58 | 35.601 | 35.57 | 35.58 | 1451700.0 |
| 2004-09-21 13:30:00 | QQQ | ETF | 35.576 | 35.68 | 35.57 | 35.65 | 2370700.0 |
| 2004-09-21 14:00:00 | QQQ | ETF | 35.65 | 35.73 | 35.53 | 35.57 | 12915500.0 |
| 2004-09-21 14:30:00 | QQQ | ETF | 35.57 | 35.81 | 35.56 | 35.806 | 11673900.0 |
| 2004-09-21 15:00:00 | QQQ | ETF | 35.809 | 35.84 | 35.72 | 35.73 | 12478400.0 |
| 2004-09-21 15:30:00 | QQQ | ETF | 35.731 | 35.75 | 35.66 | 35.67 | 8766700.0 |
| 2004-09-21 16:00:00 | QQQ | ETF | 35.67 | 35.71 | 35.543 | 35.6 | 3552500.0 |
| 2004-09-21 16:30:00 | QQQ | ETF | 35.581 | 35.71 | 35.55 | 35.57 | 5884200.0 |
| 2004-09-21 17:00:00 | QQQ | ETF | 35.57 | 35.57 | 35.56 | 35.57 | 22200.0 |
| 2004-09-21 17:30:00 | QQQ | ETF | 35.58 | 35.58 | 35.56 | 35.58 | 16200.0 |
| 2004-09-21 18:00:00 | QQQ | ETF | 35.58 | 35.58 | 35.56 | 35.56 | 20700.0 |
| 2004-09-21 18:30:00 | QQQ | ETF | 35.57 | 35.57 | 35.55 | 35.55 | 25800.0 |
| 2004-09-21 19:00:00 | QQQ | ETF | 35.56 | 35.57 | 35.56 | 35.57 | 7300.0 |
| 2004-09-21 19:30:00 | QQQ | ETF | 35.55 | 35.55 | 35.55 | 35.55 | 800.0 |
| 2004-09-21 08:30:00 | IWM | ETF | 57.175 | 57.175 | 57.175 | 57.175 | 1000.0 |
| 2004-09-21 09:00:00 | IWM | ETF | 57.215 | 57.215 | 57.16 | 57.16 | 6200.0 |
| 2004-09-21 09:30:00 | IWM | ETF | 57.185 | 57.265 | 57.105 | 57.25 | 912400.0 |
| 2004-09-21 10:00:00 | IWM | ETF | 57.25 | 57.25 | 57.14 | 57.16 | 538200.0 |
> showing 50 of 1,170 rows — these rows as CSV