PREVIEW / etf_1hour / 2001-10-26
file: by_date/etf_1hour/2001/2001-10-26.parquet size: 12 KB rows: 244
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-26 09:00:00 | SPY | ETF | 109.95 | 110.55 | 109.67 | 109.82 | 2864000.0 |
| 2001-10-26 10:00:00 | SPY | ETF | 109.84 | 110.73 | 109.7 | 110.48 | 2841800.0 |
| 2001-10-26 11:00:00 | SPY | ETF | 110.41 | 110.88 | 110.27 | 110.5 | 2036600.0 |
| 2001-10-26 12:00:00 | SPY | ETF | 110.48 | 110.9 | 110.4 | 110.87 | 822600.0 |
| 2001-10-26 13:00:00 | SPY | ETF | 110.88 | 111.23 | 110.7 | 110.8 | 2394200.0 |
| 2001-10-26 14:00:00 | SPY | ETF | 110.85 | 111.05 | 110.42 | 110.77 | 2163300.0 |
| 2001-10-26 15:00:00 | SPY | ETF | 110.78 | 111.48 | 110.69 | 110.77 | 3717600.0 |
| 2001-10-26 16:00:00 | SPY | ETF | 110.74 | 110.75 | 110.21 | 110.32 | 1743500.0 |
| 2001-10-26 18:00:00 | SPY | ETF | 110.32 | 110.38 | 110.32 | 110.38 | 400.0 |
| 2001-10-26 09:00:00 | QQQ | ETF | 36.5 | 37.06 | 36.35 | 36.5 | 21587500.0 |
| 2001-10-26 10:00:00 | QQQ | ETF | 36.49 | 36.95 | 36.36 | 36.58 | 16029800.0 |
| 2001-10-26 11:00:00 | QQQ | ETF | 36.58 | 36.79 | 36.25 | 36.4 | 10222600.0 |
| 2001-10-26 12:00:00 | QQQ | ETF | 36.38 | 36.79 | 36.33 | 36.75 | 6489100.0 |
| 2001-10-26 13:00:00 | QQQ | ETF | 36.75 | 37.0 | 36.42 | 36.54 | 10547400.0 |
| 2001-10-26 14:00:00 | QQQ | ETF | 36.52 | 36.7 | 36.2 | 36.4 | 10319700.0 |
| 2001-10-26 15:00:00 | QQQ | ETF | 36.41 | 36.76 | 36.18 | 36.26 | 15109300.0 |
| 2001-10-26 16:00:00 | QQQ | ETF | 36.26 | 36.7 | 36.0 | 36.05 | 2955800.0 |
| 2001-10-26 17:00:00 | QQQ | ETF | 36.06 | 36.2 | 36.01 | 36.2 | 18200.0 |
| 2001-10-26 18:00:00 | QQQ | ETF | 36.05 | 36.05 | 36.01 | 36.02 | 11000.0 |
| 2001-10-26 09:00:00 | IWM | ETF | 43.2 | 43.65 | 43.2 | 43.495 | 21600.0 |
| 2001-10-26 10:00:00 | IWM | ETF | 43.305 | 43.645 | 43.305 | 43.56 | 6800.0 |
| 2001-10-26 11:00:00 | IWM | ETF | 43.57 | 43.7 | 43.51 | 43.55 | 398600.0 |
| 2001-10-26 12:00:00 | IWM | ETF | 43.575 | 43.705 | 43.46 | 43.6 | 48400.0 |
| 2001-10-26 13:00:00 | IWM | ETF | 43.7 | 43.755 | 43.65 | 43.725 | 131000.0 |
| 2001-10-26 14:00:00 | IWM | ETF | 43.695 | 43.725 | 43.625 | 43.65 | 225000.0 |
| 2001-10-26 15:00:00 | IWM | ETF | 43.675 | 43.825 | 43.65 | 43.675 | 92600.0 |
| 2001-10-26 16:00:00 | IWM | ETF | 43.675 | 43.675 | 43.625 | 43.625 | 7600.0 |
| 2001-10-26 09:00:00 | DIA | ETF | 94.43 | 94.99 | 94.25 | 94.52 | 469300.0 |
| 2001-10-26 10:00:00 | DIA | ETF | 94.5 | 95.35 | 94.35 | 95.11 | 805900.0 |
| 2001-10-26 11:00:00 | DIA | ETF | 95.18 | 95.66 | 94.97 | 95.13 | 346600.0 |
| 2001-10-26 12:00:00 | DIA | ETF | 95.12 | 95.35 | 94.96 | 95.3 | 111300.0 |
| 2001-10-26 13:00:00 | DIA | ETF | 95.26 | 95.75 | 95.26 | 95.38 | 344400.0 |
| 2001-10-26 14:00:00 | DIA | ETF | 95.36 | 95.55 | 95.12 | 95.48 | 360500.0 |
| 2001-10-26 15:00:00 | DIA | ETF | 95.51 | 96.1 | 95.31 | 95.51 | 905900.0 |
| 2001-10-26 16:00:00 | DIA | ETF | 95.44 | 95.5 | 95.1 | 95.1 | 277700.0 |
| 2001-10-26 17:00:00 | DIA | ETF | 95.01 | 95.24 | 95.01 | 95.24 | 1200.0 |
> showing 36 of 244 rows — these rows as CSV