PREVIEW / etf_30min / 2002-11-11
file: by_date/etf_30min/2002/2002-11-11.parquet size: 21 KB rows: 618
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-11-11 08:00:00 | SPY | ETF | 89.52 | 89.52 | 89.42 | 89.42 | 3100.0 |
| 2002-11-11 08:30:00 | SPY | ETF | 89.5 | 89.5 | 89.5 | 89.5 | 900.0 |
| 2002-11-11 09:00:00 | SPY | ETF | 89.43 | 89.52 | 89.43 | 89.52 | 3100.0 |
| 2002-11-11 09:30:00 | SPY | ETF | 89.51 | 89.56 | 88.87 | 88.99 | 2723200.0 |
| 2002-11-11 10:00:00 | SPY | ETF | 88.97 | 89.23 | 88.82 | 89.0 | 2994500.0 |
| 2002-11-11 10:30:00 | SPY | ETF | 89.03 | 89.21 | 88.73 | 89.04 | 1372100.0 |
| 2002-11-11 11:00:00 | SPY | ETF | 89.05 | 89.2 | 88.75 | 88.8 | 3202500.0 |
| 2002-11-11 11:30:00 | SPY | ETF | 88.85 | 88.92 | 88.61 | 88.84 | 1424800.0 |
| 2002-11-11 12:00:00 | SPY | ETF | 88.8 | 88.88 | 88.3 | 88.5 | 3305000.0 |
| 2002-11-11 12:30:00 | SPY | ETF | 88.5 | 88.62 | 88.3 | 88.57 | 1358600.0 |
| 2002-11-11 13:00:00 | SPY | ETF | 88.6 | 88.83 | 88.41 | 88.76 | 1589500.0 |
| 2002-11-11 13:30:00 | SPY | ETF | 88.72 | 88.93 | 88.69 | 88.71 | 1249600.0 |
| 2002-11-11 14:00:00 | SPY | ETF | 88.7 | 88.8 | 88.48 | 88.53 | 1222000.0 |
| 2002-11-11 14:30:00 | SPY | ETF | 88.5 | 88.77 | 88.38 | 88.6 | 1243800.0 |
| 2002-11-11 15:00:00 | SPY | ETF | 88.58 | 88.63 | 87.8 | 88.0 | 3877900.0 |
| 2002-11-11 15:30:00 | SPY | ETF | 88.03 | 88.24 | 87.87 | 88.05 | 3713200.0 |
| 2002-11-11 16:00:00 | SPY | ETF | 88.03 | 88.31 | 88.02 | 88.15 | 1279200.0 |
| 2002-11-11 16:30:00 | SPY | ETF | 88.14 | 88.3 | 88.02 | 88.26 | 332300.0 |
| 2002-11-11 17:00:00 | SPY | ETF | 88.24 | 88.29 | 88.22 | 88.22 | 76700.0 |
| 2002-11-11 17:30:00 | SPY | ETF | 88.16 | 88.16 | 88.12 | 88.15 | 1400.0 |
| 2002-11-11 18:00:00 | SPY | ETF | 88.16 | 88.23 | 88.14 | 88.2 | 18900.0 |
| 2002-11-11 19:00:00 | SPY | ETF | 88.16 | 88.16 | 88.16 | 88.16 | 200.0 |
| 2002-11-11 19:30:00 | SPY | ETF | 88.16 | 88.16 | 88.11 | 88.11 | 700.0 |
| 2002-11-11 08:00:00 | QQQ | ETF | 24.95 | 25.05 | 24.92 | 25.05 | 18900.0 |
| 2002-11-11 08:30:00 | QQQ | ETF | 25.01 | 25.04 | 25.0 | 25.0 | 15400.0 |
| 2002-11-11 09:00:00 | QQQ | ETF | 25.02 | 25.05 | 24.98 | 24.98 | 5800.0 |
| 2002-11-11 09:30:00 | QQQ | ETF | 24.95 | 25.02 | 24.57 | 24.67 | 14206800.0 |
| 2002-11-11 10:00:00 | QQQ | ETF | 24.68 | 24.74 | 24.51 | 24.59 | 5573300.0 |
| 2002-11-11 10:30:00 | QQQ | ETF | 24.56 | 24.69 | 24.44 | 24.54 | 5720900.0 |
| 2002-11-11 11:00:00 | QQQ | ETF | 24.55 | 24.67 | 24.46 | 24.5 | 5388400.0 |
| 2002-11-11 11:30:00 | QQQ | ETF | 24.5 | 24.5 | 24.39 | 24.43 | 4748700.0 |
| 2002-11-11 12:00:00 | QQQ | ETF | 24.43 | 24.44 | 24.3 | 24.37 | 4066900.0 |
| 2002-11-11 12:30:00 | QQQ | ETF | 24.37 | 24.46 | 24.31 | 24.44 | 2679300.0 |
| 2002-11-11 13:00:00 | QQQ | ETF | 24.44 | 24.54 | 24.35 | 24.48 | 2558100.0 |
| 2002-11-11 13:30:00 | QQQ | ETF | 24.51 | 24.59 | 24.44 | 24.45 | 3396600.0 |
| 2002-11-11 14:00:00 | QQQ | ETF | 24.44 | 24.5 | 24.35 | 24.36 | 2602200.0 |
| 2002-11-11 14:30:00 | QQQ | ETF | 24.36 | 24.46 | 24.32 | 24.4 | 2273400.0 |
| 2002-11-11 15:00:00 | QQQ | ETF | 24.36 | 24.4 | 24.15 | 24.3 | 7229400.0 |
| 2002-11-11 15:30:00 | QQQ | ETF | 24.31 | 24.4 | 24.19 | 24.25 | 7285700.0 |
| 2002-11-11 16:00:00 | QQQ | ETF | 24.23 | 24.38 | 24.22 | 24.35 | 1318400.0 |
| 2002-11-11 16:30:00 | QQQ | ETF | 24.36 | 24.47 | 24.26 | 24.33 | 138400.0 |
| 2002-11-11 17:00:00 | QQQ | ETF | 24.32 | 24.32 | 24.27 | 24.3 | 35200.0 |
| 2002-11-11 17:30:00 | QQQ | ETF | 24.3 | 24.32 | 24.2 | 24.22 | 213600.0 |
| 2002-11-11 18:00:00 | QQQ | ETF | 24.25 | 24.26 | 24.2 | 24.22 | 54600.0 |
| 2002-11-11 18:30:00 | QQQ | ETF | 24.21 | 24.21 | 24.21 | 24.21 | 900.0 |
| 2002-11-11 19:00:00 | QQQ | ETF | 24.24 | 24.24 | 24.23 | 24.24 | 1000.0 |
| 2002-11-11 19:30:00 | QQQ | ETF | 24.23 | 24.24 | 24.23 | 24.23 | 1800.0 |
| 2002-11-11 09:30:00 | IWM | ETF | 37.725 | 37.725 | 37.425 | 37.435 | 258000.0 |
| 2002-11-11 10:00:00 | IWM | ETF | 37.405 | 37.54 | 37.37 | 37.38 | 225000.0 |
| 2002-11-11 10:30:00 | IWM | ETF | 37.425 | 37.44 | 37.285 | 37.35 | 76000.0 |
> showing 50 of 618 rows — these rows as CSV