PREVIEW / etf_1hour / 2002-02-04
file: by_date/etf_1hour/2002/2002-02-04.parquet size: 14 KB rows: 296
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-04 09:00:00 | SPY | ETF | 112.23 | 112.23 | 111.48 | 111.75 | 3429300.0 |
| 2002-02-04 10:00:00 | SPY | ETF | 111.71 | 111.83 | 111.02 | 111.12 | 3278500.0 |
| 2002-02-04 11:00:00 | SPY | ETF | 111.18 | 111.26 | 110.62 | 110.76 | 1947500.0 |
| 2002-02-04 12:00:00 | SPY | ETF | 110.76 | 110.83 | 110.27 | 110.37 | 3289000.0 |
| 2002-02-04 13:00:00 | SPY | ETF | 110.42 | 110.56 | 110.06 | 110.53 | 3810000.0 |
| 2002-02-04 14:00:00 | SPY | ETF | 110.52 | 110.66 | 110.18 | 110.3 | 2501700.0 |
| 2002-02-04 15:00:00 | SPY | ETF | 110.32 | 110.42 | 109.44 | 109.69 | 4920900.0 |
| 2002-02-04 16:00:00 | SPY | ETF | 109.7 | 109.87 | 109.5 | 109.8 | 1017400.0 |
| 2002-02-04 17:00:00 | SPY | ETF | 109.85 | 109.99 | 109.85 | 109.99 | 2900.0 |
| 2002-02-04 18:00:00 | SPY | ETF | 109.98 | 110.0 | 109.95 | 110.0 | 3600.0 |
| 2002-02-04 09:00:00 | QQQ | ETF | 37.96 | 38.07 | 37.61 | 37.81 | 7783800.0 |
| 2002-02-04 10:00:00 | QQQ | ETF | 37.81 | 37.88 | 37.22 | 37.27 | 16335200.0 |
| 2002-02-04 11:00:00 | QQQ | ETF | 37.3 | 37.39 | 36.96 | 37.05 | 9549900.0 |
| 2002-02-04 12:00:00 | QQQ | ETF | 37.02 | 37.3 | 36.97 | 37.16 | 13176400.0 |
| 2002-02-04 13:00:00 | QQQ | ETF | 37.16 | 37.2 | 36.91 | 37.16 | 6933600.0 |
| 2002-02-04 14:00:00 | QQQ | ETF | 37.12 | 37.26 | 36.94 | 36.97 | 7269500.0 |
| 2002-02-04 15:00:00 | QQQ | ETF | 37.0 | 37.05 | 36.61 | 36.79 | 19876300.0 |
| 2002-02-04 16:00:00 | QQQ | ETF | 36.78 | 37.0 | 36.75 | 36.91 | 1658800.0 |
| 2002-02-04 17:00:00 | QQQ | ETF | 36.9 | 36.94 | 36.86 | 36.92 | 28300.0 |
| 2002-02-04 18:00:00 | QQQ | ETF | 36.89 | 36.96 | 36.88 | 36.9 | 10200.0 |
| 2002-02-04 09:00:00 | IWM | ETF | 47.625 | 47.705 | 47.43 | 47.435 | 217200.0 |
| 2002-02-04 10:00:00 | IWM | ETF | 47.48 | 47.505 | 47.24 | 47.255 | 37400.0 |
| 2002-02-04 11:00:00 | IWM | ETF | 47.325 | 47.345 | 47.14 | 47.14 | 25000.0 |
| 2002-02-04 12:00:00 | IWM | ETF | 47.14 | 47.175 | 46.955 | 47.0 | 410200.0 |
| 2002-02-04 13:00:00 | IWM | ETF | 47.025 | 47.025 | 46.85 | 46.975 | 577000.0 |
| 2002-02-04 14:00:00 | IWM | ETF | 46.925 | 47.09 | 46.85 | 46.85 | 768000.0 |
| 2002-02-04 15:00:00 | IWM | ETF | 46.85 | 46.85 | 46.555 | 46.625 | 687200.0 |
| 2002-02-04 16:00:00 | IWM | ETF | 46.645 | 46.7 | 46.645 | 46.7 | 65200.0 |
| 2002-02-04 09:00:00 | DIA | ETF | 99.1 | 99.1 | 98.36 | 98.63 | 1079400.0 |
| 2002-02-04 10:00:00 | DIA | ETF | 98.66 | 98.72 | 98.18 | 98.33 | 1297000.0 |
| 2002-02-04 11:00:00 | DIA | ETF | 98.38 | 98.49 | 97.86 | 97.96 | 1463600.0 |
| 2002-02-04 12:00:00 | DIA | ETF | 97.95 | 98.0 | 97.4 | 97.6 | 517400.0 |
| 2002-02-04 13:00:00 | DIA | ETF | 97.51 | 97.62 | 97.24 | 97.6 | 1003900.0 |
| 2002-02-04 14:00:00 | DIA | ETF | 97.6 | 97.76 | 97.32 | 97.34 | 630700.0 |
| 2002-02-04 15:00:00 | DIA | ETF | 97.37 | 97.52 | 96.78 | 96.91 | 831800.0 |
| 2002-02-04 16:00:00 | DIA | ETF | 96.98 | 97.06 | 96.83 | 97.0 | 44900.0 |
| 2002-02-04 17:00:00 | DIA | ETF | 97.0 | 97.25 | 96.31 | 96.7 | 2000.0 |
> showing 37 of 296 rows — these rows as CSV