PREVIEW / etf_1hour / 2002-09-16
file: by_date/etf_1hour/2002/2002-09-16.parquet size: 14 KB rows: 339
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-09-16 09:00:00 | SPY | ETF | 89.31 | 89.75 | 89.16 | 89.51 | 3079100.0 |
| 2002-09-16 10:00:00 | SPY | ETF | 89.5 | 89.55 | 88.5 | 88.59 | 4931000.0 |
| 2002-09-16 11:00:00 | SPY | ETF | 88.6 | 89.0 | 88.46 | 88.75 | 3438500.0 |
| 2002-09-16 12:00:00 | SPY | ETF | 88.76 | 89.27 | 88.71 | 89.12 | 2432400.0 |
| 2002-09-16 13:00:00 | SPY | ETF | 89.1 | 89.63 | 88.95 | 89.36 | 2616700.0 |
| 2002-09-16 14:00:00 | SPY | ETF | 89.39 | 89.46 | 89.05 | 89.34 | 3440400.0 |
| 2002-09-16 15:00:00 | SPY | ETF | 89.34 | 89.83 | 89.2 | 89.73 | 3817500.0 |
| 2002-09-16 16:00:00 | SPY | ETF | 89.61 | 89.89 | 89.61 | 89.89 | 1611100.0 |
| 2002-09-16 09:00:00 | QQQ | ETF | 22.86 | 23.0 | 22.75 | 22.88 | 5970500.0 |
| 2002-09-16 10:00:00 | QQQ | ETF | 22.87 | 22.9 | 22.42 | 22.47 | 12888200.0 |
| 2002-09-16 11:00:00 | QQQ | ETF | 22.47 | 22.57 | 22.37 | 22.47 | 7465800.0 |
| 2002-09-16 12:00:00 | QQQ | ETF | 22.46 | 22.64 | 22.44 | 22.53 | 4630400.0 |
| 2002-09-16 13:00:00 | QQQ | ETF | 22.53 | 22.75 | 22.48 | 22.68 | 5141300.0 |
| 2002-09-16 14:00:00 | QQQ | ETF | 22.68 | 22.7 | 22.44 | 22.54 | 7355600.0 |
| 2002-09-16 15:00:00 | QQQ | ETF | 22.54 | 22.7 | 22.48 | 22.56 | 9563600.0 |
| 2002-09-16 16:00:00 | QQQ | ETF | 22.56 | 22.7 | 22.54 | 22.66 | 517000.0 |
| 2002-09-16 09:00:00 | IWM | ETF | 38.8 | 38.875 | 38.605 | 38.75 | 46800.0 |
| 2002-09-16 10:00:00 | IWM | ETF | 38.75 | 38.795 | 38.35 | 38.35 | 300800.0 |
| 2002-09-16 11:00:00 | IWM | ETF | 38.33 | 38.41 | 38.31 | 38.375 | 32000.0 |
| 2002-09-16 12:00:00 | IWM | ETF | 38.44 | 38.515 | 38.38 | 38.515 | 65600.0 |
| 2002-09-16 13:00:00 | IWM | ETF | 38.45 | 38.61 | 38.425 | 38.555 | 58400.0 |
| 2002-09-16 14:00:00 | IWM | ETF | 38.555 | 38.555 | 38.385 | 38.405 | 124600.0 |
| 2002-09-16 15:00:00 | IWM | ETF | 38.475 | 38.555 | 38.39 | 38.4 | 107000.0 |
| 2002-09-16 16:00:00 | IWM | ETF | 38.4 | 38.4 | 38.4 | 38.4 | 5000.0 |
| 2002-09-16 09:00:00 | DIA | ETF | 83.05 | 83.87 | 82.95 | 83.65 | 642800.0 |
| 2002-09-16 10:00:00 | DIA | ETF | 83.66 | 83.73 | 82.86 | 82.98 | 1002800.0 |
| 2002-09-16 11:00:00 | DIA | ETF | 82.88 | 83.3 | 82.75 | 83.06 | 981300.0 |
| 2002-09-16 12:00:00 | DIA | ETF | 83.06 | 83.58 | 83.06 | 83.43 | 712800.0 |
| 2002-09-16 13:00:00 | DIA | ETF | 83.4 | 83.85 | 83.3 | 83.71 | 524200.0 |
| 2002-09-16 14:00:00 | DIA | ETF | 83.79 | 83.79 | 83.35 | 83.69 | 660700.0 |
| 2002-09-16 15:00:00 | DIA | ETF | 83.64 | 84.18 | 83.52 | 84.04 | 1185700.0 |
| 2002-09-16 16:00:00 | DIA | ETF | 84.05 | 84.2 | 83.99 | 84.15 | 27100.0 |
| 2002-09-16 09:00:00 | TLT | ETF | 89.2 | 89.22 | 88.93 | 88.93 | 5400.0 |
| 2002-09-16 10:00:00 | TLT | ETF | 88.99 | 89.08 | 88.98 | 89.05 | 37400.0 |
| 2002-09-16 11:00:00 | TLT | ETF | 89.07 | 89.08 | 88.9 | 89.08 | 6300.0 |
| 2002-09-16 12:00:00 | TLT | ETF | 89.0 | 89.1 | 88.99 | 89.1 | 1900.0 |
| 2002-09-16 13:00:00 | TLT | ETF | 89.07 | 89.07 | 89.01 | 89.01 | 800.0 |
| 2002-09-16 14:00:00 | TLT | ETF | 89.16 | 89.21 | 89.16 | 89.18 | 4000.0 |
| 2002-09-16 15:00:00 | TLT | ETF | 88.97 | 89.05 | 88.93 | 88.93 | 17200.0 |
> showing 39 of 339 rows — these rows as CSV