PREVIEW / etf_1hour / 2002-08-29
file: by_date/etf_1hour/2002/2002-08-29.parquet size: 15 KB rows: 336
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-08-29 09:00:00 | SPY | ETF | 91.27 | 91.39 | 90.81 | 91.05 | 5984000.0 |
| 2002-08-29 10:00:00 | SPY | ETF | 91.05 | 92.2 | 90.97 | 91.74 | 8940000.0 |
| 2002-08-29 11:00:00 | SPY | ETF | 91.78 | 92.35 | 91.56 | 92.27 | 3225400.0 |
| 2002-08-29 12:00:00 | SPY | ETF | 92.27 | 93.05 | 92.24 | 92.71 | 5701300.0 |
| 2002-08-29 13:00:00 | SPY | ETF | 92.71 | 92.83 | 92.11 | 92.19 | 3767500.0 |
| 2002-08-29 14:00:00 | SPY | ETF | 92.2 | 92.54 | 91.75 | 92.5 | 4086600.0 |
| 2002-08-29 15:00:00 | SPY | ETF | 92.49 | 92.83 | 92.08 | 92.3 | 7948500.0 |
| 2002-08-29 16:00:00 | SPY | ETF | 92.32 | 92.32 | 92.05 | 92.14 | 1521500.0 |
| 2002-08-29 09:00:00 | QQQ | ETF | 23.2 | 23.28 | 23.02 | 23.18 | 14616500.0 |
| 2002-08-29 10:00:00 | QQQ | ETF | 23.18 | 23.93 | 23.15 | 23.75 | 21281400.0 |
| 2002-08-29 11:00:00 | QQQ | ETF | 23.74 | 23.99 | 23.66 | 23.93 | 9248700.0 |
| 2002-08-29 12:00:00 | QQQ | ETF | 23.93 | 24.22 | 23.89 | 24.11 | 12136300.0 |
| 2002-08-29 13:00:00 | QQQ | ETF | 24.12 | 24.19 | 23.86 | 23.94 | 9794100.0 |
| 2002-08-29 14:00:00 | QQQ | ETF | 23.94 | 24.03 | 23.63 | 23.88 | 10747400.0 |
| 2002-08-29 15:00:00 | QQQ | ETF | 23.93 | 24.08 | 23.79 | 23.86 | 13817100.0 |
| 2002-08-29 16:00:00 | QQQ | ETF | 23.87 | 23.88 | 23.76 | 23.79 | 722900.0 |
| 2002-08-29 09:00:00 | IWM | ETF | 38.425 | 38.65 | 38.425 | 38.62 | 186800.0 |
| 2002-08-29 10:00:00 | IWM | ETF | 38.705 | 39.265 | 38.675 | 39.155 | 293000.0 |
| 2002-08-29 11:00:00 | IWM | ETF | 39.155 | 39.35 | 39.1 | 39.27 | 145800.0 |
| 2002-08-29 12:00:00 | IWM | ETF | 39.35 | 39.61 | 39.285 | 39.485 | 343600.0 |
| 2002-08-29 13:00:00 | IWM | ETF | 39.5 | 39.545 | 39.21 | 39.215 | 273200.0 |
| 2002-08-29 14:00:00 | IWM | ETF | 39.25 | 39.325 | 39.15 | 39.325 | 428400.0 |
| 2002-08-29 15:00:00 | IWM | ETF | 39.335 | 39.485 | 39.26 | 39.33 | 350400.0 |
| 2002-08-29 16:00:00 | IWM | ETF | 39.25 | 39.29 | 39.25 | 39.29 | 22000.0 |
| 2002-08-29 09:00:00 | DIA | ETF | 86.2 | 86.32 | 85.76 | 85.97 | 1736700.0 |
| 2002-08-29 10:00:00 | DIA | ETF | 85.92 | 86.86 | 85.92 | 86.43 | 1921300.0 |
| 2002-08-29 11:00:00 | DIA | ETF | 86.43 | 87.02 | 86.27 | 86.97 | 727900.0 |
| 2002-08-29 12:00:00 | DIA | ETF | 86.97 | 87.6 | 86.8 | 87.34 | 1361800.0 |
| 2002-08-29 13:00:00 | DIA | ETF | 87.34 | 87.43 | 86.75 | 86.9 | 650000.0 |
| 2002-08-29 14:00:00 | DIA | ETF | 86.83 | 87.15 | 86.37 | 87.0 | 951300.0 |
| 2002-08-29 15:00:00 | DIA | ETF | 87.03 | 87.44 | 86.63 | 86.88 | 1429300.0 |
| 2002-08-29 16:00:00 | DIA | ETF | 86.86 | 86.89 | 86.7 | 86.75 | 87600.0 |
| 2002-08-29 09:00:00 | TLT | ETF | 86.76 | 86.86 | 86.68 | 86.86 | 8600.0 |
| 2002-08-29 10:00:00 | TLT | ETF | 86.86 | 86.86 | 86.54 | 86.56 | 78500.0 |
| 2002-08-29 11:00:00 | TLT | ETF | 86.57 | 86.6 | 86.57 | 86.6 | 30500.0 |
| 2002-08-29 12:00:00 | TLT | ETF | 86.6 | 86.63 | 86.35 | 86.35 | 12500.0 |
| 2002-08-29 13:00:00 | TLT | ETF | 86.53 | 86.54 | 86.53 | 86.53 | 2300.0 |
| 2002-08-29 14:00:00 | TLT | ETF | 86.51 | 86.51 | 86.45 | 86.47 | 1700.0 |
| 2002-08-29 15:00:00 | TLT | ETF | 86.53 | 86.64 | 86.53 | 86.56 | 1600.0 |
> showing 39 of 336 rows — these rows as CSV