PREVIEW / etf_30min / 2002-01-16
file: by_date/etf_30min/2002/2002-01-16.parquet size: 18 KB rows: 488
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-01-16 09:30:00 | SPY | ETF | 114.3 | 114.33 | 113.78 | 114.18 | 3118700.0 |
| 2002-01-16 10:00:00 | SPY | ETF | 114.18 | 114.4 | 113.96 | 114.16 | 1017600.0 |
| 2002-01-16 10:30:00 | SPY | ETF | 114.17 | 114.38 | 113.9 | 113.98 | 718400.0 |
| 2002-01-16 11:00:00 | SPY | ETF | 113.95 | 114.03 | 113.55 | 113.88 | 1250700.0 |
| 2002-01-16 11:30:00 | SPY | ETF | 113.86 | 113.98 | 113.76 | 113.92 | 459200.0 |
| 2002-01-16 12:00:00 | SPY | ETF | 113.92 | 113.99 | 113.75 | 113.81 | 456500.0 |
| 2002-01-16 12:30:00 | SPY | ETF | 113.81 | 114.0 | 113.72 | 113.91 | 817600.0 |
| 2002-01-16 13:00:00 | SPY | ETF | 113.88 | 113.96 | 113.69 | 113.77 | 431200.0 |
| 2002-01-16 13:30:00 | SPY | ETF | 113.77 | 113.98 | 113.68 | 113.77 | 657700.0 |
| 2002-01-16 14:00:00 | SPY | ETF | 113.73 | 114.05 | 113.6 | 114.02 | 1057700.0 |
| 2002-01-16 14:30:00 | SPY | ETF | 114.03 | 114.27 | 114.0 | 114.11 | 1552400.0 |
| 2002-01-16 15:00:00 | SPY | ETF | 114.13 | 114.3 | 113.75 | 113.84 | 1319800.0 |
| 2002-01-16 15:30:00 | SPY | ETF | 113.8 | 113.82 | 113.0 | 113.05 | 1706300.0 |
| 2002-01-16 16:00:00 | SPY | ETF | 113.12 | 113.25 | 112.69 | 112.9 | 1373800.0 |
| 2002-01-16 16:30:00 | SPY | ETF | 112.96 | 113.0 | 112.88 | 112.93 | 39200.0 |
| 2002-01-16 17:00:00 | SPY | ETF | 113.3 | 113.3 | 112.95 | 113.05 | 130200.0 |
| 2002-01-16 17:30:00 | SPY | ETF | 113.04 | 113.05 | 113.04 | 113.05 | 6700.0 |
| 2002-01-16 18:00:00 | SPY | ETF | 113.04 | 113.1 | 113.04 | 113.05 | 4500.0 |
| 2002-01-16 09:30:00 | QQQ | ETF | 39.53 | 39.71 | 39.25 | 39.65 | 12720300.0 |
| 2002-01-16 10:00:00 | QQQ | ETF | 39.65 | 39.76 | 39.43 | 39.56 | 8351900.0 |
| 2002-01-16 10:30:00 | QQQ | ETF | 39.55 | 39.62 | 39.31 | 39.34 | 5253600.0 |
| 2002-01-16 11:00:00 | QQQ | ETF | 39.34 | 39.37 | 39.13 | 39.33 | 7449600.0 |
| 2002-01-16 11:30:00 | QQQ | ETF | 39.33 | 39.47 | 39.21 | 39.42 | 3766600.0 |
| 2002-01-16 12:00:00 | QQQ | ETF | 39.41 | 39.47 | 39.27 | 39.32 | 4367200.0 |
| 2002-01-16 12:30:00 | QQQ | ETF | 39.3 | 39.46 | 39.24 | 39.44 | 2852000.0 |
| 2002-01-16 13:00:00 | QQQ | ETF | 39.44 | 39.45 | 39.26 | 39.32 | 2592700.0 |
| 2002-01-16 13:30:00 | QQQ | ETF | 39.3 | 39.49 | 39.26 | 39.29 | 3398200.0 |
| 2002-01-16 14:00:00 | QQQ | ETF | 39.32 | 39.52 | 39.21 | 39.5 | 6200900.0 |
| 2002-01-16 14:30:00 | QQQ | ETF | 39.5 | 39.67 | 39.46 | 39.54 | 6671500.0 |
| 2002-01-16 15:00:00 | QQQ | ETF | 39.54 | 39.67 | 39.35 | 39.38 | 4295500.0 |
| 2002-01-16 15:30:00 | QQQ | ETF | 39.37 | 39.39 | 38.79 | 38.8 | 15991800.0 |
| 2002-01-16 16:00:00 | QQQ | ETF | 38.8 | 38.94 | 38.77 | 38.89 | 1832200.0 |
| 2002-01-16 16:30:00 | QQQ | ETF | 38.9 | 39.22 | 38.8 | 39.08 | 940500.0 |
| 2002-01-16 17:00:00 | QQQ | ETF | 39.09 | 39.15 | 39.0 | 39.12 | 153200.0 |
| 2002-01-16 17:30:00 | QQQ | ETF | 39.1 | 39.17 | 39.06 | 39.15 | 52700.0 |
| 2002-01-16 18:00:00 | QQQ | ETF | 39.15 | 39.19 | 39.1 | 39.17 | 34500.0 |
| 2002-01-16 09:30:00 | IWM | ETF | 47.75 | 47.85 | 47.58 | 47.805 | 325200.0 |
| 2002-01-16 10:00:00 | IWM | ETF | 47.785 | 47.85 | 47.7 | 47.735 | 159800.0 |
| 2002-01-16 10:30:00 | IWM | ETF | 47.82 | 47.845 | 47.7 | 47.7 | 27800.0 |
| 2002-01-16 11:00:00 | IWM | ETF | 47.7 | 47.75 | 47.57 | 47.57 | 39200.0 |
| 2002-01-16 11:30:00 | IWM | ETF | 47.59 | 47.625 | 47.55 | 47.585 | 22600.0 |
| 2002-01-16 12:00:00 | IWM | ETF | 47.605 | 47.67 | 47.6 | 47.65 | 25600.0 |
| 2002-01-16 12:30:00 | IWM | ETF | 47.58 | 47.71 | 47.57 | 47.7 | 3147200.0 |
| 2002-01-16 13:00:00 | IWM | ETF | 47.75 | 47.75 | 47.675 | 47.675 | 62800.0 |
| 2002-01-16 13:30:00 | IWM | ETF | 47.705 | 47.75 | 47.7 | 47.7 | 17200.0 |
| 2002-01-16 14:00:00 | IWM | ETF | 47.7 | 47.775 | 47.675 | 47.775 | 30600.0 |
| 2002-01-16 14:30:00 | IWM | ETF | 47.72 | 47.845 | 47.72 | 47.845 | 16600.0 |
| 2002-01-16 15:00:00 | IWM | ETF | 47.845 | 47.86 | 47.7 | 47.775 | 78400.0 |
| 2002-01-16 15:30:00 | IWM | ETF | 47.74 | 47.74 | 47.1 | 47.1 | 366000.0 |
| 2002-01-16 16:00:00 | IWM | ETF | 47.2 | 47.32 | 47.1 | 47.32 | 52000.0 |
> showing 50 of 488 rows — these rows as CSV