PREVIEW / etf_30min / 2002-04-09
file: by_date/etf_30min/2002/2002-04-09.parquet size: 18 KB rows: 485
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-04-09 09:30:00 | SPY | ETF | 113.18 | 113.18 | 112.83 | 113.09 | 3027900.0 |
| 2002-04-09 10:00:00 | SPY | ETF | 113.07 | 113.17 | 112.51 | 112.6 | 1267300.0 |
| 2002-04-09 10:30:00 | SPY | ETF | 112.61 | 112.78 | 112.52 | 112.67 | 645100.0 |
| 2002-04-09 11:00:00 | SPY | ETF | 112.66 | 112.68 | 112.37 | 112.51 | 763100.0 |
| 2002-04-09 11:30:00 | SPY | ETF | 112.5 | 112.74 | 112.46 | 112.58 | 701100.0 |
| 2002-04-09 12:00:00 | SPY | ETF | 112.56 | 112.77 | 112.39 | 112.71 | 614200.0 |
| 2002-04-09 12:30:00 | SPY | ETF | 112.75 | 112.76 | 112.56 | 112.59 | 420700.0 |
| 2002-04-09 13:00:00 | SPY | ETF | 112.59 | 112.6 | 112.32 | 112.46 | 494100.0 |
| 2002-04-09 13:30:00 | SPY | ETF | 112.46 | 112.57 | 112.18 | 112.21 | 625500.0 |
| 2002-04-09 14:00:00 | SPY | ETF | 112.21 | 112.45 | 112.1 | 112.4 | 664000.0 |
| 2002-04-09 14:30:00 | SPY | ETF | 112.43 | 112.68 | 112.39 | 112.5 | 989200.0 |
| 2002-04-09 15:00:00 | SPY | ETF | 112.51 | 112.54 | 112.01 | 112.01 | 967700.0 |
| 2002-04-09 15:30:00 | SPY | ETF | 112.04 | 112.36 | 111.93 | 112.07 | 1557100.0 |
| 2002-04-09 16:00:00 | SPY | ETF | 112.05 | 112.22 | 112.02 | 112.2 | 807200.0 |
| 2002-04-09 16:30:00 | SPY | ETF | 112.08 | 112.17 | 112.08 | 112.17 | 1251000.0 |
| 2002-04-09 17:00:00 | SPY | ETF | 112.14 | 112.14 | 112.14 | 112.14 | 500.0 |
| 2002-04-09 09:30:00 | QQQ | ETF | 34.78 | 34.98 | 34.63 | 34.68 | 9974200.0 |
| 2002-04-09 10:00:00 | QQQ | ETF | 34.68 | 34.71 | 34.29 | 34.38 | 8542300.0 |
| 2002-04-09 10:30:00 | QQQ | ETF | 34.37 | 34.53 | 34.34 | 34.37 | 4789600.0 |
| 2002-04-09 11:00:00 | QQQ | ETF | 34.38 | 34.44 | 34.1 | 34.14 | 6090900.0 |
| 2002-04-09 11:30:00 | QQQ | ETF | 34.14 | 34.34 | 34.11 | 34.11 | 3024900.0 |
| 2002-04-09 12:00:00 | QQQ | ETF | 34.15 | 34.19 | 34.03 | 34.12 | 2793300.0 |
| 2002-04-09 12:30:00 | QQQ | ETF | 34.12 | 34.15 | 33.93 | 33.93 | 2868000.0 |
| 2002-04-09 13:00:00 | QQQ | ETF | 33.94 | 34.0 | 33.81 | 33.92 | 3605600.0 |
| 2002-04-09 13:30:00 | QQQ | ETF | 33.92 | 33.99 | 33.71 | 33.72 | 5881100.0 |
| 2002-04-09 14:00:00 | QQQ | ETF | 33.72 | 33.97 | 33.66 | 33.92 | 4288900.0 |
| 2002-04-09 14:30:00 | QQQ | ETF | 33.91 | 34.09 | 33.85 | 33.94 | 7232400.0 |
| 2002-04-09 15:00:00 | QQQ | ETF | 33.91 | 33.95 | 33.57 | 33.6 | 4486800.0 |
| 2002-04-09 15:30:00 | QQQ | ETF | 33.57 | 33.69 | 33.49 | 33.5 | 9411800.0 |
| 2002-04-09 16:00:00 | QQQ | ETF | 33.52 | 33.65 | 33.5 | 33.64 | 4055800.0 |
| 2002-04-09 16:30:00 | QQQ | ETF | 33.59 | 33.68 | 33.49 | 33.59 | 36100.0 |
| 2002-04-09 17:00:00 | QQQ | ETF | 33.58 | 33.64 | 33.55 | 33.57 | 21500.0 |
| 2002-04-09 17:30:00 | QQQ | ETF | 33.57 | 33.61 | 33.56 | 33.57 | 261800.0 |
| 2002-04-09 18:00:00 | QQQ | ETF | 33.57 | 33.64 | 33.55 | 33.55 | 25300.0 |
| 2002-04-09 09:30:00 | IWM | ETF | 50.17 | 50.27 | 50.02 | 50.25 | 208000.0 |
| 2002-04-09 10:00:00 | IWM | ETF | 50.27 | 50.27 | 50.11 | 50.14 | 17000.0 |
| 2002-04-09 10:30:00 | IWM | ETF | 50.2 | 50.345 | 50.13 | 50.29 | 32000.0 |
| 2002-04-09 11:00:00 | IWM | ETF | 50.345 | 50.345 | 50.17 | 50.23 | 15000.0 |
| 2002-04-09 11:30:00 | IWM | ETF | 50.23 | 50.26 | 50.18 | 50.25 | 3400.0 |
| 2002-04-09 12:00:00 | IWM | ETF | 50.225 | 50.315 | 50.225 | 50.315 | 16800.0 |
| 2002-04-09 12:30:00 | IWM | ETF | 50.285 | 50.325 | 50.255 | 50.295 | 228200.0 |
| 2002-04-09 13:00:00 | IWM | ETF | 50.295 | 50.295 | 50.175 | 50.265 | 78600.0 |
| 2002-04-09 13:30:00 | IWM | ETF | 50.265 | 50.265 | 50.125 | 50.125 | 19400.0 |
| 2002-04-09 14:00:00 | IWM | ETF | 50.125 | 50.19 | 50.125 | 50.19 | 12200.0 |
| 2002-04-09 14:30:00 | IWM | ETF | 50.19 | 50.27 | 50.17 | 50.25 | 48800.0 |
| 2002-04-09 15:00:00 | IWM | ETF | 50.25 | 50.25 | 50.055 | 50.1 | 79600.0 |
| 2002-04-09 15:30:00 | IWM | ETF | 50.04 | 50.145 | 49.965 | 49.985 | 168400.0 |
| 2002-04-09 16:00:00 | IWM | ETF | 50.575 | 50.575 | 50.575 | 50.575 | 5200.0 |
| 2002-04-09 09:30:00 | DIA | ETF | 103.17 | 103.22 | 102.76 | 103.15 | 1425100.0 |
| 2002-04-09 10:00:00 | DIA | ETF | 103.15 | 103.2 | 102.66 | 102.79 | 702400.0 |
> showing 50 of 485 rows — these rows as CSV