PREVIEW / etf_30min / 2002-11-19
file: by_date/etf_30min/2002/2002-11-19.parquet size: 21 KB rows: 630
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-19 08:00:00 | SPY | ETF | 90.3 | 90.41 | 90.2 | 90.41 | 3600.0 |
| 2002-11-19 08:30:00 | SPY | ETF | 90.43 | 90.43 | 90.07 | 90.2 | 6900.0 |
| 2002-11-19 09:00:00 | SPY | ETF | 90.15 | 90.19 | 90.0 | 90.13 | 32800.0 |
| 2002-11-19 09:30:00 | SPY | ETF | 90.02 | 90.3 | 89.8 | 89.85 | 3352200.0 |
| 2002-11-19 10:00:00 | SPY | ETF | 89.85 | 90.43 | 89.76 | 90.35 | 2661200.0 |
| 2002-11-19 10:30:00 | SPY | ETF | 90.35 | 90.45 | 89.94 | 90.08 | 3216700.0 |
| 2002-11-19 11:00:00 | SPY | ETF | 90.08 | 90.22 | 89.87 | 90.2 | 1184300.0 |
| 2002-11-19 11:30:00 | SPY | ETF | 90.21 | 90.26 | 89.95 | 90.0 | 678900.0 |
| 2002-11-19 12:00:00 | SPY | ETF | 90.0 | 90.37 | 90.0 | 90.29 | 720700.0 |
| 2002-11-19 12:30:00 | SPY | ETF | 90.29 | 90.85 | 90.19 | 90.75 | 3116600.0 |
| 2002-11-19 13:00:00 | SPY | ETF | 90.75 | 91.1 | 90.61 | 90.65 | 1904500.0 |
| 2002-11-19 13:30:00 | SPY | ETF | 90.64 | 91.1 | 90.6 | 90.92 | 1342600.0 |
| 2002-11-19 14:00:00 | SPY | ETF | 90.92 | 90.97 | 90.41 | 90.5 | 1335000.0 |
| 2002-11-19 14:30:00 | SPY | ETF | 90.47 | 90.63 | 90.17 | 90.17 | 3292800.0 |
| 2002-11-19 15:00:00 | SPY | ETF | 90.16 | 90.42 | 89.86 | 90.0 | 2168000.0 |
| 2002-11-19 15:30:00 | SPY | ETF | 90.0 | 90.24 | 89.77 | 90.23 | 3905200.0 |
| 2002-11-19 16:00:00 | SPY | ETF | 90.25 | 90.38 | 90.15 | 90.3 | 2012800.0 |
| 2002-11-19 16:30:00 | SPY | ETF | 90.35 | 90.45 | 90.29 | 90.3 | 36600.0 |
| 2002-11-19 17:00:00 | SPY | ETF | 90.31 | 90.33 | 90.29 | 90.29 | 12800.0 |
| 2002-11-19 17:30:00 | SPY | ETF | 90.29 | 90.29 | 90.28 | 90.28 | 500.0 |
| 2002-11-19 18:00:00 | SPY | ETF | 90.3 | 90.3 | 90.18 | 90.2 | 7100.0 |
| 2002-11-19 18:30:00 | SPY | ETF | 90.28 | 90.28 | 90.25 | 90.25 | 1100.0 |
| 2002-11-19 08:00:00 | QQQ | ETF | 25.97 | 25.97 | 25.91 | 25.95 | 7000.0 |
| 2002-11-19 08:30:00 | QQQ | ETF | 25.88 | 25.92 | 25.85 | 25.85 | 12700.0 |
| 2002-11-19 09:00:00 | QQQ | ETF | 25.86 | 25.89 | 25.8 | 25.8 | 40400.0 |
| 2002-11-19 09:30:00 | QQQ | ETF | 25.8 | 25.86 | 25.51 | 25.51 | 13721300.0 |
| 2002-11-19 10:00:00 | QQQ | ETF | 25.52 | 25.74 | 25.42 | 25.72 | 9848000.0 |
| 2002-11-19 10:30:00 | QQQ | ETF | 25.72 | 25.78 | 25.52 | 25.61 | 5901900.0 |
| 2002-11-19 11:00:00 | QQQ | ETF | 25.61 | 25.67 | 25.48 | 25.64 | 4758600.0 |
| 2002-11-19 11:30:00 | QQQ | ETF | 25.67 | 25.69 | 25.49 | 25.57 | 3158200.0 |
| 2002-11-19 12:00:00 | QQQ | ETF | 25.51 | 25.67 | 25.5 | 25.6 | 2446000.0 |
| 2002-11-19 12:30:00 | QQQ | ETF | 25.6 | 25.9 | 25.56 | 25.83 | 4978500.0 |
| 2002-11-19 13:00:00 | QQQ | ETF | 25.83 | 26.05 | 25.76 | 25.79 | 8053600.0 |
| 2002-11-19 13:30:00 | QQQ | ETF | 25.79 | 25.99 | 25.75 | 25.87 | 2991800.0 |
| 2002-11-19 14:00:00 | QQQ | ETF | 25.87 | 25.89 | 25.58 | 25.61 | 4710900.0 |
| 2002-11-19 14:30:00 | QQQ | ETF | 25.64 | 25.69 | 25.51 | 25.54 | 4765000.0 |
| 2002-11-19 15:00:00 | QQQ | ETF | 25.54 | 25.6 | 25.35 | 25.44 | 7038800.0 |
| 2002-11-19 15:30:00 | QQQ | ETF | 25.44 | 25.52 | 25.3 | 25.5 | 7142500.0 |
| 2002-11-19 16:00:00 | QQQ | ETF | 25.51 | 25.68 | 25.49 | 25.64 | 2386200.0 |
| 2002-11-19 16:30:00 | QQQ | ETF | 25.67 | 25.67 | 25.58 | 25.61 | 81400.0 |
| 2002-11-19 17:00:00 | QQQ | ETF | 25.62 | 25.63 | 25.59 | 25.6 | 60800.0 |
| 2002-11-19 17:30:00 | QQQ | ETF | 25.6 | 25.61 | 25.58 | 25.59 | 35000.0 |
| 2002-11-19 18:00:00 | QQQ | ETF | 25.61 | 25.61 | 25.55 | 25.55 | 59000.0 |
| 2002-11-19 18:30:00 | QQQ | ETF | 25.6 | 25.6 | 25.59 | 25.59 | 1500.0 |
| 2002-11-19 19:00:00 | QQQ | ETF | 25.58 | 25.58 | 25.57 | 25.57 | 3800.0 |
| 2002-11-19 19:30:00 | QQQ | ETF | 25.57 | 25.57 | 25.57 | 25.57 | 100.0 |
| 2002-11-19 09:30:00 | IWM | ETF | 38.015 | 38.295 | 38.0 | 38.03 | 176000.0 |
| 2002-11-19 10:00:00 | IWM | ETF | 38.025 | 38.17 | 38.025 | 38.14 | 104000.0 |
| 2002-11-19 10:30:00 | IWM | ETF | 38.17 | 38.22 | 38.0 | 38.06 | 97200.0 |
| 2002-11-19 11:00:00 | IWM | ETF | 38.05 | 38.05 | 37.9 | 37.995 | 80600.0 |
> showing 50 of 630 rows — these rows as CSV