PREVIEW / etf_1hour / 2002-07-22
file: by_date/etf_1hour/2002/2002-07-22.parquet size: 15 KB rows: 335
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-22 09:00:00 | SPY | ETF | 84.1 | 85.91 | 84.0 | 85.06 | 9624300.0 |
| 2002-07-22 10:00:00 | SPY | ETF | 85.06 | 85.33 | 83.98 | 84.3 | 7763200.0 |
| 2002-07-22 11:00:00 | SPY | ETF | 84.39 | 84.5 | 82.15 | 82.61 | 10668500.0 |
| 2002-07-22 12:00:00 | SPY | ETF | 82.63 | 82.97 | 81.45 | 82.56 | 10722000.0 |
| 2002-07-22 13:00:00 | SPY | ETF | 82.64 | 84.64 | 82.17 | 84.64 | 13309500.0 |
| 2002-07-22 14:00:00 | SPY | ETF | 84.65 | 84.8 | 82.9 | 83.05 | 8304000.0 |
| 2002-07-22 15:00:00 | SPY | ETF | 83.01 | 84.11 | 82.03 | 82.21 | 10940900.0 |
| 2002-07-22 16:00:00 | SPY | ETF | 82.26 | 82.5 | 82.08 | 82.2 | 1789300.0 |
| 2002-07-22 09:00:00 | QQQ | ETF | 23.85 | 24.48 | 23.77 | 24.06 | 19696000.0 |
| 2002-07-22 10:00:00 | QQQ | ETF | 24.05 | 24.15 | 23.61 | 23.82 | 19548600.0 |
| 2002-07-22 11:00:00 | QQQ | ETF | 23.83 | 23.85 | 23.1 | 23.35 | 19925700.0 |
| 2002-07-22 12:00:00 | QQQ | ETF | 23.35 | 23.65 | 23.09 | 23.59 | 20887500.0 |
| 2002-07-22 13:00:00 | QQQ | ETF | 23.57 | 24.07 | 23.34 | 24.01 | 25248800.0 |
| 2002-07-22 14:00:00 | QQQ | ETF | 24.07 | 24.12 | 23.44 | 23.45 | 17955800.0 |
| 2002-07-22 15:00:00 | QQQ | ETF | 23.45 | 23.83 | 23.28 | 23.38 | 19922300.0 |
| 2002-07-22 16:00:00 | QQQ | ETF | 23.36 | 23.4 | 23.32 | 23.4 | 1416000.0 |
| 2002-07-22 09:00:00 | IWM | ETF | 38.3 | 38.895 | 38.3 | 38.745 | 192400.0 |
| 2002-07-22 10:00:00 | IWM | ETF | 38.745 | 38.75 | 38.26 | 38.345 | 318600.0 |
| 2002-07-22 11:00:00 | IWM | ETF | 38.34 | 38.405 | 37.575 | 37.745 | 371400.0 |
| 2002-07-22 12:00:00 | IWM | ETF | 37.745 | 37.745 | 37.3 | 37.46 | 657600.0 |
| 2002-07-22 13:00:00 | IWM | ETF | 37.485 | 38.105 | 37.38 | 38.105 | 458600.0 |
| 2002-07-22 14:00:00 | IWM | ETF | 38.115 | 38.275 | 37.9 | 38.015 | 613600.0 |
| 2002-07-22 15:00:00 | IWM | ETF | 38.015 | 38.05 | 37.625 | 37.705 | 342800.0 |
| 2002-07-22 16:00:00 | IWM | ETF | 37.75 | 37.95 | 37.725 | 37.855 | 19800.0 |
| 2002-07-22 09:00:00 | DIA | ETF | 79.37 | 81.49 | 79.25 | 80.44 | 2568200.0 |
| 2002-07-22 10:00:00 | DIA | ETF | 80.42 | 80.8 | 79.55 | 80.1 | 2906700.0 |
| 2002-07-22 11:00:00 | DIA | ETF | 80.15 | 80.24 | 77.83 | 78.45 | 3700600.0 |
| 2002-07-22 12:00:00 | DIA | ETF | 78.39 | 78.7 | 77.1 | 78.2 | 3578400.0 |
| 2002-07-22 13:00:00 | DIA | ETF | 78.2 | 80.7 | 77.8 | 80.58 | 3507600.0 |
| 2002-07-22 14:00:00 | DIA | ETF | 80.57 | 80.9 | 78.6 | 78.77 | 3254100.0 |
| 2002-07-22 15:00:00 | DIA | ETF | 78.82 | 79.8 | 77.7 | 77.91 | 4024800.0 |
| 2002-07-22 16:00:00 | DIA | ETF | 77.8 | 78.15 | 77.8 | 78.06 | 176900.0 |
> showing 32 of 335 rows — these rows as CSV