PREVIEW / etf_1hour / 2002-10-17
file: by_date/etf_1hour/2002/2002-10-17.parquet size: 16 KB rows: 383
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-10-17 08:00:00 | SPY | ETF | 88.59 | 88.84 | 88.45 | 88.69 | 11100.0 |
| 2002-10-17 09:00:00 | SPY | ETF | 88.99 | 89.23 | 88.28 | 88.42 | 10578000.0 |
| 2002-10-17 10:00:00 | SPY | ETF | 88.44 | 88.59 | 87.91 | 88.23 | 10535000.0 |
| 2002-10-17 11:00:00 | SPY | ETF | 88.19 | 88.56 | 88.0 | 88.32 | 5877900.0 |
| 2002-10-17 12:00:00 | SPY | ETF | 88.35 | 88.44 | 87.85 | 88.15 | 7358200.0 |
| 2002-10-17 13:00:00 | SPY | ETF | 88.14 | 88.54 | 88.02 | 88.36 | 3983600.0 |
| 2002-10-17 14:00:00 | SPY | ETF | 88.36 | 88.62 | 87.85 | 88.03 | 7903800.0 |
| 2002-10-17 15:00:00 | SPY | ETF | 88.05 | 88.33 | 87.93 | 88.17 | 7375300.0 |
| 2002-10-17 16:00:00 | SPY | ETF | 88.17 | 89.75 | 88.0 | 88.97 | 8601000.0 |
| 2002-10-17 17:00:00 | SPY | ETF | 89.0 | 89.2 | 88.84 | 88.98 | 350200.0 |
| 2002-10-17 18:00:00 | SPY | ETF | 88.98 | 89.19 | 88.95 | 89.19 | 34100.0 |
| 2002-10-17 19:00:00 | SPY | ETF | 89.09 | 89.19 | 89.09 | 89.17 | 600.0 |
| 2002-10-17 08:00:00 | QQQ | ETF | 23.46 | 23.52 | 23.41 | 23.49 | 66700.0 |
| 2002-10-17 09:00:00 | QQQ | ETF | 23.47 | 23.81 | 23.45 | 23.48 | 18387800.0 |
| 2002-10-17 10:00:00 | QQQ | ETF | 23.47 | 23.55 | 23.3 | 23.44 | 16762800.0 |
| 2002-10-17 11:00:00 | QQQ | ETF | 23.42 | 23.6 | 23.37 | 23.5 | 11228300.0 |
| 2002-10-17 12:00:00 | QQQ | ETF | 23.48 | 23.64 | 23.31 | 23.54 | 9501300.0 |
| 2002-10-17 13:00:00 | QQQ | ETF | 23.54 | 23.73 | 23.51 | 23.6 | 5673200.0 |
| 2002-10-17 14:00:00 | QQQ | ETF | 23.6 | 23.69 | 23.35 | 23.42 | 9260400.0 |
| 2002-10-17 15:00:00 | QQQ | ETF | 23.42 | 23.54 | 23.3 | 23.46 | 12460600.0 |
| 2002-10-17 16:00:00 | QQQ | ETF | 23.45 | 24.2 | 23.08 | 23.9 | 9187800.0 |
| 2002-10-17 17:00:00 | QQQ | ETF | 23.92 | 23.99 | 23.79 | 23.89 | 1817300.0 |
| 2002-10-17 18:00:00 | QQQ | ETF | 23.85 | 23.94 | 23.76 | 23.9 | 388800.0 |
| 2002-10-17 19:00:00 | QQQ | ETF | 23.9 | 23.93 | 23.85 | 23.9 | 31500.0 |
| 2002-10-17 09:00:00 | IWM | ETF | 35.785 | 36.195 | 35.7 | 35.8 | 524600.0 |
| 2002-10-17 10:00:00 | IWM | ETF | 35.8 | 35.92 | 35.675 | 35.795 | 726200.0 |
| 2002-10-17 11:00:00 | IWM | ETF | 35.8 | 35.95 | 35.735 | 35.915 | 154200.0 |
| 2002-10-17 12:00:00 | IWM | ETF | 35.92 | 35.925 | 35.75 | 35.9 | 225800.0 |
| 2002-10-17 13:00:00 | IWM | ETF | 35.875 | 36.04 | 35.875 | 35.985 | 146000.0 |
| 2002-10-17 14:00:00 | IWM | ETF | 35.99 | 36.075 | 35.86 | 35.915 | 269200.0 |
| 2002-10-17 15:00:00 | IWM | ETF | 35.9 | 36.105 | 35.9 | 36.105 | 1663800.0 |
| 2002-10-17 16:00:00 | IWM | ETF | 36.06 | 36.48 | 36.06 | 36.48 | 127000.0 |
| 2002-10-17 17:00:00 | IWM | ETF | 36.14 | 36.535 | 36.14 | 36.535 | 1325600.0 |
| 2002-10-17 08:00:00 | DIA | ETF | 82.78 | 83.15 | 82.78 | 83.05 | 6900.0 |
| 2002-10-17 09:00:00 | DIA | ETF | 83.1 | 83.65 | 82.75 | 82.86 | 2703800.0 |
| 2002-10-17 10:00:00 | DIA | ETF | 82.83 | 83.0 | 82.37 | 82.65 | 2220900.0 |
| 2002-10-17 11:00:00 | DIA | ETF | 82.63 | 82.95 | 82.5 | 82.83 | 1371400.0 |
| 2002-10-17 12:00:00 | DIA | ETF | 82.8 | 82.82 | 82.3 | 82.5 | 1898700.0 |
| 2002-10-17 13:00:00 | DIA | ETF | 82.5 | 82.84 | 82.4 | 82.78 | 921100.0 |
| 2002-10-17 14:00:00 | DIA | ETF | 82.75 | 83.0 | 82.33 | 82.5 | 1132100.0 |
| 2002-10-17 15:00:00 | DIA | ETF | 82.51 | 82.88 | 82.42 | 82.8 | 1612000.0 |
| 2002-10-17 16:00:00 | DIA | ETF | 82.83 | 84.82 | 82.69 | 83.6 | 476900.0 |
| 2002-10-17 17:00:00 | DIA | ETF | 83.6 | 83.75 | 83.25 | 83.55 | 9900.0 |
| 2002-10-17 18:00:00 | DIA | ETF | 83.8 | 83.95 | 83.45 | 83.95 | 3900.0 |
| 2002-10-17 19:00:00 | DIA | ETF | 83.62 | 83.82 | 83.62 | 83.62 | 800.0 |
| 2002-10-17 09:00:00 | TLT | ETF | 85.14 | 85.5 | 85.1 | 85.38 | 50800.0 |
| 2002-10-17 10:00:00 | TLT | ETF | 85.47 | 85.56 | 85.14 | 85.25 | 112100.0 |
| 2002-10-17 11:00:00 | TLT | ETF | 85.33 | 85.33 | 85.18 | 85.24 | 8500.0 |
| 2002-10-17 12:00:00 | TLT | ETF | 85.22 | 85.39 | 85.1 | 85.34 | 13000.0 |
| 2002-10-17 13:00:00 | TLT | ETF | 85.42 | 85.48 | 85.22 | 85.25 | 16500.0 |
> showing 50 of 383 rows — these rows as CSV