PREVIEW / etf_30min / 2002-08-07
file: by_date/etf_30min/2002/2002-08-07.parquet size: 20 KB rows: 554
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-08-07 09:30:00 | SPY | ETF | 87.87 | 88.5 | 86.6 | 86.95 | 6511200.0 |
| 2002-08-07 10:00:00 | SPY | ETF | 86.88 | 87.35 | 86.67 | 86.89 | 3404600.0 |
| 2002-08-07 10:30:00 | SPY | ETF | 86.99 | 87.3 | 86.7 | 86.85 | 2310200.0 |
| 2002-08-07 11:00:00 | SPY | ETF | 86.83 | 86.87 | 86.18 | 86.35 | 2648400.0 |
| 2002-08-07 11:30:00 | SPY | ETF | 86.37 | 86.95 | 86.24 | 86.64 | 2935900.0 |
| 2002-08-07 12:00:00 | SPY | ETF | 86.64 | 86.78 | 86.3 | 86.69 | 1235900.0 |
| 2002-08-07 12:30:00 | SPY | ETF | 86.65 | 86.79 | 86.39 | 86.68 | 965100.0 |
| 2002-08-07 13:00:00 | SPY | ETF | 86.62 | 86.7 | 86.14 | 86.25 | 1513300.0 |
| 2002-08-07 13:30:00 | SPY | ETF | 86.25 | 86.3 | 85.9 | 86.14 | 1570700.0 |
| 2002-08-07 14:00:00 | SPY | ETF | 86.13 | 86.15 | 85.77 | 86.04 | 1835000.0 |
| 2002-08-07 14:30:00 | SPY | ETF | 86.06 | 87.05 | 85.86 | 86.77 | 3555800.0 |
| 2002-08-07 15:00:00 | SPY | ETF | 86.8 | 87.78 | 86.61 | 87.57 | 4738400.0 |
| 2002-08-07 15:30:00 | SPY | ETF | 87.6 | 88.25 | 87.42 | 88.17 | 5229300.0 |
| 2002-08-07 16:00:00 | SPY | ETF | 88.2 | 88.27 | 88.01 | 88.1 | 1929700.0 |
| 2002-08-07 09:30:00 | QQQ | ETF | 23.2 | 23.37 | 22.74 | 22.86 | 23471500.0 |
| 2002-08-07 10:00:00 | QQQ | ETF | 22.83 | 22.99 | 22.6 | 22.61 | 10416900.0 |
| 2002-08-07 10:30:00 | QQQ | ETF | 22.61 | 22.8 | 22.58 | 22.62 | 6484900.0 |
| 2002-08-07 11:00:00 | QQQ | ETF | 22.63 | 22.63 | 22.3 | 22.36 | 8567100.0 |
| 2002-08-07 11:30:00 | QQQ | ETF | 22.38 | 22.57 | 22.35 | 22.44 | 6222300.0 |
| 2002-08-07 12:00:00 | QQQ | ETF | 22.45 | 22.46 | 22.25 | 22.43 | 4333800.0 |
| 2002-08-07 12:30:00 | QQQ | ETF | 22.42 | 22.44 | 22.29 | 22.36 | 2251800.0 |
| 2002-08-07 13:00:00 | QQQ | ETF | 22.37 | 22.38 | 22.06 | 22.11 | 4667900.0 |
| 2002-08-07 13:30:00 | QQQ | ETF | 22.08 | 22.16 | 21.96 | 22.09 | 5676900.0 |
| 2002-08-07 14:00:00 | QQQ | ETF | 22.09 | 22.14 | 21.97 | 22.07 | 4198600.0 |
| 2002-08-07 14:30:00 | QQQ | ETF | 22.08 | 22.65 | 22.04 | 22.5 | 13173700.0 |
| 2002-08-07 15:00:00 | QQQ | ETF | 22.53 | 22.8 | 22.4 | 22.73 | 13180500.0 |
| 2002-08-07 15:30:00 | QQQ | ETF | 22.73 | 22.97 | 22.67 | 22.84 | 15327200.0 |
| 2002-08-07 16:00:00 | QQQ | ETF | 22.84 | 22.88 | 22.78 | 22.8 | 985000.0 |
| 2002-08-07 09:30:00 | IWM | ETF | 38.375 | 38.675 | 37.875 | 37.97 | 419200.0 |
| 2002-08-07 10:00:00 | IWM | ETF | 37.9 | 38.1 | 37.82 | 37.835 | 185600.0 |
| 2002-08-07 10:30:00 | IWM | ETF | 37.83 | 37.99 | 37.795 | 37.845 | 94200.0 |
| 2002-08-07 11:00:00 | IWM | ETF | 37.725 | 37.745 | 37.445 | 37.46 | 128200.0 |
| 2002-08-07 11:30:00 | IWM | ETF | 37.455 | 37.795 | 37.455 | 37.77 | 647000.0 |
| 2002-08-07 12:00:00 | IWM | ETF | 37.685 | 37.775 | 37.675 | 37.71 | 20600.0 |
| 2002-08-07 12:30:00 | IWM | ETF | 37.72 | 37.725 | 37.64 | 37.64 | 105400.0 |
| 2002-08-07 13:00:00 | IWM | ETF | 37.69 | 37.7 | 37.63 | 37.63 | 4200.0 |
| 2002-08-07 13:30:00 | IWM | ETF | 37.505 | 37.55 | 37.425 | 37.505 | 33400.0 |
| 2002-08-07 14:00:00 | IWM | ETF | 37.55 | 37.725 | 37.405 | 37.48 | 51600.0 |
| 2002-08-07 14:30:00 | IWM | ETF | 37.505 | 37.945 | 37.505 | 37.825 | 359400.0 |
| 2002-08-07 15:00:00 | IWM | ETF | 37.805 | 38.235 | 37.805 | 38.175 | 290200.0 |
| 2002-08-07 15:30:00 | IWM | ETF | 38.2 | 38.45 | 38.1 | 38.25 | 790600.0 |
| 2002-08-07 16:00:00 | IWM | ETF | 38.225 | 38.225 | 38.22 | 38.22 | 11000.0 |
| 2002-08-07 09:30:00 | DIA | ETF | 84.01 | 84.85 | 82.8 | 83.13 | 2491200.0 |
| 2002-08-07 10:00:00 | DIA | ETF | 83.16 | 83.64 | 82.9 | 83.19 | 1156600.0 |
| 2002-08-07 10:30:00 | DIA | ETF | 83.18 | 83.59 | 83.06 | 83.19 | 550000.0 |
| 2002-08-07 11:00:00 | DIA | ETF | 83.22 | 83.24 | 82.51 | 82.76 | 844300.0 |
| 2002-08-07 11:30:00 | DIA | ETF | 82.73 | 83.37 | 82.6 | 83.03 | 582700.0 |
| 2002-08-07 12:00:00 | DIA | ETF | 83.06 | 83.33 | 82.75 | 83.19 | 382000.0 |
| 2002-08-07 12:30:00 | DIA | ETF | 83.12 | 83.26 | 82.85 | 83.08 | 154400.0 |
| 2002-08-07 13:00:00 | DIA | ETF | 83.1 | 83.14 | 82.62 | 82.74 | 418600.0 |
> showing 50 of 554 rows — these rows as CSV