PREVIEW / etf_1hour / 2002-01-29
file: by_date/etf_1hour/2002/2002-01-29.parquet size: 13 KB rows: 285
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-29 09:00:00 | SPY | ETF | 113.85 | 114.13 | 113.72 | 113.83 | 1849300.0 |
| 2002-01-29 10:00:00 | SPY | ETF | 113.79 | 113.93 | 112.91 | 112.91 | 3545500.0 |
| 2002-01-29 11:00:00 | SPY | ETF | 112.92 | 112.95 | 112.13 | 112.18 | 5291000.0 |
| 2002-01-29 12:00:00 | SPY | ETF | 112.2 | 112.2 | 111.36 | 111.7 | 3625200.0 |
| 2002-01-29 13:00:00 | SPY | ETF | 111.7 | 111.78 | 111.29 | 111.56 | 1967700.0 |
| 2002-01-29 14:00:00 | SPY | ETF | 111.51 | 111.57 | 110.49 | 110.77 | 4566900.0 |
| 2002-01-29 15:00:00 | SPY | ETF | 110.84 | 110.84 | 110.05 | 110.28 | 5390200.0 |
| 2002-01-29 16:00:00 | SPY | ETF | 110.37 | 110.46 | 110.15 | 110.37 | 1337700.0 |
| 2002-01-29 17:00:00 | SPY | ETF | 110.38 | 110.46 | 110.29 | 110.34 | 31000.0 |
| 2002-01-29 18:00:00 | SPY | ETF | 110.38 | 110.38 | 110.23 | 110.23 | 4800.0 |
| 2002-01-29 09:00:00 | QQQ | ETF | 39.13 | 39.4 | 39.04 | 39.26 | 8560900.0 |
| 2002-01-29 10:00:00 | QQQ | ETF | 39.27 | 39.37 | 38.71 | 38.72 | 11626900.0 |
| 2002-01-29 11:00:00 | QQQ | ETF | 38.73 | 38.81 | 38.43 | 38.5 | 9391700.0 |
| 2002-01-29 12:00:00 | QQQ | ETF | 38.46 | 38.48 | 37.9 | 38.2 | 12614500.0 |
| 2002-01-29 13:00:00 | QQQ | ETF | 38.22 | 38.43 | 37.98 | 38.21 | 9134200.0 |
| 2002-01-29 14:00:00 | QQQ | ETF | 38.19 | 38.25 | 37.64 | 37.82 | 13650800.0 |
| 2002-01-29 15:00:00 | QQQ | ETF | 37.81 | 37.95 | 37.51 | 37.87 | 14783800.0 |
| 2002-01-29 16:00:00 | QQQ | ETF | 37.86 | 38.02 | 37.85 | 37.88 | 2789600.0 |
| 2002-01-29 17:00:00 | QQQ | ETF | 37.88 | 38.0 | 37.88 | 37.9 | 76500.0 |
| 2002-01-29 18:00:00 | QQQ | ETF | 37.9 | 37.96 | 37.89 | 37.89 | 18000.0 |
| 2002-01-29 09:00:00 | IWM | ETF | 47.925 | 48.015 | 47.9 | 48.015 | 24200.0 |
| 2002-01-29 10:00:00 | IWM | ETF | 47.875 | 47.93 | 47.4 | 47.425 | 90400.0 |
| 2002-01-29 11:00:00 | IWM | ETF | 47.39 | 47.39 | 47.155 | 47.18 | 53400.0 |
| 2002-01-29 12:00:00 | IWM | ETF | 47.25 | 47.25 | 46.96 | 47.095 | 460000.0 |
| 2002-01-29 13:00:00 | IWM | ETF | 47.095 | 47.19 | 47.01 | 47.11 | 291400.0 |
| 2002-01-29 14:00:00 | IWM | ETF | 47.1 | 47.19 | 46.925 | 47.03 | 166800.0 |
| 2002-01-29 15:00:00 | IWM | ETF | 47.02 | 47.135 | 46.825 | 46.93 | 367200.0 |
| 2002-01-29 16:00:00 | IWM | ETF | 47.1 | 47.125 | 47.1 | 47.105 | 62400.0 |
| 2002-01-29 09:00:00 | DIA | ETF | 98.95 | 99.21 | 98.78 | 98.86 | 296600.0 |
| 2002-01-29 10:00:00 | DIA | ETF | 98.82 | 98.93 | 98.08 | 98.1 | 500400.0 |
| 2002-01-29 11:00:00 | DIA | ETF | 98.1 | 98.12 | 97.46 | 97.53 | 863000.0 |
| 2002-01-29 12:00:00 | DIA | ETF | 97.5 | 97.58 | 96.96 | 97.35 | 416800.0 |
| 2002-01-29 13:00:00 | DIA | ETF | 97.34 | 97.44 | 97.0 | 97.1 | 198500.0 |
| 2002-01-29 14:00:00 | DIA | ETF | 97.15 | 97.16 | 96.4 | 96.74 | 1094400.0 |
| 2002-01-29 15:00:00 | DIA | ETF | 96.79 | 96.79 | 96.2 | 96.31 | 1194900.0 |
| 2002-01-29 16:00:00 | DIA | ETF | 96.33 | 96.99 | 96.08 | 96.3 | 60100.0 |
| 2002-01-29 17:00:00 | DIA | ETF | 96.3 | 96.3 | 96.3 | 96.3 | 100.0 |
> showing 37 of 285 rows — these rows as CSV