PREVIEW / etf_30min / 2003-10-15
file: by_date/etf_30min/2003/2003-10-15.parquet size: 27 KB rows: 820
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-10-15 08:00:00 | SPY | ETF | 105.7 | 105.85 | 105.68 | 105.82 | 70100.0 |
| 2003-10-15 08:30:00 | SPY | ETF | 105.75 | 106.05 | 105.75 | 105.9 | 119400.0 |
| 2003-10-15 09:00:00 | SPY | ETF | 105.9 | 105.92 | 105.85 | 105.85 | 36900.0 |
| 2003-10-15 09:30:00 | SPY | ETF | 105.86 | 105.89 | 105.4 | 105.54 | 7725900.0 |
| 2003-10-15 10:00:00 | SPY | ETF | 105.54 | 105.56 | 104.91 | 105.02 | 5763600.0 |
| 2003-10-15 10:30:00 | SPY | ETF | 105.0 | 105.24 | 104.93 | 105.22 | 2080500.0 |
| 2003-10-15 11:00:00 | SPY | ETF | 105.2 | 105.3 | 105.12 | 105.2 | 1264900.0 |
| 2003-10-15 11:30:00 | SPY | ETF | 105.19 | 105.25 | 105.05 | 105.12 | 920200.0 |
| 2003-10-15 12:00:00 | SPY | ETF | 105.14 | 105.37 | 105.12 | 105.25 | 1504700.0 |
| 2003-10-15 12:30:00 | SPY | ETF | 105.25 | 105.46 | 105.21 | 105.37 | 964100.0 |
| 2003-10-15 13:00:00 | SPY | ETF | 105.37 | 105.37 | 105.17 | 105.28 | 780700.0 |
| 2003-10-15 13:30:00 | SPY | ETF | 105.28 | 105.37 | 105.2 | 105.31 | 1418200.0 |
| 2003-10-15 14:00:00 | SPY | ETF | 105.3 | 105.35 | 105.06 | 105.09 | 1216400.0 |
| 2003-10-15 14:30:00 | SPY | ETF | 105.08 | 105.09 | 104.64 | 104.76 | 5204200.0 |
| 2003-10-15 15:00:00 | SPY | ETF | 104.76 | 104.91 | 104.67 | 104.9 | 2981100.0 |
| 2003-10-15 15:30:00 | SPY | ETF | 104.91 | 105.2 | 104.87 | 105.01 | 2134500.0 |
| 2003-10-15 16:00:00 | SPY | ETF | 105.02 | 105.196 | 104.7 | 104.74 | 2223900.0 |
| 2003-10-15 16:30:00 | SPY | ETF | 104.7 | 105.5 | 104.59 | 104.81 | 321800.0 |
| 2003-10-15 17:00:00 | SPY | ETF | 104.78 | 104.79 | 104.7 | 104.7 | 162800.0 |
| 2003-10-15 17:30:00 | SPY | ETF | 104.69 | 104.78 | 104.52 | 104.67 | 17400.0 |
| 2003-10-15 18:00:00 | SPY | ETF | 104.65 | 104.67 | 104.6 | 104.63 | 8500.0 |
| 2003-10-15 18:30:00 | SPY | ETF | 104.65 | 104.67 | 104.65 | 104.67 | 700.0 |
| 2003-10-15 19:00:00 | SPY | ETF | 104.66 | 104.68 | 104.66 | 104.68 | 2200.0 |
| 2003-10-15 19:30:00 | SPY | ETF | 104.7 | 104.81 | 104.7 | 104.76 | 9800.0 |
| 2003-10-15 08:00:00 | QQQ | ETF | 35.63 | 35.75 | 35.61 | 35.72 | 405300.0 |
| 2003-10-15 08:30:00 | QQQ | ETF | 35.7 | 35.87 | 35.7 | 35.78 | 444700.0 |
| 2003-10-15 09:00:00 | QQQ | ETF | 35.79 | 35.82 | 35.76 | 35.79 | 202600.0 |
| 2003-10-15 09:30:00 | QQQ | ETF | 35.8 | 35.85 | 35.48 | 35.6 | 18184000.0 |
| 2003-10-15 10:00:00 | QQQ | ETF | 35.61 | 35.62 | 35.23 | 35.35 | 13831000.0 |
| 2003-10-15 10:30:00 | QQQ | ETF | 35.35 | 35.44 | 35.24 | 35.418 | 6531400.0 |
| 2003-10-15 11:00:00 | QQQ | ETF | 35.419 | 35.45 | 35.37 | 35.4 | 4598100.0 |
| 2003-10-15 11:30:00 | QQQ | ETF | 35.42 | 35.43 | 35.32 | 35.37 | 2653500.0 |
| 2003-10-15 12:00:00 | QQQ | ETF | 35.37 | 35.46 | 35.37 | 35.41 | 2912000.0 |
| 2003-10-15 12:30:00 | QQQ | ETF | 35.43 | 35.515 | 35.41 | 35.48 | 2969800.0 |
| 2003-10-15 13:00:00 | QQQ | ETF | 35.47 | 35.48 | 35.35 | 35.42 | 2693700.0 |
| 2003-10-15 13:30:00 | QQQ | ETF | 35.42 | 35.47 | 35.37 | 35.438 | 2411000.0 |
| 2003-10-15 14:00:00 | QQQ | ETF | 35.44 | 35.48 | 35.32 | 35.35 | 3204800.0 |
| 2003-10-15 14:30:00 | QQQ | ETF | 35.34 | 35.37 | 35.03 | 35.12 | 10378400.0 |
| 2003-10-15 15:00:00 | QQQ | ETF | 35.12 | 35.22 | 35.09 | 35.164 | 8074100.0 |
| 2003-10-15 15:30:00 | QQQ | ETF | 35.16 | 35.31 | 35.14 | 35.21 | 6468200.0 |
| 2003-10-15 16:00:00 | QQQ | ETF | 35.21 | 35.81 | 35.03 | 35.06 | 3399900.0 |
| 2003-10-15 16:30:00 | QQQ | ETF | 35.06 | 35.57 | 35.01 | 35.08 | 849200.0 |
| 2003-10-15 17:00:00 | QQQ | ETF | 35.08 | 35.08 | 34.95 | 34.95 | 463400.0 |
| 2003-10-15 17:30:00 | QQQ | ETF | 34.96 | 35.0 | 34.87 | 34.96 | 191300.0 |
| 2003-10-15 18:00:00 | QQQ | ETF | 34.96 | 34.97 | 34.91 | 34.94 | 285800.0 |
| 2003-10-15 18:30:00 | QQQ | ETF | 34.94 | 34.96 | 34.93 | 34.95 | 20100.0 |
| 2003-10-15 19:00:00 | QQQ | ETF | 34.97 | 34.98 | 34.96 | 34.98 | 9800.0 |
| 2003-10-15 19:30:00 | QQQ | ETF | 34.98 | 35.0 | 34.95 | 34.97 | 7900.0 |
| 2003-10-15 08:30:00 | IWM | ETF | 53.4 | 53.44 | 53.4 | 53.44 | 4000.0 |
| 2003-10-15 09:00:00 | IWM | ETF | 53.31 | 53.35 | 53.31 | 53.35 | 7000.0 |
> showing 50 of 820 rows — these rows as CSV