PREVIEW / etf_1hour / 2002-09-26
file: by_date/etf_1hour/2002/2002-09-26.parquet size: 15 KB rows: 352
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-26 09:00:00 | SPY | ETF | 85.02 | 85.46 | 84.45 | 85.25 | 7776400.0 |
| 2002-09-26 10:00:00 | SPY | ETF | 85.26 | 85.63 | 84.9 | 85.18 | 9091700.0 |
| 2002-09-26 11:00:00 | SPY | ETF | 85.18 | 85.95 | 85.03 | 85.49 | 5664600.0 |
| 2002-09-26 12:00:00 | SPY | ETF | 85.46 | 85.77 | 84.97 | 85.08 | 6346600.0 |
| 2002-09-26 13:00:00 | SPY | ETF | 85.03 | 85.18 | 84.5 | 84.82 | 6254400.0 |
| 2002-09-26 14:00:00 | SPY | ETF | 84.85 | 85.38 | 84.54 | 85.26 | 5412800.0 |
| 2002-09-26 15:00:00 | SPY | ETF | 85.26 | 85.91 | 85.23 | 85.86 | 7536300.0 |
| 2002-09-26 16:00:00 | SPY | ETF | 85.84 | 85.97 | 85.71 | 85.73 | 1876000.0 |
| 2002-09-26 09:00:00 | QQQ | ETF | 22.16 | 22.27 | 21.94 | 22.2 | 16472400.0 |
| 2002-09-26 10:00:00 | QQQ | ETF | 22.22 | 22.33 | 21.84 | 21.98 | 19801700.0 |
| 2002-09-26 11:00:00 | QQQ | ETF | 21.96 | 22.16 | 21.9 | 21.92 | 9358900.0 |
| 2002-09-26 12:00:00 | QQQ | ETF | 21.93 | 21.96 | 21.55 | 21.65 | 13984800.0 |
| 2002-09-26 13:00:00 | QQQ | ETF | 21.66 | 21.69 | 21.37 | 21.61 | 13956500.0 |
| 2002-09-26 14:00:00 | QQQ | ETF | 21.62 | 21.83 | 21.51 | 21.75 | 8243100.0 |
| 2002-09-26 15:00:00 | QQQ | ETF | 21.76 | 21.95 | 21.64 | 21.77 | 11693500.0 |
| 2002-09-26 16:00:00 | QQQ | ETF | 21.77 | 21.78 | 21.59 | 21.6 | 2226700.0 |
| 2002-09-26 09:00:00 | IWM | ETF | 36.7 | 36.73 | 36.46 | 36.68 | 1186600.0 |
| 2002-09-26 10:00:00 | IWM | ETF | 36.65 | 36.81 | 36.6 | 36.67 | 740200.0 |
| 2002-09-26 11:00:00 | IWM | ETF | 36.675 | 36.805 | 36.65 | 36.745 | 714600.0 |
| 2002-09-26 12:00:00 | IWM | ETF | 36.71 | 36.745 | 36.56 | 36.655 | 237800.0 |
| 2002-09-26 13:00:00 | IWM | ETF | 36.65 | 36.65 | 36.405 | 36.53 | 575000.0 |
| 2002-09-26 14:00:00 | IWM | ETF | 36.525 | 36.81 | 36.425 | 36.81 | 498600.0 |
| 2002-09-26 15:00:00 | IWM | ETF | 36.82 | 37.01 | 36.805 | 36.99 | 605200.0 |
| 2002-09-26 16:00:00 | IWM | ETF | 37.0 | 37.065 | 36.93 | 36.93 | 7200.0 |
| 2002-09-26 09:00:00 | DIA | ETF | 79.18 | 79.6 | 78.6 | 79.46 | 1343600.0 |
| 2002-09-26 10:00:00 | DIA | ETF | 79.45 | 79.8 | 79.1 | 79.38 | 1751700.0 |
| 2002-09-26 11:00:00 | DIA | ETF | 79.37 | 80.1 | 79.29 | 79.65 | 1726900.0 |
| 2002-09-26 12:00:00 | DIA | ETF | 79.63 | 79.93 | 79.2 | 79.34 | 1254600.0 |
| 2002-09-26 13:00:00 | DIA | ETF | 79.38 | 79.46 | 78.8 | 79.11 | 1364300.0 |
| 2002-09-26 14:00:00 | DIA | ETF | 79.07 | 79.7 | 78.91 | 79.59 | 1521200.0 |
| 2002-09-26 15:00:00 | DIA | ETF | 79.63 | 80.27 | 79.57 | 80.0 | 1364100.0 |
| 2002-09-26 16:00:00 | DIA | ETF | 80.0 | 80.18 | 79.8 | 79.81 | 109700.0 |
| 2002-09-26 09:00:00 | TLT | ETF | 89.05 | 89.26 | 88.92 | 89.05 | 47900.0 |
| 2002-09-26 10:00:00 | TLT | ETF | 88.95 | 89.07 | 88.68 | 88.75 | 38300.0 |
| 2002-09-26 11:00:00 | TLT | ETF | 88.87 | 88.95 | 88.61 | 88.83 | 244400.0 |
| 2002-09-26 12:00:00 | TLT | ETF | 88.77 | 88.9 | 88.74 | 88.9 | 73700.0 |
| 2002-09-26 13:00:00 | TLT | ETF | 88.98 | 89.37 | 88.98 | 89.32 | 4300.0 |
| 2002-09-26 14:00:00 | TLT | ETF | 89.49 | 89.53 | 89.26 | 89.43 | 8600.0 |
| 2002-09-26 15:00:00 | TLT | ETF | 89.36 | 89.36 | 89.16 | 89.27 | 10300.0 |
| 2002-09-26 16:00:00 | TLT | ETF | 89.3 | 89.37 | 89.3 | 89.37 | 600.0 |
> showing 40 of 352 rows — these rows as CSV