PREVIEW / etf_30min / 2002-09-17
file: by_date/etf_30min/2002/2002-09-17.parquet size: 20 KB rows: 581
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-09-17 09:30:00 | SPY | ETF | 90.89 | 91.19 | 90.0 | 90.1 | 7010800.0 |
| 2002-09-17 10:00:00 | SPY | ETF | 90.02 | 90.15 | 89.33 | 89.46 | 4725500.0 |
| 2002-09-17 10:30:00 | SPY | ETF | 89.49 | 89.51 | 88.98 | 89.1 | 3574200.0 |
| 2002-09-17 11:00:00 | SPY | ETF | 89.1 | 89.3 | 88.78 | 89.25 | 2266400.0 |
| 2002-09-17 11:30:00 | SPY | ETF | 89.26 | 89.44 | 89.16 | 89.28 | 3350100.0 |
| 2002-09-17 12:00:00 | SPY | ETF | 89.28 | 89.32 | 88.78 | 88.78 | 2402400.0 |
| 2002-09-17 12:30:00 | SPY | ETF | 88.79 | 88.94 | 88.57 | 88.84 | 3037800.0 |
| 2002-09-17 13:00:00 | SPY | ETF | 88.83 | 89.1 | 88.79 | 89.01 | 1075200.0 |
| 2002-09-17 13:30:00 | SPY | ETF | 89.05 | 89.13 | 88.59 | 88.95 | 3270900.0 |
| 2002-09-17 14:00:00 | SPY | ETF | 88.95 | 89.0 | 88.51 | 88.82 | 2622900.0 |
| 2002-09-17 14:30:00 | SPY | ETF | 88.8 | 88.93 | 88.57 | 88.69 | 1492700.0 |
| 2002-09-17 15:00:00 | SPY | ETF | 88.72 | 88.72 | 87.9 | 88.0 | 4150600.0 |
| 2002-09-17 15:30:00 | SPY | ETF | 87.99 | 88.06 | 87.75 | 87.97 | 4417100.0 |
| 2002-09-17 16:00:00 | SPY | ETF | 87.92 | 88.05 | 87.78 | 87.83 | 980700.0 |
| 2002-09-17 09:30:00 | QQQ | ETF | 23.05 | 23.21 | 22.8 | 22.83 | 16206200.0 |
| 2002-09-17 10:00:00 | QQQ | ETF | 22.83 | 22.9 | 22.67 | 22.7 | 8805800.0 |
| 2002-09-17 10:30:00 | QQQ | ETF | 22.71 | 22.74 | 22.51 | 22.56 | 5951200.0 |
| 2002-09-17 11:00:00 | QQQ | ETF | 22.55 | 22.68 | 22.4 | 22.65 | 8904300.0 |
| 2002-09-17 11:30:00 | QQQ | ETF | 22.65 | 22.76 | 22.59 | 22.68 | 4931100.0 |
| 2002-09-17 12:00:00 | QQQ | ETF | 22.68 | 22.7 | 22.56 | 22.57 | 2919100.0 |
| 2002-09-17 12:30:00 | QQQ | ETF | 22.6 | 22.61 | 22.46 | 22.56 | 4580500.0 |
| 2002-09-17 13:00:00 | QQQ | ETF | 22.57 | 22.66 | 22.52 | 22.61 | 4605200.0 |
| 2002-09-17 13:30:00 | QQQ | ETF | 22.61 | 22.64 | 22.44 | 22.57 | 3639300.0 |
| 2002-09-17 14:00:00 | QQQ | ETF | 22.57 | 22.62 | 22.43 | 22.55 | 3734400.0 |
| 2002-09-17 14:30:00 | QQQ | ETF | 22.55 | 22.62 | 22.48 | 22.56 | 1957500.0 |
| 2002-09-17 15:00:00 | QQQ | ETF | 22.54 | 22.56 | 22.3 | 22.35 | 7754900.0 |
| 2002-09-17 15:30:00 | QQQ | ETF | 22.35 | 22.38 | 22.26 | 22.33 | 7028900.0 |
| 2002-09-17 16:00:00 | QQQ | ETF | 22.34 | 22.37 | 22.18 | 22.18 | 706700.0 |
| 2002-09-17 09:30:00 | IWM | ETF | 38.7 | 38.88 | 38.36 | 38.405 | 77400.0 |
| 2002-09-17 10:00:00 | IWM | ETF | 38.395 | 38.44 | 38.225 | 38.225 | 119200.0 |
| 2002-09-17 10:30:00 | IWM | ETF | 38.235 | 38.235 | 38.05 | 38.09 | 333200.0 |
| 2002-09-17 11:00:00 | IWM | ETF | 38.145 | 38.145 | 37.95 | 38.1 | 227200.0 |
| 2002-09-17 11:30:00 | IWM | ETF | 38.1 | 38.19 | 38.075 | 38.13 | 65600.0 |
| 2002-09-17 12:00:00 | IWM | ETF | 38.125 | 38.135 | 37.93 | 37.935 | 113600.0 |
| 2002-09-17 12:30:00 | IWM | ETF | 37.93 | 37.94 | 37.875 | 37.91 | 269200.0 |
| 2002-09-17 13:00:00 | IWM | ETF | 37.96 | 38.205 | 37.96 | 38.2 | 146400.0 |
| 2002-09-17 13:30:00 | IWM | ETF | 38.15 | 38.15 | 38.025 | 38.13 | 39800.0 |
| 2002-09-17 14:00:00 | IWM | ETF | 38.085 | 38.105 | 37.99 | 38.085 | 76600.0 |
| 2002-09-17 14:30:00 | IWM | ETF | 38.05 | 38.09 | 38.005 | 38.02 | 10600.0 |
| 2002-09-17 15:00:00 | IWM | ETF | 38.075 | 38.125 | 37.82 | 37.83 | 174400.0 |
| 2002-09-17 15:30:00 | IWM | ETF | 37.865 | 37.865 | 37.72 | 37.785 | 484600.0 |
| 2002-09-17 16:00:00 | IWM | ETF | 37.78 | 37.875 | 37.78 | 37.875 | 400600.0 |
| 2002-09-17 09:30:00 | DIA | ETF | 85.02 | 85.29 | 84.25 | 84.33 | 2357400.0 |
| 2002-09-17 10:00:00 | DIA | ETF | 84.34 | 84.42 | 83.62 | 83.77 | 1504000.0 |
| 2002-09-17 10:30:00 | DIA | ETF | 83.77 | 83.87 | 83.3 | 83.45 | 1025200.0 |
| 2002-09-17 11:00:00 | DIA | ETF | 83.47 | 83.54 | 83.12 | 83.5 | 714900.0 |
| 2002-09-17 11:30:00 | DIA | ETF | 83.5 | 83.68 | 83.37 | 83.53 | 592900.0 |
| 2002-09-17 12:00:00 | DIA | ETF | 83.5 | 83.54 | 82.97 | 83.05 | 635100.0 |
| 2002-09-17 12:30:00 | DIA | ETF | 83.0 | 83.09 | 82.69 | 83.03 | 1158600.0 |
| 2002-09-17 13:00:00 | DIA | ETF | 83.02 | 83.27 | 82.97 | 83.14 | 320200.0 |
> showing 50 of 581 rows — these rows as CSV