PREVIEW / etf_1hour / 2002-08-26
file: by_date/etf_1hour/2002/2002-08-26.parquet size: 15 KB rows: 332
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-08-26 09:00:00 | SPY | ETF | 94.91 | 95.18 | 94.65 | 94.79 | 2608900.0 |
| 2002-08-26 10:00:00 | SPY | ETF | 94.75 | 95.2 | 93.61 | 93.79 | 7065500.0 |
| 2002-08-26 11:00:00 | SPY | ETF | 93.8 | 94.05 | 93.5 | 93.63 | 3333200.0 |
| 2002-08-26 12:00:00 | SPY | ETF | 93.63 | 94.24 | 93.53 | 94.03 | 3143100.0 |
| 2002-08-26 13:00:00 | SPY | ETF | 94.05 | 94.66 | 93.86 | 94.58 | 2787700.0 |
| 2002-08-26 14:00:00 | SPY | ETF | 94.59 | 95.12 | 94.41 | 94.67 | 4053100.0 |
| 2002-08-26 15:00:00 | SPY | ETF | 94.7 | 95.64 | 94.67 | 95.27 | 6415500.0 |
| 2002-08-26 16:00:00 | SPY | ETF | 95.27 | 95.3 | 95.06 | 95.26 | 1046600.0 |
| 2002-08-26 09:00:00 | QQQ | ETF | 25.3 | 25.35 | 25.15 | 25.21 | 7532100.0 |
| 2002-08-26 10:00:00 | QQQ | ETF | 25.21 | 25.34 | 24.68 | 24.73 | 20186100.0 |
| 2002-08-26 11:00:00 | QQQ | ETF | 24.75 | 24.86 | 24.61 | 24.69 | 9830000.0 |
| 2002-08-26 12:00:00 | QQQ | ETF | 24.69 | 25.02 | 24.67 | 24.93 | 8323600.0 |
| 2002-08-26 13:00:00 | QQQ | ETF | 24.93 | 25.29 | 24.88 | 25.13 | 9522800.0 |
| 2002-08-26 14:00:00 | QQQ | ETF | 25.14 | 25.3 | 25.02 | 25.1 | 11465300.0 |
| 2002-08-26 15:00:00 | QQQ | ETF | 25.11 | 25.39 | 25.07 | 25.25 | 12406000.0 |
| 2002-08-26 16:00:00 | QQQ | ETF | 25.28 | 25.3 | 25.2 | 25.25 | 313800.0 |
| 2002-08-26 09:00:00 | IWM | ETF | 40.0 | 40.365 | 40.0 | 40.25 | 242000.0 |
| 2002-08-26 10:00:00 | IWM | ETF | 40.25 | 40.345 | 39.665 | 39.745 | 399200.0 |
| 2002-08-26 11:00:00 | IWM | ETF | 39.755 | 39.815 | 39.625 | 39.68 | 170800.0 |
| 2002-08-26 12:00:00 | IWM | ETF | 39.725 | 39.885 | 39.725 | 39.84 | 135800.0 |
| 2002-08-26 13:00:00 | IWM | ETF | 39.84 | 40.25 | 39.835 | 40.195 | 297400.0 |
| 2002-08-26 14:00:00 | IWM | ETF | 40.25 | 40.425 | 40.14 | 40.29 | 104600.0 |
| 2002-08-26 15:00:00 | IWM | ETF | 40.23 | 40.675 | 40.225 | 40.615 | 794800.0 |
| 2002-08-26 16:00:00 | IWM | ETF | 40.65 | 40.65 | 40.55 | 40.55 | 2200.0 |
| 2002-08-26 09:00:00 | DIA | ETF | 88.99 | 89.35 | 88.81 | 88.81 | 875600.0 |
| 2002-08-26 10:00:00 | DIA | ETF | 88.83 | 89.25 | 87.8 | 87.95 | 1627900.0 |
| 2002-08-26 11:00:00 | DIA | ETF | 87.95 | 88.14 | 87.64 | 87.85 | 928400.0 |
| 2002-08-26 12:00:00 | DIA | ETF | 87.8 | 88.35 | 87.72 | 88.07 | 531300.0 |
| 2002-08-26 13:00:00 | DIA | ETF | 88.07 | 88.68 | 87.92 | 88.55 | 698200.0 |
| 2002-08-26 14:00:00 | DIA | ETF | 88.58 | 89.19 | 88.4 | 88.7 | 1345400.0 |
| 2002-08-26 15:00:00 | DIA | ETF | 88.7 | 89.72 | 88.7 | 89.31 | 1643100.0 |
| 2002-08-26 16:00:00 | DIA | ETF | 89.3 | 89.33 | 89.19 | 89.33 | 33900.0 |
| 2002-08-26 09:00:00 | TLT | ETF | 85.7 | 85.7 | 85.68 | 85.68 | 1100.0 |
| 2002-08-26 10:00:00 | TLT | ETF | 85.67 | 85.99 | 85.67 | 85.9 | 1300.0 |
| 2002-08-26 11:00:00 | TLT | ETF | 85.99 | 86.06 | 85.95 | 86.06 | 3300.0 |
| 2002-08-26 12:00:00 | TLT | ETF | 86.21 | 86.21 | 86.1 | 86.11 | 2300.0 |
| 2002-08-26 14:00:00 | TLT | ETF | 85.9 | 86.06 | 85.85 | 86.06 | 15000.0 |
| 2002-08-26 15:00:00 | TLT | ETF | 86.16 | 86.16 | 85.98 | 85.98 | 500.0 |
> showing 38 of 332 rows — these rows as CSV