PREVIEW / etf_1hour / 2001-11-26
file: by_date/etf_1hour/2001/2001-11-26.parquet size: 13 KB rows: 280
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-11-26 09:00:00 | SPY | ETF | 115.75 | 116.1 | 115.35 | 115.88 | 2238600.0 |
| 2001-11-26 10:00:00 | SPY | ETF | 115.86 | 116.05 | 115.31 | 115.42 | 2070500.0 |
| 2001-11-26 11:00:00 | SPY | ETF | 115.43 | 115.52 | 115.07 | 115.35 | 1252100.0 |
| 2001-11-26 12:00:00 | SPY | ETF | 115.37 | 115.69 | 115.27 | 115.63 | 794300.0 |
| 2001-11-26 13:00:00 | SPY | ETF | 115.6 | 116.03 | 115.58 | 115.98 | 1305400.0 |
| 2001-11-26 14:00:00 | SPY | ETF | 115.97 | 116.32 | 115.79 | 116.27 | 3096600.0 |
| 2001-11-26 15:00:00 | SPY | ETF | 116.3 | 116.34 | 115.96 | 116.21 | 2398800.0 |
| 2001-11-26 16:00:00 | SPY | ETF | 116.24 | 116.24 | 115.89 | 115.91 | 483500.0 |
| 2001-11-26 17:00:00 | SPY | ETF | 115.91 | 115.96 | 115.9 | 115.9 | 2500.0 |
| 2001-11-26 18:00:00 | SPY | ETF | 115.85 | 115.85 | 115.85 | 115.85 | 1000.0 |
| 2001-11-26 09:00:00 | QQQ | ETF | 39.58 | 40.1 | 39.45 | 39.99 | 14213200.0 |
| 2001-11-26 10:00:00 | QQQ | ETF | 39.96 | 40.18 | 39.6 | 39.66 | 13119700.0 |
| 2001-11-26 11:00:00 | QQQ | ETF | 39.66 | 39.75 | 39.35 | 39.72 | 7769300.0 |
| 2001-11-26 12:00:00 | QQQ | ETF | 39.71 | 39.88 | 39.61 | 39.81 | 4146500.0 |
| 2001-11-26 13:00:00 | QQQ | ETF | 39.81 | 40.21 | 39.79 | 40.16 | 10373300.0 |
| 2001-11-26 14:00:00 | QQQ | ETF | 40.14 | 40.35 | 39.95 | 40.34 | 11292600.0 |
| 2001-11-26 15:00:00 | QQQ | ETF | 40.34 | 40.35 | 40.08 | 40.33 | 12493100.0 |
| 2001-11-26 16:00:00 | QQQ | ETF | 40.3 | 40.36 | 40.05 | 40.2 | 1360600.0 |
| 2001-11-26 17:00:00 | QQQ | ETF | 40.26 | 40.28 | 40.19 | 40.23 | 47800.0 |
| 2001-11-26 18:00:00 | QQQ | ETF | 40.22 | 40.23 | 40.2 | 40.22 | 16900.0 |
| 2001-11-26 09:00:00 | IWM | ETF | 45.74 | 45.995 | 45.675 | 45.995 | 163000.0 |
| 2001-11-26 10:00:00 | IWM | ETF | 45.875 | 46.075 | 45.705 | 45.705 | 62800.0 |
| 2001-11-26 11:00:00 | IWM | ETF | 45.705 | 45.735 | 45.45 | 45.58 | 104800.0 |
| 2001-11-26 12:00:00 | IWM | ETF | 45.55 | 45.6 | 45.475 | 45.565 | 28600.0 |
| 2001-11-26 13:00:00 | IWM | ETF | 45.595 | 45.8 | 45.585 | 45.76 | 45800.0 |
| 2001-11-26 14:00:00 | IWM | ETF | 45.81 | 45.89 | 45.765 | 45.89 | 35400.0 |
| 2001-11-26 15:00:00 | IWM | ETF | 45.915 | 45.98 | 45.805 | 45.98 | 104800.0 |
| 2001-11-26 16:00:00 | IWM | ETF | 45.855 | 45.975 | 45.855 | 45.975 | 2600.0 |
| 2001-11-26 09:00:00 | DIA | ETF | 99.95 | 100.1 | 99.57 | 99.87 | 303400.0 |
| 2001-11-26 10:00:00 | DIA | ETF | 99.86 | 100.03 | 99.5 | 99.56 | 352900.0 |
| 2001-11-26 11:00:00 | DIA | ETF | 99.58 | 99.65 | 99.1 | 99.35 | 362300.0 |
| 2001-11-26 12:00:00 | DIA | ETF | 99.35 | 99.62 | 99.26 | 99.57 | 159800.0 |
| 2001-11-26 13:00:00 | DIA | ETF | 99.52 | 99.94 | 99.51 | 99.9 | 275700.0 |
| 2001-11-26 14:00:00 | DIA | ETF | 99.88 | 100.1 | 99.74 | 100.1 | 253600.0 |
| 2001-11-26 15:00:00 | DIA | ETF | 100.1 | 100.15 | 99.81 | 100.01 | 472800.0 |
| 2001-11-26 16:00:00 | DIA | ETF | 100.0 | 100.04 | 99.78 | 99.8 | 63400.0 |
| 2001-11-26 17:00:00 | DIA | ETF | 99.9 | 99.9 | 99.9 | 99.9 | 100.0 |
> showing 37 of 280 rows — these rows as CSV