PREVIEW / etf_30min / 2003-04-21
file: by_date/etf_30min/2003/2003-04-21.parquet size: 21 KB rows: 643
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 |
|---|---|---|---|---|---|---|---|
| 2003-04-21 08:00:00 | SPY | ETF | 89.67 | 89.67 | 89.56 | 89.59 | 9400.0 |
| 2003-04-21 08:30:00 | SPY | ETF | 89.6 | 89.7 | 89.48 | 89.66 | 18100.0 |
| 2003-04-21 09:00:00 | SPY | ETF | 89.68 | 89.85 | 89.67 | 89.85 | 19000.0 |
| 2003-04-21 09:30:00 | SPY | ETF | 89.86 | 90.15 | 89.57 | 90.15 | 4054700.0 |
| 2003-04-21 10:00:00 | SPY | ETF | 90.13 | 90.16 | 89.43 | 89.6 | 3669200.0 |
| 2003-04-21 10:30:00 | SPY | ETF | 89.57 | 89.59 | 89.06 | 89.38 | 2598800.0 |
| 2003-04-21 11:00:00 | SPY | ETF | 89.38 | 89.51 | 89.23 | 89.41 | 1147200.0 |
| 2003-04-21 11:30:00 | SPY | ETF | 89.41 | 89.75 | 89.41 | 89.74 | 1307400.0 |
| 2003-04-21 12:00:00 | SPY | ETF | 89.74 | 89.78 | 89.41 | 89.73 | 1784300.0 |
| 2003-04-21 12:30:00 | SPY | ETF | 89.71 | 89.8 | 89.32 | 89.43 | 1449500.0 |
| 2003-04-21 13:00:00 | SPY | ETF | 89.43 | 89.74 | 89.43 | 89.7 | 764600.0 |
| 2003-04-21 13:30:00 | SPY | ETF | 89.68 | 89.81 | 89.57 | 89.64 | 618500.0 |
| 2003-04-21 14:00:00 | SPY | ETF | 89.64 | 89.69 | 89.23 | 89.33 | 3131500.0 |
| 2003-04-21 14:30:00 | SPY | ETF | 89.3 | 89.65 | 89.27 | 89.41 | 1262300.0 |
| 2003-04-21 15:00:00 | SPY | ETF | 89.46 | 89.74 | 89.33 | 89.45 | 1828700.0 |
| 2003-04-21 15:30:00 | SPY | ETF | 89.45 | 89.67 | 89.29 | 89.5 | 1971600.0 |
| 2003-04-21 16:00:00 | SPY | ETF | 89.51 | 89.79 | 89.46 | 89.67 | 1342500.0 |
| 2003-04-21 16:30:00 | SPY | ETF | 89.63 | 89.68 | 89.54 | 89.58 | 54000.0 |
| 2003-04-21 17:00:00 | SPY | ETF | 89.55 | 89.6 | 89.5 | 89.6 | 10000.0 |
| 2003-04-21 17:30:00 | SPY | ETF | 89.58 | 89.67 | 89.58 | 89.65 | 11200.0 |
| 2003-04-21 18:00:00 | SPY | ETF | 89.63 | 89.69 | 89.62 | 89.67 | 10900.0 |
| 2003-04-21 18:30:00 | SPY | ETF | 89.68 | 89.68 | 89.68 | 89.68 | 4800.0 |
| 2003-04-21 19:00:00 | SPY | ETF | 89.67 | 89.67 | 89.6 | 89.6 | 900.0 |
| 2003-04-21 19:30:00 | SPY | ETF | 89.58 | 89.65 | 89.56 | 89.65 | 2000.0 |
| 2003-04-21 08:00:00 | QQQ | ETF | 26.93 | 26.93 | 26.86 | 26.91 | 29200.0 |
| 2003-04-21 08:30:00 | QQQ | ETF | 26.93 | 26.98 | 26.91 | 26.95 | 32600.0 |
| 2003-04-21 09:00:00 | QQQ | ETF | 26.96 | 26.98 | 26.95 | 26.95 | 41800.0 |
| 2003-04-21 09:30:00 | QQQ | ETF | 26.94 | 27.1 | 26.8 | 27.08 | 9689200.0 |
| 2003-04-21 10:00:00 | QQQ | ETF | 27.08 | 27.1 | 26.64 | 26.74 | 13428200.0 |
| 2003-04-21 10:30:00 | QQQ | ETF | 26.74 | 26.83 | 26.62 | 26.76 | 5197900.0 |
| 2003-04-21 11:00:00 | QQQ | ETF | 26.77 | 26.88 | 26.7 | 26.85 | 3148200.0 |
| 2003-04-21 11:30:00 | QQQ | ETF | 26.84 | 26.96 | 26.78 | 26.95 | 2495000.0 |
| 2003-04-21 12:00:00 | QQQ | ETF | 26.95 | 26.98 | 26.81 | 26.88 | 1707300.0 |
| 2003-04-21 12:30:00 | QQQ | ETF | 26.88 | 26.92 | 26.75 | 26.79 | 1873700.0 |
| 2003-04-21 13:00:00 | QQQ | ETF | 26.79 | 26.88 | 26.77 | 26.88 | 890000.0 |
| 2003-04-21 13:30:00 | QQQ | ETF | 26.86 | 26.9 | 26.82 | 26.88 | 1213800.0 |
| 2003-04-21 14:00:00 | QQQ | ETF | 26.86 | 26.88 | 26.75 | 26.77 | 1595400.0 |
| 2003-04-21 14:30:00 | QQQ | ETF | 26.76 | 26.95 | 26.75 | 26.85 | 2170900.0 |
| 2003-04-21 15:00:00 | QQQ | ETF | 26.85 | 26.94 | 26.8 | 26.86 | 1998700.0 |
| 2003-04-21 15:30:00 | QQQ | ETF | 26.85 | 26.92 | 26.78 | 26.88 | 2267000.0 |
| 2003-04-21 16:00:00 | QQQ | ETF | 26.88 | 26.95 | 26.87 | 26.94 | 1056000.0 |
| 2003-04-21 16:30:00 | QQQ | ETF | 26.94 | 26.94 | 26.86 | 26.88 | 104800.0 |
| 2003-04-21 17:00:00 | QQQ | ETF | 26.9 | 26.9 | 26.85 | 26.86 | 42900.0 |
| 2003-04-21 17:30:00 | QQQ | ETF | 26.88 | 26.88 | 26.85 | 26.87 | 15700.0 |
| 2003-04-21 18:00:00 | QQQ | ETF | 26.86 | 26.88 | 26.85 | 26.86 | 8300.0 |
| 2003-04-21 18:30:00 | QQQ | ETF | 26.85 | 26.88 | 26.85 | 26.86 | 3500.0 |
| 2003-04-21 19:00:00 | QQQ | ETF | 26.87 | 26.88 | 26.87 | 26.87 | 3500.0 |
| 2003-04-21 19:30:00 | QQQ | ETF | 26.87 | 26.87 | 26.85 | 26.85 | 5800.0 |
| 2003-04-21 09:30:00 | IWM | ETF | 38.24 | 38.42 | 38.155 | 38.42 | 140800.0 |
| 2003-04-21 10:00:00 | IWM | ETF | 38.35 | 38.405 | 38.195 | 38.2 | 225800.0 |
> showing 50 of 643 rows — these rows as CSV