PREVIEW / etf_1hour / 2002-09-27
file: by_date/etf_1hour/2002/2002-09-27.parquet size: 15 KB rows: 342
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-27 09:00:00 | SPY | ETF | 85.0 | 85.19 | 84.51 | 84.91 | 10750800.0 |
| 2002-09-27 10:00:00 | SPY | ETF | 85.0 | 85.63 | 84.7 | 85.27 | 8022700.0 |
| 2002-09-27 11:00:00 | SPY | ETF | 85.28 | 85.55 | 84.58 | 84.8 | 5745700.0 |
| 2002-09-27 12:00:00 | SPY | ETF | 84.81 | 85.03 | 84.05 | 84.09 | 4694800.0 |
| 2002-09-27 13:00:00 | SPY | ETF | 84.07 | 84.39 | 83.7 | 83.86 | 7604900.0 |
| 2002-09-27 14:00:00 | SPY | ETF | 83.88 | 83.93 | 83.26 | 83.43 | 8465600.0 |
| 2002-09-27 15:00:00 | SPY | ETF | 83.43 | 83.47 | 82.8 | 82.85 | 11722900.0 |
| 2002-09-27 16:00:00 | SPY | ETF | 82.88 | 82.98 | 82.75 | 82.75 | 2369900.0 |
| 2002-09-27 09:00:00 | QQQ | ETF | 21.55 | 21.78 | 21.45 | 21.66 | 14208500.0 |
| 2002-09-27 10:00:00 | QQQ | ETF | 21.66 | 22.21 | 21.55 | 22.01 | 20790900.0 |
| 2002-09-27 11:00:00 | QQQ | ETF | 22.0 | 22.18 | 21.87 | 21.95 | 11236000.0 |
| 2002-09-27 12:00:00 | QQQ | ETF | 21.96 | 22.08 | 21.76 | 21.79 | 7494500.0 |
| 2002-09-27 13:00:00 | QQQ | ETF | 21.78 | 21.9 | 21.65 | 21.7 | 9144300.0 |
| 2002-09-27 14:00:00 | QQQ | ETF | 21.69 | 21.74 | 21.53 | 21.59 | 10247800.0 |
| 2002-09-27 15:00:00 | QQQ | ETF | 21.59 | 21.62 | 21.33 | 21.35 | 13778200.0 |
| 2002-09-27 16:00:00 | QQQ | ETF | 21.35 | 21.4 | 21.31 | 21.31 | 1147400.0 |
| 2002-09-27 09:00:00 | IWM | ETF | 36.625 | 36.925 | 36.625 | 36.925 | 142600.0 |
| 2002-09-27 10:00:00 | IWM | ETF | 36.795 | 37.02 | 36.78 | 36.945 | 422600.0 |
| 2002-09-27 11:00:00 | IWM | ETF | 36.93 | 36.975 | 36.725 | 36.725 | 326200.0 |
| 2002-09-27 12:00:00 | IWM | ETF | 36.775 | 36.78 | 36.545 | 36.545 | 184200.0 |
| 2002-09-27 13:00:00 | IWM | ETF | 36.525 | 36.555 | 36.35 | 36.35 | 541000.0 |
| 2002-09-27 14:00:00 | IWM | ETF | 36.35 | 36.37 | 36.125 | 36.2 | 449000.0 |
| 2002-09-27 15:00:00 | IWM | ETF | 36.2 | 36.2 | 36.02 | 36.02 | 315000.0 |
| 2002-09-27 16:00:00 | IWM | ETF | 36.02 | 36.025 | 36.02 | 36.025 | 7000.0 |
| 2002-09-27 09:00:00 | DIA | ETF | 79.21 | 79.36 | 78.84 | 79.19 | 1722300.0 |
| 2002-09-27 10:00:00 | DIA | ETF | 79.1 | 79.5 | 78.79 | 79.14 | 1579200.0 |
| 2002-09-27 11:00:00 | DIA | ETF | 79.15 | 79.4 | 78.55 | 78.76 | 1194400.0 |
| 2002-09-27 12:00:00 | DIA | ETF | 78.78 | 78.99 | 78.1 | 78.15 | 1031900.0 |
| 2002-09-27 13:00:00 | DIA | ETF | 78.17 | 78.48 | 77.83 | 78.0 | 917500.0 |
| 2002-09-27 14:00:00 | DIA | ETF | 78.02 | 78.05 | 77.35 | 77.53 | 1597700.0 |
| 2002-09-27 15:00:00 | DIA | ETF | 77.53 | 77.59 | 76.9 | 76.91 | 2288100.0 |
| 2002-09-27 16:00:00 | DIA | ETF | 76.99 | 77.02 | 76.85 | 76.85 | 85000.0 |
| 2002-09-27 09:00:00 | TLT | ETF | 89.53 | 89.69 | 89.53 | 89.64 | 9100.0 |
| 2002-09-27 10:00:00 | TLT | ETF | 89.65 | 89.72 | 89.48 | 89.58 | 151800.0 |
| 2002-09-27 11:00:00 | TLT | ETF | 89.5 | 89.72 | 89.5 | 89.72 | 4000.0 |
| 2002-09-27 12:00:00 | TLT | ETF | 89.62 | 89.84 | 89.62 | 89.83 | 84500.0 |
| 2002-09-27 13:00:00 | TLT | ETF | 89.7 | 89.89 | 89.7 | 89.89 | 4100.0 |
| 2002-09-27 14:00:00 | TLT | ETF | 89.96 | 90.0 | 89.83 | 89.9 | 31300.0 |
| 2002-09-27 15:00:00 | TLT | ETF | 89.99 | 90.04 | 89.88 | 90.04 | 13400.0 |
> showing 39 of 342 rows — these rows as CSV