PREVIEW / etf_1hour / 2002-09-09
file: by_date/etf_1hour/2002/2002-09-09.parquet size: 14 KB rows: 318
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-09 09:00:00 | SPY | ETF | 89.1 | 89.48 | 89.1 | 89.23 | 2704600.0 |
| 2002-09-09 10:00:00 | SPY | ETF | 89.2 | 89.38 | 88.8 | 89.37 | 3810600.0 |
| 2002-09-09 11:00:00 | SPY | ETF | 89.3 | 89.64 | 89.0 | 89.09 | 3961300.0 |
| 2002-09-09 12:00:00 | SPY | ETF | 89.1 | 89.95 | 89.08 | 89.92 | 2939800.0 |
| 2002-09-09 13:00:00 | SPY | ETF | 89.95 | 90.38 | 89.77 | 90.1 | 4997800.0 |
| 2002-09-09 14:00:00 | SPY | ETF | 90.08 | 91.25 | 90.04 | 91.2 | 7231000.0 |
| 2002-09-09 15:00:00 | SPY | ETF | 91.15 | 91.35 | 90.8 | 90.8 | 5544000.0 |
| 2002-09-09 16:00:00 | SPY | ETF | 90.84 | 90.85 | 90.59 | 90.66 | 974400.0 |
| 2002-09-09 09:00:00 | QQQ | ETF | 22.67 | 22.72 | 22.54 | 22.57 | 8345100.0 |
| 2002-09-09 10:00:00 | QQQ | ETF | 22.57 | 22.61 | 22.39 | 22.57 | 13323100.0 |
| 2002-09-09 11:00:00 | QQQ | ETF | 22.6 | 22.65 | 22.46 | 22.51 | 7321100.0 |
| 2002-09-09 12:00:00 | QQQ | ETF | 22.5 | 22.83 | 22.5 | 22.8 | 5611300.0 |
| 2002-09-09 13:00:00 | QQQ | ETF | 22.8 | 23.1 | 22.75 | 23.02 | 8387700.0 |
| 2002-09-09 14:00:00 | QQQ | ETF | 23.0 | 23.35 | 22.96 | 23.29 | 13806800.0 |
| 2002-09-09 15:00:00 | QQQ | ETF | 23.29 | 23.37 | 23.13 | 23.18 | 12683100.0 |
| 2002-09-09 16:00:00 | QQQ | ETF | 23.17 | 23.21 | 23.08 | 23.08 | 471000.0 |
| 2002-09-09 09:00:00 | IWM | ETF | 39.05 | 39.05 | 38.69 | 38.7 | 174600.0 |
| 2002-09-09 10:00:00 | IWM | ETF | 38.605 | 38.66 | 38.37 | 38.645 | 192200.0 |
| 2002-09-09 11:00:00 | IWM | ETF | 38.65 | 38.775 | 38.6 | 38.6 | 175800.0 |
| 2002-09-09 12:00:00 | IWM | ETF | 38.6 | 38.84 | 38.6 | 38.84 | 75400.0 |
| 2002-09-09 13:00:00 | IWM | ETF | 38.84 | 39.03 | 38.825 | 38.97 | 178400.0 |
| 2002-09-09 14:00:00 | IWM | ETF | 38.985 | 39.335 | 38.985 | 39.255 | 219200.0 |
| 2002-09-09 15:00:00 | IWM | ETF | 39.3 | 39.425 | 39.03 | 39.03 | 199800.0 |
| 2002-09-09 16:00:00 | IWM | ETF | 39.03 | 39.03 | 39.03 | 39.03 | 3000.0 |
| 2002-09-09 09:00:00 | DIA | ETF | 83.88 | 83.99 | 83.56 | 83.68 | 700300.0 |
| 2002-09-09 10:00:00 | DIA | ETF | 83.68 | 83.89 | 83.3 | 83.8 | 1134300.0 |
| 2002-09-09 11:00:00 | DIA | ETF | 83.81 | 84.16 | 83.58 | 83.68 | 1117100.0 |
| 2002-09-09 12:00:00 | DIA | ETF | 83.73 | 84.43 | 83.68 | 84.4 | 522000.0 |
| 2002-09-09 13:00:00 | DIA | ETF | 84.37 | 84.79 | 84.27 | 84.57 | 915700.0 |
| 2002-09-09 14:00:00 | DIA | ETF | 84.6 | 85.74 | 84.5 | 85.6 | 1660800.0 |
| 2002-09-09 15:00:00 | DIA | ETF | 85.6 | 85.83 | 85.25 | 85.33 | 1970400.0 |
| 2002-09-09 16:00:00 | DIA | ETF | 85.35 | 85.45 | 85.1 | 85.18 | 72200.0 |
| 2002-09-09 09:00:00 | TLT | ETF | 87.5 | 87.75 | 87.5 | 87.75 | 25400.0 |
| 2002-09-09 10:00:00 | TLT | ETF | 87.63 | 87.83 | 87.63 | 87.74 | 36600.0 |
| 2002-09-09 11:00:00 | TLT | ETF | 87.63 | 87.78 | 87.63 | 87.71 | 6800.0 |
| 2002-09-09 12:00:00 | TLT | ETF | 87.8 | 87.8 | 87.71 | 87.75 | 1500.0 |
| 2002-09-09 13:00:00 | TLT | ETF | 87.72 | 87.72 | 87.52 | 87.66 | 3900.0 |
| 2002-09-09 14:00:00 | TLT | ETF | 87.66 | 87.66 | 87.3 | 87.3 | 7100.0 |
| 2002-09-09 15:00:00 | TLT | ETF | 87.43 | 87.47 | 87.26 | 87.34 | 2000.0 |
| 2002-09-09 16:00:00 | TLT | ETF | 87.33 | 87.33 | 87.33 | 87.33 | 500.0 |
> showing 40 of 318 rows — these rows as CSV