PREVIEW / etf_1hour / 2002-02-06
file: by_date/etf_1hour/2002/2002-02-06.parquet size: 14 KB rows: 301
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-02-06 09:00:00 | SPY | ETF | 109.65 | 109.74 | 109.19 | 109.3 | 4027500.0 |
| 2002-02-06 10:00:00 | SPY | ETF | 109.22 | 109.69 | 108.06 | 108.56 | 6464900.0 |
| 2002-02-06 11:00:00 | SPY | ETF | 108.6 | 108.85 | 108.1 | 108.65 | 4000400.0 |
| 2002-02-06 12:00:00 | SPY | ETF | 108.6 | 109.34 | 108.22 | 108.98 | 5453400.0 |
| 2002-02-06 13:00:00 | SPY | ETF | 108.95 | 109.56 | 108.86 | 108.92 | 2827100.0 |
| 2002-02-06 14:00:00 | SPY | ETF | 108.9 | 109.23 | 108.57 | 108.73 | 2798000.0 |
| 2002-02-06 15:00:00 | SPY | ETF | 108.78 | 109.05 | 108.51 | 108.7 | 3066400.0 |
| 2002-02-06 16:00:00 | SPY | ETF | 108.72 | 109.21 | 108.55 | 108.7 | 748500.0 |
| 2002-02-06 17:00:00 | SPY | ETF | 109.05 | 109.09 | 108.33 | 108.38 | 97900.0 |
| 2002-02-06 18:00:00 | SPY | ETF | 108.25 | 108.36 | 108.05 | 108.16 | 98900.0 |
| 2002-02-06 09:00:00 | QQQ | ETF | 36.84 | 36.89 | 36.35 | 36.4 | 10702500.0 |
| 2002-02-06 10:00:00 | QQQ | ETF | 36.43 | 36.67 | 35.7 | 35.98 | 21448600.0 |
| 2002-02-06 11:00:00 | QQQ | ETF | 35.94 | 36.13 | 35.71 | 36.01 | 10814800.0 |
| 2002-02-06 12:00:00 | QQQ | ETF | 36.01 | 36.49 | 35.81 | 36.33 | 12708800.0 |
| 2002-02-06 13:00:00 | QQQ | ETF | 36.28 | 36.62 | 36.12 | 36.12 | 11063500.0 |
| 2002-02-06 14:00:00 | QQQ | ETF | 36.15 | 36.35 | 35.89 | 36.02 | 9503200.0 |
| 2002-02-06 15:00:00 | QQQ | ETF | 36.03 | 36.21 | 35.84 | 36.0 | 14554500.0 |
| 2002-02-06 16:00:00 | QQQ | ETF | 36.04 | 36.49 | 35.89 | 36.3 | 4583700.0 |
| 2002-02-06 17:00:00 | QQQ | ETF | 36.3 | 36.31 | 35.57 | 35.57 | 2389600.0 |
| 2002-02-06 18:00:00 | QQQ | ETF | 35.57 | 35.6 | 35.4 | 35.45 | 210200.0 |
| 2002-02-06 09:00:00 | IWM | ETF | 46.525 | 46.725 | 46.44 | 46.52 | 110400.0 |
| 2002-02-06 10:00:00 | IWM | ETF | 46.39 | 46.5 | 45.81 | 46.0 | 198000.0 |
| 2002-02-06 11:00:00 | IWM | ETF | 46.0 | 46.02 | 45.85 | 46.005 | 269800.0 |
| 2002-02-06 12:00:00 | IWM | ETF | 46.025 | 46.28 | 45.92 | 46.15 | 344600.0 |
| 2002-02-06 13:00:00 | IWM | ETF | 46.175 | 46.36 | 46.12 | 46.16 | 55000.0 |
| 2002-02-06 14:00:00 | IWM | ETF | 46.155 | 46.225 | 45.99 | 45.99 | 58400.0 |
| 2002-02-06 15:00:00 | IWM | ETF | 46.0 | 46.1 | 45.775 | 45.805 | 205600.0 |
| 2002-02-06 16:00:00 | IWM | ETF | 45.895 | 46.0 | 45.875 | 46.0 | 36400.0 |
| 2002-02-06 09:00:00 | DIA | ETF | 97.03 | 97.44 | 96.82 | 97.23 | 1112800.0 |
| 2002-02-06 10:00:00 | DIA | ETF | 97.13 | 97.48 | 96.15 | 96.56 | 722500.0 |
| 2002-02-06 11:00:00 | DIA | ETF | 96.6 | 96.87 | 96.26 | 96.76 | 263900.0 |
| 2002-02-06 12:00:00 | DIA | ETF | 96.75 | 97.24 | 96.4 | 96.93 | 870500.0 |
| 2002-02-06 13:00:00 | DIA | ETF | 96.87 | 97.48 | 96.81 | 96.97 | 278700.0 |
| 2002-02-06 14:00:00 | DIA | ETF | 96.92 | 97.22 | 96.7 | 96.93 | 636300.0 |
| 2002-02-06 15:00:00 | DIA | ETF | 96.85 | 97.13 | 96.5 | 96.63 | 273300.0 |
| 2002-02-06 16:00:00 | DIA | ETF | 96.75 | 96.84 | 96.58 | 96.84 | 40100.0 |
| 2002-02-06 17:00:00 | DIA | ETF | 96.92 | 96.92 | 96.3 | 96.3 | 200.0 |
| 2002-02-06 18:00:00 | DIA | ETF | 96.27 | 96.27 | 96.27 | 96.27 | 500.0 |
> showing 38 of 301 rows — these rows as CSV