PREVIEW / etf_1hour / 2002-07-29
file: by_date/etf_1hour/2002/2002-07-29.parquet size: 15 KB rows: 344
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-07-29 09:00:00 | SPY | ETF | 87.5 | 87.85 | 87.3 | 87.4 | 5889700.0 |
| 2002-07-29 10:00:00 | SPY | ETF | 87.4 | 88.85 | 87.32 | 88.55 | 11836200.0 |
| 2002-07-29 11:00:00 | SPY | ETF | 88.5 | 89.09 | 88.1 | 88.94 | 6229500.0 |
| 2002-07-29 12:00:00 | SPY | ETF | 88.94 | 89.18 | 88.57 | 88.98 | 3402200.0 |
| 2002-07-29 13:00:00 | SPY | ETF | 89.0 | 89.46 | 88.66 | 89.24 | 4975600.0 |
| 2002-07-29 14:00:00 | SPY | ETF | 89.29 | 89.66 | 89.02 | 89.32 | 5463300.0 |
| 2002-07-29 15:00:00 | SPY | ETF | 89.3 | 90.34 | 89.26 | 90.23 | 10162900.0 |
| 2002-07-29 16:00:00 | SPY | ETF | 90.29 | 90.33 | 89.7 | 89.77 | 1554500.0 |
| 2002-07-29 09:00:00 | QQQ | ETF | 23.27 | 23.45 | 23.14 | 23.2 | 15534500.0 |
| 2002-07-29 10:00:00 | QQQ | ETF | 23.24 | 23.58 | 23.16 | 23.43 | 16814400.0 |
| 2002-07-29 11:00:00 | QQQ | ETF | 23.41 | 23.69 | 23.3 | 23.59 | 11583400.0 |
| 2002-07-29 12:00:00 | QQQ | ETF | 23.6 | 23.89 | 23.55 | 23.82 | 9969400.0 |
| 2002-07-29 13:00:00 | QQQ | ETF | 23.8 | 24.02 | 23.65 | 23.92 | 9929800.0 |
| 2002-07-29 14:00:00 | QQQ | ETF | 23.9 | 24.03 | 23.81 | 23.86 | 9193800.0 |
| 2002-07-29 15:00:00 | QQQ | ETF | 23.85 | 24.12 | 23.83 | 24.0 | 17356700.0 |
| 2002-07-29 16:00:00 | QQQ | ETF | 24.04 | 24.05 | 23.83 | 23.83 | 1236800.0 |
| 2002-07-29 09:00:00 | IWM | ETF | 39.15 | 39.22 | 38.75 | 38.875 | 258400.0 |
| 2002-07-29 10:00:00 | IWM | ETF | 38.85 | 39.465 | 38.85 | 39.45 | 628400.0 |
| 2002-07-29 11:00:00 | IWM | ETF | 39.37 | 39.595 | 39.25 | 39.575 | 198000.0 |
| 2002-07-29 12:00:00 | IWM | ETF | 39.51 | 39.715 | 39.4 | 39.62 | 122200.0 |
| 2002-07-29 13:00:00 | IWM | ETF | 39.625 | 39.75 | 39.5 | 39.74 | 111600.0 |
| 2002-07-29 14:00:00 | IWM | ETF | 39.65 | 39.925 | 39.6 | 39.74 | 212200.0 |
| 2002-07-29 15:00:00 | IWM | ETF | 39.75 | 40.15 | 39.715 | 40.0 | 604000.0 |
| 2002-07-29 16:00:00 | IWM | ETF | 39.95 | 40.115 | 39.755 | 39.775 | 106400.0 |
| 2002-07-29 09:00:00 | DIA | ETF | 84.4 | 84.74 | 84.3 | 84.37 | 1936200.0 |
| 2002-07-29 10:00:00 | DIA | ETF | 84.37 | 86.05 | 84.28 | 85.66 | 3574300.0 |
| 2002-07-29 11:00:00 | DIA | ETF | 85.65 | 86.15 | 85.2 | 85.92 | 1686300.0 |
| 2002-07-29 12:00:00 | DIA | ETF | 85.91 | 86.1 | 85.53 | 85.93 | 1159600.0 |
| 2002-07-29 13:00:00 | DIA | ETF | 85.92 | 86.42 | 85.63 | 86.07 | 1320200.0 |
| 2002-07-29 14:00:00 | DIA | ETF | 86.15 | 86.61 | 85.9 | 86.27 | 1866700.0 |
| 2002-07-29 15:00:00 | DIA | ETF | 86.27 | 87.26 | 86.23 | 87.25 | 2563600.0 |
| 2002-07-29 16:00:00 | DIA | ETF | 87.25 | 87.3 | 86.72 | 86.72 | 229000.0 |
> showing 32 of 344 rows — these rows as CSV