PREVIEW / etf_1hour / 2002-02-05
file: by_date/etf_1hour/2002/2002-02-05.parquet size: 14 KB rows: 294
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-05 09:00:00 | SPY | ETF | 109.4 | 109.82 | 109.22 | 109.38 | 2138200.0 |
| 2002-02-05 10:00:00 | SPY | ETF | 109.38 | 110.19 | 108.53 | 109.44 | 9916800.0 |
| 2002-02-05 11:00:00 | SPY | ETF | 109.45 | 109.75 | 109.19 | 109.65 | 3039900.0 |
| 2002-02-05 12:00:00 | SPY | ETF | 109.7 | 109.74 | 109.09 | 109.1 | 1567200.0 |
| 2002-02-05 13:00:00 | SPY | ETF | 109.09 | 110.09 | 109.02 | 110.05 | 3278800.0 |
| 2002-02-05 14:00:00 | SPY | ETF | 110.02 | 110.49 | 109.68 | 110.07 | 4318200.0 |
| 2002-02-05 15:00:00 | SPY | ETF | 110.06 | 110.19 | 108.8 | 109.27 | 5428200.0 |
| 2002-02-05 16:00:00 | SPY | ETF | 109.25 | 109.32 | 109.04 | 109.21 | 1085500.0 |
| 2002-02-05 17:00:00 | SPY | ETF | 109.25 | 109.25 | 108.75 | 108.9 | 2212300.0 |
| 2002-02-05 09:00:00 | QQQ | ETF | 36.59 | 36.92 | 36.44 | 36.67 | 10899200.0 |
| 2002-02-05 10:00:00 | QQQ | ETF | 36.66 | 37.18 | 36.19 | 36.76 | 21647500.0 |
| 2002-02-05 11:00:00 | QQQ | ETF | 36.76 | 36.94 | 36.6 | 36.89 | 8209500.0 |
| 2002-02-05 12:00:00 | QQQ | ETF | 36.85 | 36.93 | 36.59 | 36.59 | 3767300.0 |
| 2002-02-05 13:00:00 | QQQ | ETF | 36.6 | 37.11 | 36.55 | 37.07 | 10218200.0 |
| 2002-02-05 14:00:00 | QQQ | ETF | 37.07 | 37.33 | 36.87 | 37.05 | 11160500.0 |
| 2002-02-05 15:00:00 | QQQ | ETF | 37.04 | 37.1 | 36.2 | 36.42 | 17681900.0 |
| 2002-02-05 16:00:00 | QQQ | ETF | 36.42 | 36.42 | 36.28 | 36.31 | 2001200.0 |
| 2002-02-05 17:00:00 | QQQ | ETF | 36.33 | 36.38 | 36.14 | 36.2 | 75200.0 |
| 2002-02-05 18:00:00 | QQQ | ETF | 36.18 | 36.3 | 36.1 | 36.3 | 17800.0 |
| 2002-02-05 09:00:00 | IWM | ETF | 46.575 | 46.72 | 46.4 | 46.5 | 25800.0 |
| 2002-02-05 10:00:00 | IWM | ETF | 46.455 | 46.775 | 46.195 | 46.6 | 393800.0 |
| 2002-02-05 11:00:00 | IWM | ETF | 46.555 | 46.65 | 46.505 | 46.52 | 356200.0 |
| 2002-02-05 12:00:00 | IWM | ETF | 46.525 | 46.595 | 46.5 | 46.555 | 11600.0 |
| 2002-02-05 13:00:00 | IWM | ETF | 46.52 | 46.725 | 46.475 | 46.725 | 419800.0 |
| 2002-02-05 14:00:00 | IWM | ETF | 46.65 | 46.85 | 46.63 | 46.75 | 251600.0 |
| 2002-02-05 15:00:00 | IWM | ETF | 46.72 | 46.74 | 46.315 | 46.575 | 339600.0 |
| 2002-02-05 16:00:00 | IWM | ETF | 46.5 | 46.52 | 46.5 | 46.52 | 6800.0 |
| 2002-02-05 09:00:00 | DIA | ETF | 96.55 | 97.2 | 96.53 | 96.82 | 345900.0 |
| 2002-02-05 10:00:00 | DIA | ETF | 96.84 | 97.75 | 96.1 | 97.05 | 2013200.0 |
| 2002-02-05 11:00:00 | DIA | ETF | 97.05 | 97.25 | 96.75 | 97.23 | 444900.0 |
| 2002-02-05 12:00:00 | DIA | ETF | 97.23 | 97.23 | 96.7 | 96.7 | 389300.0 |
| 2002-02-05 13:00:00 | DIA | ETF | 96.66 | 97.55 | 96.6 | 97.5 | 446100.0 |
| 2002-02-05 14:00:00 | DIA | ETF | 97.5 | 97.84 | 97.22 | 97.48 | 683800.0 |
| 2002-02-05 15:00:00 | DIA | ETF | 97.54 | 97.6 | 96.4 | 96.84 | 1384300.0 |
| 2002-02-05 16:00:00 | DIA | ETF | 96.78 | 96.87 | 96.35 | 96.45 | 33800.0 |
| 2002-02-05 17:00:00 | DIA | ETF | 96.35 | 96.4 | 96.35 | 96.4 | 200.0 |
> showing 36 of 294 rows — these rows as CSV