PREVIEW / etf_30min / 2002-01-08
file: by_date/etf_30min/2002/2002-01-08.parquet size: 17 KB rows: 444
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-08 09:30:00 | SPY | ETF | 116.79 | 116.9 | 116.42 | 116.79 | 1841500.0 |
| 2002-01-08 10:00:00 | SPY | ETF | 116.78 | 117.06 | 116.51 | 116.68 | 1256700.0 |
| 2002-01-08 10:30:00 | SPY | ETF | 116.71 | 116.83 | 116.28 | 116.32 | 903500.0 |
| 2002-01-08 11:00:00 | SPY | ETF | 116.32 | 116.56 | 116.27 | 116.45 | 676200.0 |
| 2002-01-08 11:30:00 | SPY | ETF | 116.42 | 116.6 | 116.2 | 116.41 | 704200.0 |
| 2002-01-08 12:00:00 | SPY | ETF | 116.44 | 116.5 | 116.27 | 116.44 | 1253200.0 |
| 2002-01-08 12:30:00 | SPY | ETF | 116.45 | 116.56 | 116.33 | 116.38 | 269800.0 |
| 2002-01-08 13:00:00 | SPY | ETF | 116.4 | 116.88 | 116.32 | 116.78 | 525800.0 |
| 2002-01-08 13:30:00 | SPY | ETF | 116.77 | 116.85 | 116.39 | 116.43 | 621700.0 |
| 2002-01-08 14:00:00 | SPY | ETF | 116.4 | 116.46 | 116.1 | 116.12 | 834100.0 |
| 2002-01-08 14:30:00 | SPY | ETF | 116.17 | 116.32 | 116.01 | 116.18 | 704800.0 |
| 2002-01-08 15:00:00 | SPY | ETF | 116.18 | 116.38 | 115.97 | 116.05 | 511200.0 |
| 2002-01-08 15:30:00 | SPY | ETF | 116.1 | 116.36 | 116.06 | 116.36 | 983500.0 |
| 2002-01-08 16:00:00 | SPY | ETF | 116.3 | 116.72 | 116.05 | 116.54 | 894300.0 |
| 2002-01-08 16:30:00 | SPY | ETF | 116.48 | 116.48 | 116.48 | 116.48 | 8000.0 |
| 2002-01-08 17:00:00 | SPY | ETF | 116.54 | 116.65 | 116.54 | 116.65 | 2900.0 |
| 2002-01-08 18:00:00 | SPY | ETF | 116.44 | 116.44 | 116.4 | 116.4 | 3500.0 |
| 2002-01-08 09:30:00 | QQQ | ETF | 41.1 | 41.48 | 40.85 | 41.42 | 11247400.0 |
| 2002-01-08 10:00:00 | QQQ | ETF | 41.42 | 41.66 | 41.23 | 41.4 | 7611300.0 |
| 2002-01-08 10:30:00 | QQQ | ETF | 41.4 | 41.57 | 41.17 | 41.23 | 5159300.0 |
| 2002-01-08 11:00:00 | QQQ | ETF | 41.23 | 41.55 | 41.2 | 41.44 | 4048300.0 |
| 2002-01-08 11:30:00 | QQQ | ETF | 41.44 | 41.57 | 41.2 | 41.39 | 4977800.0 |
| 2002-01-08 12:00:00 | QQQ | ETF | 41.37 | 41.46 | 41.25 | 41.42 | 1713900.0 |
| 2002-01-08 12:30:00 | QQQ | ETF | 41.42 | 41.53 | 41.29 | 41.38 | 2167500.0 |
| 2002-01-08 13:00:00 | QQQ | ETF | 41.36 | 41.77 | 41.32 | 41.75 | 3628000.0 |
| 2002-01-08 13:30:00 | QQQ | ETF | 41.75 | 41.75 | 41.47 | 41.49 | 4830700.0 |
| 2002-01-08 14:00:00 | QQQ | ETF | 41.49 | 41.63 | 41.31 | 41.37 | 3491900.0 |
| 2002-01-08 14:30:00 | QQQ | ETF | 41.36 | 41.49 | 41.24 | 41.38 | 3839500.0 |
| 2002-01-08 15:00:00 | QQQ | ETF | 41.42 | 41.58 | 41.2 | 41.34 | 5240700.0 |
| 2002-01-08 15:30:00 | QQQ | ETF | 41.31 | 41.51 | 41.22 | 41.51 | 5060600.0 |
| 2002-01-08 16:00:00 | QQQ | ETF | 41.45 | 41.57 | 41.41 | 41.42 | 2648200.0 |
| 2002-01-08 16:30:00 | QQQ | ETF | 41.43 | 41.62 | 41.32 | 41.47 | 240000.0 |
| 2002-01-08 17:00:00 | QQQ | ETF | 41.44 | 41.51 | 41.44 | 41.51 | 65600.0 |
| 2002-01-08 17:30:00 | QQQ | ETF | 41.5 | 41.58 | 41.49 | 41.55 | 69500.0 |
| 2002-01-08 18:00:00 | QQQ | ETF | 41.56 | 41.6 | 41.46 | 41.58 | 32700.0 |
| 2002-01-08 09:30:00 | IWM | ETF | 49.125 | 49.125 | 48.65 | 48.87 | 22600.0 |
| 2002-01-08 10:00:00 | IWM | ETF | 48.845 | 49.075 | 48.8 | 49.0 | 35600.0 |
| 2002-01-08 10:30:00 | IWM | ETF | 48.95 | 49.125 | 48.82 | 48.875 | 249000.0 |
| 2002-01-08 11:00:00 | IWM | ETF | 48.885 | 49.0 | 48.885 | 48.945 | 18600.0 |
| 2002-01-08 11:30:00 | IWM | ETF | 48.935 | 48.995 | 48.84 | 48.84 | 11600.0 |
| 2002-01-08 12:00:00 | IWM | ETF | 48.875 | 48.98 | 48.875 | 48.98 | 81400.0 |
| 2002-01-08 12:30:00 | IWM | ETF | 48.985 | 49.055 | 48.93 | 48.93 | 31000.0 |
| 2002-01-08 13:00:00 | IWM | ETF | 49.015 | 49.195 | 48.94 | 49.195 | 41600.0 |
| 2002-01-08 13:30:00 | IWM | ETF | 49.145 | 49.235 | 49.145 | 49.18 | 21000.0 |
| 2002-01-08 14:00:00 | IWM | ETF | 49.105 | 49.2 | 49.05 | 49.125 | 86000.0 |
| 2002-01-08 14:30:00 | IWM | ETF | 49.12 | 49.185 | 49.04 | 49.185 | 99400.0 |
| 2002-01-08 15:00:00 | IWM | ETF | 49.155 | 49.35 | 49.07 | 49.2 | 57600.0 |
| 2002-01-08 15:30:00 | IWM | ETF | 49.215 | 49.585 | 49.13 | 49.585 | 80400.0 |
| 2002-01-08 16:00:00 | IWM | ETF | 49.59 | 49.625 | 49.5 | 49.5 | 3600.0 |
| 2002-01-08 09:30:00 | DIA | ETF | 101.8 | 102.2 | 101.8 | 102.03 | 948400.0 |
> showing 50 of 444 rows — these rows as CSV