PREVIEW / etf_1hour / 2002-09-17
file: by_date/etf_1hour/2002/2002-09-17.parquet size: 15 KB rows: 354
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-17 09:00:00 | SPY | ETF | 90.89 | 91.19 | 90.0 | 90.1 | 7010800.0 |
| 2002-09-17 10:00:00 | SPY | ETF | 90.02 | 90.15 | 88.98 | 89.1 | 8299700.0 |
| 2002-09-17 11:00:00 | SPY | ETF | 89.1 | 89.44 | 88.78 | 89.28 | 5616500.0 |
| 2002-09-17 12:00:00 | SPY | ETF | 89.28 | 89.32 | 88.57 | 88.84 | 5440200.0 |
| 2002-09-17 13:00:00 | SPY | ETF | 88.83 | 89.13 | 88.59 | 88.95 | 4346100.0 |
| 2002-09-17 14:00:00 | SPY | ETF | 88.95 | 89.0 | 88.51 | 88.69 | 4115600.0 |
| 2002-09-17 15:00:00 | SPY | ETF | 88.72 | 88.72 | 87.75 | 87.97 | 8567700.0 |
| 2002-09-17 16:00:00 | SPY | ETF | 87.92 | 88.05 | 87.78 | 87.83 | 980700.0 |
| 2002-09-17 09:00:00 | QQQ | ETF | 23.05 | 23.21 | 22.8 | 22.83 | 16206200.0 |
| 2002-09-17 10:00:00 | QQQ | ETF | 22.83 | 22.9 | 22.51 | 22.56 | 14757000.0 |
| 2002-09-17 11:00:00 | QQQ | ETF | 22.55 | 22.76 | 22.4 | 22.68 | 13835400.0 |
| 2002-09-17 12:00:00 | QQQ | ETF | 22.68 | 22.7 | 22.46 | 22.56 | 7499600.0 |
| 2002-09-17 13:00:00 | QQQ | ETF | 22.57 | 22.66 | 22.44 | 22.57 | 8244500.0 |
| 2002-09-17 14:00:00 | QQQ | ETF | 22.57 | 22.62 | 22.43 | 22.56 | 5691900.0 |
| 2002-09-17 15:00:00 | QQQ | ETF | 22.54 | 22.56 | 22.26 | 22.33 | 14783800.0 |
| 2002-09-17 16:00:00 | QQQ | ETF | 22.34 | 22.37 | 22.18 | 22.18 | 706700.0 |
| 2002-09-17 09:00:00 | IWM | ETF | 38.7 | 38.88 | 38.36 | 38.405 | 77400.0 |
| 2002-09-17 10:00:00 | IWM | ETF | 38.395 | 38.44 | 38.05 | 38.09 | 452400.0 |
| 2002-09-17 11:00:00 | IWM | ETF | 38.145 | 38.19 | 37.95 | 38.13 | 292800.0 |
| 2002-09-17 12:00:00 | IWM | ETF | 38.125 | 38.135 | 37.875 | 37.91 | 382800.0 |
| 2002-09-17 13:00:00 | IWM | ETF | 37.96 | 38.205 | 37.96 | 38.13 | 186200.0 |
| 2002-09-17 14:00:00 | IWM | ETF | 38.085 | 38.105 | 37.99 | 38.02 | 87200.0 |
| 2002-09-17 15:00:00 | IWM | ETF | 38.075 | 38.125 | 37.72 | 37.785 | 659000.0 |
| 2002-09-17 16:00:00 | IWM | ETF | 37.78 | 37.875 | 37.78 | 37.875 | 400600.0 |
| 2002-09-17 09:00:00 | DIA | ETF | 85.02 | 85.29 | 84.25 | 84.33 | 2357400.0 |
| 2002-09-17 10:00:00 | DIA | ETF | 84.34 | 84.42 | 83.3 | 83.45 | 2529200.0 |
| 2002-09-17 11:00:00 | DIA | ETF | 83.47 | 83.68 | 83.12 | 83.53 | 1307800.0 |
| 2002-09-17 12:00:00 | DIA | ETF | 83.5 | 83.54 | 82.69 | 83.03 | 1793700.0 |
| 2002-09-17 13:00:00 | DIA | ETF | 83.02 | 83.39 | 82.83 | 83.21 | 748100.0 |
| 2002-09-17 14:00:00 | DIA | ETF | 83.18 | 83.28 | 82.75 | 83.07 | 1134000.0 |
| 2002-09-17 15:00:00 | DIA | ETF | 83.06 | 83.07 | 81.99 | 82.27 | 2386900.0 |
| 2002-09-17 16:00:00 | DIA | ETF | 82.26 | 82.32 | 82.16 | 82.16 | 155400.0 |
| 2002-09-17 09:00:00 | TLT | ETF | 88.64 | 88.64 | 88.36 | 88.55 | 13200.0 |
| 2002-09-17 10:00:00 | TLT | ETF | 88.74 | 88.9 | 88.56 | 88.84 | 13000.0 |
| 2002-09-17 11:00:00 | TLT | ETF | 88.75 | 88.82 | 88.68 | 88.8 | 3700.0 |
| 2002-09-17 12:00:00 | TLT | ETF | 88.85 | 89.07 | 88.83 | 88.83 | 23600.0 |
| 2002-09-17 13:00:00 | TLT | ETF | 88.85 | 89.11 | 88.8 | 89.03 | 8300.0 |
| 2002-09-17 14:00:00 | TLT | ETF | 89.01 | 89.21 | 89.01 | 89.17 | 4900.0 |
| 2002-09-17 15:00:00 | TLT | ETF | 89.15 | 89.32 | 88.99 | 88.99 | 7700.0 |
| 2002-09-17 16:00:00 | TLT | ETF | 89.1 | 89.1 | 89.1 | 89.1 | 1000.0 |
> showing 40 of 354 rows — these rows as CSV