PREVIEW / etf_1hour / 2002-02-08
file: by_date/etf_1hour/2002/2002-02-08.parquet size: 13 KB rows: 290
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-08 09:00:00 | SPY | ETF | 108.63 | 109.11 | 108.48 | 108.85 | 2522800.0 |
| 2002-02-08 10:00:00 | SPY | ETF | 108.92 | 109.38 | 108.78 | 109.0 | 2927500.0 |
| 2002-02-08 11:00:00 | SPY | ETF | 109.0 | 109.44 | 108.7 | 108.83 | 1954400.0 |
| 2002-02-08 12:00:00 | SPY | ETF | 108.8 | 108.84 | 108.35 | 108.56 | 1734300.0 |
| 2002-02-08 13:00:00 | SPY | ETF | 108.55 | 108.8 | 108.3 | 108.67 | 1230500.0 |
| 2002-02-08 14:00:00 | SPY | ETF | 108.67 | 109.05 | 108.33 | 109.03 | 1279400.0 |
| 2002-02-08 15:00:00 | SPY | ETF | 109.01 | 110.04 | 109.0 | 109.92 | 4424500.0 |
| 2002-02-08 16:00:00 | SPY | ETF | 109.97 | 110.49 | 109.5 | 110.1 | 1656000.0 |
| 2002-02-08 17:00:00 | SPY | ETF | 110.1 | 110.15 | 110.1 | 110.15 | 400.0 |
| 2002-02-08 18:00:00 | SPY | ETF | 110.1 | 110.1 | 110.1 | 110.1 | 200.0 |
| 2002-02-08 09:00:00 | QQQ | ETF | 35.46 | 35.69 | 35.31 | 35.38 | 10818800.0 |
| 2002-02-08 10:00:00 | QQQ | ETF | 35.35 | 35.68 | 35.26 | 35.55 | 13787300.0 |
| 2002-02-08 11:00:00 | QQQ | ETF | 35.61 | 35.76 | 35.2 | 35.35 | 9863800.0 |
| 2002-02-08 12:00:00 | QQQ | ETF | 35.31 | 35.37 | 35.0 | 35.12 | 9183100.0 |
| 2002-02-08 13:00:00 | QQQ | ETF | 35.12 | 35.28 | 34.97 | 35.15 | 6058800.0 |
| 2002-02-08 14:00:00 | QQQ | ETF | 35.17 | 35.52 | 35.03 | 35.5 | 8547100.0 |
| 2002-02-08 15:00:00 | QQQ | ETF | 35.5 | 36.13 | 35.45 | 36.08 | 19331500.0 |
| 2002-02-08 16:00:00 | QQQ | ETF | 36.09 | 36.3 | 35.97 | 36.2 | 2080300.0 |
| 2002-02-08 17:00:00 | QQQ | ETF | 36.2 | 36.25 | 36.16 | 36.2 | 40100.0 |
| 2002-02-08 18:00:00 | QQQ | ETF | 36.21 | 36.25 | 36.16 | 36.25 | 17000.0 |
| 2002-02-08 09:00:00 | IWM | ETF | 45.605 | 45.775 | 45.6 | 45.76 | 70000.0 |
| 2002-02-08 10:00:00 | IWM | ETF | 45.74 | 45.865 | 45.715 | 45.83 | 121600.0 |
| 2002-02-08 11:00:00 | IWM | ETF | 45.825 | 45.865 | 45.7 | 45.715 | 537600.0 |
| 2002-02-08 12:00:00 | IWM | ETF | 45.725 | 45.75 | 45.455 | 45.515 | 124200.0 |
| 2002-02-08 13:00:00 | IWM | ETF | 45.605 | 45.645 | 45.5 | 45.645 | 305400.0 |
| 2002-02-08 14:00:00 | IWM | ETF | 45.565 | 45.745 | 45.565 | 45.735 | 170400.0 |
| 2002-02-08 15:00:00 | IWM | ETF | 45.75 | 46.395 | 45.75 | 46.285 | 346600.0 |
| 2002-02-08 16:00:00 | IWM | ETF | 46.375 | 46.6 | 46.105 | 46.105 | 62000.0 |
| 2002-02-08 09:00:00 | DIA | ETF | 96.6 | 96.84 | 96.2 | 96.65 | 693600.0 |
| 2002-02-08 10:00:00 | DIA | ETF | 96.62 | 97.13 | 96.56 | 96.8 | 454800.0 |
| 2002-02-08 11:00:00 | DIA | ETF | 96.9 | 97.22 | 96.54 | 96.66 | 340200.0 |
| 2002-02-08 12:00:00 | DIA | ETF | 96.71 | 96.71 | 96.27 | 96.45 | 482400.0 |
| 2002-02-08 13:00:00 | DIA | ETF | 96.45 | 96.57 | 95.85 | 96.4 | 1219000.0 |
| 2002-02-08 14:00:00 | DIA | ETF | 96.4 | 96.7 | 96.11 | 96.6 | 246200.0 |
| 2002-02-08 15:00:00 | DIA | ETF | 96.57 | 97.55 | 96.57 | 97.5 | 888900.0 |
| 2002-02-08 16:00:00 | DIA | ETF | 97.52 | 97.72 | 97.44 | 97.67 | 41800.0 |
| 2002-02-08 17:00:00 | DIA | ETF | 97.58 | 97.58 | 97.58 | 97.58 | 100.0 |
> showing 37 of 290 rows — these rows as CSV