PREVIEW / etf_30min / 2002-10-16
file: by_date/etf_30min/2002/2002-10-16.parquet size: 22 KB rows: 621
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 |
|---|---|---|---|---|---|---|---|
| 2002-10-16 08:00:00 | SPY | ETF | 87.67 | 87.67 | 87.5 | 87.5 | 3900.0 |
| 2002-10-16 08:30:00 | SPY | ETF | 87.69 | 87.69 | 87.5 | 87.5 | 3100.0 |
| 2002-10-16 09:00:00 | SPY | ETF | 87.5 | 87.5 | 87.15 | 87.17 | 16000.0 |
| 2002-10-16 09:30:00 | SPY | ETF | 87.41 | 87.8 | 87.18 | 87.7 | 8533300.0 |
| 2002-10-16 10:00:00 | SPY | ETF | 87.7 | 87.78 | 86.7 | 86.8 | 7066600.0 |
| 2002-10-16 10:30:00 | SPY | ETF | 86.74 | 87.1 | 86.6 | 86.92 | 5760200.0 |
| 2002-10-16 11:00:00 | SPY | ETF | 86.91 | 87.06 | 86.66 | 86.74 | 3689500.0 |
| 2002-10-16 11:30:00 | SPY | ETF | 86.79 | 87.01 | 86.42 | 86.55 | 4024700.0 |
| 2002-10-16 12:00:00 | SPY | ETF | 86.55 | 86.56 | 86.1 | 86.4 | 4823500.0 |
| 2002-10-16 12:30:00 | SPY | ETF | 86.4 | 86.63 | 86.16 | 86.43 | 1603600.0 |
| 2002-10-16 13:00:00 | SPY | ETF | 86.39 | 86.56 | 86.12 | 86.44 | 1927800.0 |
| 2002-10-16 13:30:00 | SPY | ETF | 86.45 | 86.47 | 86.08 | 86.13 | 2479700.0 |
| 2002-10-16 14:00:00 | SPY | ETF | 86.13 | 86.5 | 85.92 | 86.39 | 3978300.0 |
| 2002-10-16 14:30:00 | SPY | ETF | 86.39 | 86.59 | 86.1 | 86.32 | 2980200.0 |
| 2002-10-16 15:00:00 | SPY | ETF | 86.33 | 86.7 | 86.22 | 86.34 | 4410500.0 |
| 2002-10-16 15:30:00 | SPY | ETF | 86.34 | 86.48 | 86.0 | 86.32 | 4099800.0 |
| 2002-10-16 16:00:00 | SPY | ETF | 86.4 | 87.68 | 86.3 | 86.55 | 5431100.0 |
| 2002-10-16 16:30:00 | SPY | ETF | 86.55 | 87.11 | 86.5 | 86.88 | 296100.0 |
| 2002-10-16 17:00:00 | SPY | ETF | 86.94 | 87.49 | 86.09 | 87.45 | 806000.0 |
| 2002-10-16 17:30:00 | SPY | ETF | 87.49 | 87.75 | 87.44 | 87.66 | 683300.0 |
| 2002-10-16 18:00:00 | SPY | ETF | 87.72 | 88.15 | 87.7 | 87.81 | 61300.0 |
| 2002-10-16 18:30:00 | SPY | ETF | 87.73 | 87.73 | 87.73 | 87.73 | 1600.0 |
| 2002-10-16 19:00:00 | SPY | ETF | 87.85 | 87.85 | 87.82 | 87.82 | 200.0 |
| 2002-10-16 19:30:00 | SPY | ETF | 87.9 | 87.93 | 87.86 | 87.93 | 800.0 |
| 2002-10-16 08:30:00 | QQQ | ETF | 22.84 | 22.9 | 22.82 | 22.89 | 17700.0 |
| 2002-10-16 09:00:00 | QQQ | ETF | 22.79 | 22.79 | 22.69 | 22.72 | 13500.0 |
| 2002-10-16 09:30:00 | QQQ | ETF | 22.71 | 23.14 | 22.7 | 22.99 | 18777400.0 |
| 2002-10-16 10:00:00 | QQQ | ETF | 23.09 | 23.16 | 22.81 | 22.86 | 10261800.0 |
| 2002-10-16 10:30:00 | QQQ | ETF | 22.83 | 22.93 | 22.74 | 22.87 | 7161900.0 |
| 2002-10-16 11:00:00 | QQQ | ETF | 22.86 | 22.93 | 22.72 | 22.73 | 4517700.0 |
| 2002-10-16 11:30:00 | QQQ | ETF | 22.73 | 22.84 | 22.68 | 22.75 | 4607500.0 |
| 2002-10-16 12:00:00 | QQQ | ETF | 22.75 | 22.76 | 22.58 | 22.68 | 5013300.0 |
| 2002-10-16 12:30:00 | QQQ | ETF | 22.68 | 22.75 | 22.63 | 22.69 | 2671200.0 |
| 2002-10-16 13:00:00 | QQQ | ETF | 22.67 | 22.73 | 22.55 | 22.65 | 2694700.0 |
| 2002-10-16 13:30:00 | QQQ | ETF | 22.66 | 22.68 | 22.55 | 22.58 | 3349600.0 |
| 2002-10-16 14:00:00 | QQQ | ETF | 22.58 | 22.72 | 22.52 | 22.7 | 5290500.0 |
| 2002-10-16 14:30:00 | QQQ | ETF | 22.69 | 22.75 | 22.59 | 22.65 | 5728700.0 |
| 2002-10-16 15:00:00 | QQQ | ETF | 22.63 | 22.8 | 22.63 | 22.68 | 7932700.0 |
| 2002-10-16 15:30:00 | QQQ | ETF | 22.66 | 22.72 | 22.58 | 22.66 | 5858400.0 |
| 2002-10-16 16:00:00 | QQQ | ETF | 22.68 | 23.3 | 22.63 | 22.81 | 5774300.0 |
| 2002-10-16 16:30:00 | QQQ | ETF | 22.82 | 22.92 | 22.71 | 22.92 | 1294700.0 |
| 2002-10-16 17:00:00 | QQQ | ETF | 22.92 | 23.25 | 22.9 | 23.24 | 1369100.0 |
| 2002-10-16 17:30:00 | QQQ | ETF | 23.22 | 23.28 | 23.12 | 23.2 | 1509400.0 |
| 2002-10-16 18:00:00 | QQQ | ETF | 23.2 | 23.29 | 23.2 | 23.24 | 264200.0 |
| 2002-10-16 18:30:00 | QQQ | ETF | 23.25 | 23.25 | 23.2 | 23.22 | 12100.0 |
| 2002-10-16 19:00:00 | QQQ | ETF | 23.22 | 23.22 | 23.16 | 23.16 | 18900.0 |
| 2002-10-16 19:30:00 | QQQ | ETF | 23.24 | 23.25 | 23.24 | 23.25 | 800.0 |
| 2002-10-16 09:30:00 | IWM | ETF | 35.5 | 35.665 | 35.335 | 35.63 | 191600.0 |
| 2002-10-16 10:00:00 | IWM | ETF | 35.59 | 35.6 | 35.23 | 35.23 | 390600.0 |
| 2002-10-16 10:30:00 | IWM | ETF | 35.215 | 35.275 | 35.085 | 35.105 | 70000.0 |
> showing 50 of 621 rows — these rows as CSV