PREVIEW / etf_1hour / 2002-01-08
file: by_date/etf_1hour/2002/2002-01-08.parquet size: 13 KB rows: 276
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-01-08 09:00:00 | SPY | ETF | 116.79 | 116.9 | 116.42 | 116.79 | 1841500.0 |
| 2002-01-08 10:00:00 | SPY | ETF | 116.78 | 117.06 | 116.28 | 116.32 | 2160200.0 |
| 2002-01-08 11:00:00 | SPY | ETF | 116.32 | 116.6 | 116.2 | 116.41 | 1380400.0 |
| 2002-01-08 12:00:00 | SPY | ETF | 116.44 | 116.56 | 116.27 | 116.38 | 1523000.0 |
| 2002-01-08 13:00:00 | SPY | ETF | 116.4 | 116.88 | 116.32 | 116.43 | 1147500.0 |
| 2002-01-08 14:00:00 | SPY | ETF | 116.4 | 116.46 | 116.01 | 116.18 | 1538900.0 |
| 2002-01-08 15:00:00 | SPY | ETF | 116.18 | 116.38 | 115.97 | 116.36 | 1494700.0 |
| 2002-01-08 16:00:00 | SPY | ETF | 116.3 | 116.72 | 116.05 | 116.48 | 902300.0 |
| 2002-01-08 17:00:00 | SPY | ETF | 116.54 | 116.65 | 116.54 | 116.65 | 2900.0 |
| 2002-01-08 18:00:00 | SPY | ETF | 116.44 | 116.44 | 116.4 | 116.4 | 3500.0 |
| 2002-01-08 09:00:00 | QQQ | ETF | 41.1 | 41.48 | 40.85 | 41.42 | 11247400.0 |
| 2002-01-08 10:00:00 | QQQ | ETF | 41.42 | 41.66 | 41.17 | 41.23 | 12770600.0 |
| 2002-01-08 11:00:00 | QQQ | ETF | 41.23 | 41.57 | 41.2 | 41.39 | 9026100.0 |
| 2002-01-08 12:00:00 | QQQ | ETF | 41.37 | 41.53 | 41.25 | 41.38 | 3881400.0 |
| 2002-01-08 13:00:00 | QQQ | ETF | 41.36 | 41.77 | 41.32 | 41.49 | 8458700.0 |
| 2002-01-08 14:00:00 | QQQ | ETF | 41.49 | 41.63 | 41.24 | 41.38 | 7331400.0 |
| 2002-01-08 15:00:00 | QQQ | ETF | 41.42 | 41.58 | 41.2 | 41.51 | 10301300.0 |
| 2002-01-08 16:00:00 | QQQ | ETF | 41.45 | 41.62 | 41.32 | 41.47 | 2888200.0 |
| 2002-01-08 17:00:00 | QQQ | ETF | 41.44 | 41.58 | 41.44 | 41.55 | 135100.0 |
| 2002-01-08 18:00:00 | QQQ | ETF | 41.56 | 41.6 | 41.46 | 41.58 | 32700.0 |
| 2002-01-08 09:00:00 | IWM | ETF | 49.125 | 49.125 | 48.65 | 48.87 | 22600.0 |
| 2002-01-08 10:00:00 | IWM | ETF | 48.845 | 49.125 | 48.8 | 48.875 | 284600.0 |
| 2002-01-08 11:00:00 | IWM | ETF | 48.885 | 49.0 | 48.84 | 48.84 | 30200.0 |
| 2002-01-08 12:00:00 | IWM | ETF | 48.875 | 49.055 | 48.875 | 48.93 | 112400.0 |
| 2002-01-08 13:00:00 | IWM | ETF | 49.015 | 49.235 | 48.94 | 49.18 | 62600.0 |
| 2002-01-08 14:00:00 | IWM | ETF | 49.105 | 49.2 | 49.04 | 49.185 | 185400.0 |
| 2002-01-08 15:00:00 | IWM | ETF | 49.155 | 49.585 | 49.07 | 49.585 | 138000.0 |
| 2002-01-08 16:00:00 | IWM | ETF | 49.59 | 49.625 | 49.5 | 49.5 | 3600.0 |
| 2002-01-08 09:00:00 | DIA | ETF | 101.8 | 102.2 | 101.8 | 102.03 | 948400.0 |
| 2002-01-08 10:00:00 | DIA | ETF | 101.92 | 102.24 | 101.5 | 101.55 | 994300.0 |
| 2002-01-08 11:00:00 | DIA | ETF | 101.59 | 101.8 | 101.44 | 101.72 | 697800.0 |
| 2002-01-08 12:00:00 | DIA | ETF | 101.69 | 101.84 | 101.57 | 101.67 | 132400.0 |
| 2002-01-08 13:00:00 | DIA | ETF | 101.66 | 102.1 | 101.65 | 101.75 | 593300.0 |
| 2002-01-08 14:00:00 | DIA | ETF | 101.73 | 101.76 | 101.36 | 101.5 | 557900.0 |
| 2002-01-08 15:00:00 | DIA | ETF | 101.46 | 101.64 | 101.3 | 101.55 | 527600.0 |
| 2002-01-08 16:00:00 | DIA | ETF | 101.64 | 101.74 | 101.59 | 101.74 | 501200.0 |
> showing 36 of 276 rows — these rows as CSV