PREVIEW / etf_1hour / 2001-09-04
file: by_date/etf_1hour/2001/2001-09-04.parquet size: 12 KB rows: 250
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-09-04 09:00:00 | SPY | ETF | 113.85 | 114.07 | 113.44 | 114.06 | 1190600.0 |
| 2001-09-04 10:00:00 | SPY | ETF | 114.07 | 115.15 | 113.9 | 114.91 | 6146900.0 |
| 2001-09-04 11:00:00 | SPY | ETF | 114.96 | 115.5 | 114.9 | 115.37 | 3035400.0 |
| 2001-09-04 12:00:00 | SPY | ETF | 115.41 | 116.05 | 115.41 | 115.85 | 2312300.0 |
| 2001-09-04 13:00:00 | SPY | ETF | 115.84 | 116.16 | 115.66 | 116.05 | 1453500.0 |
| 2001-09-04 14:00:00 | SPY | ETF | 116.12 | 116.17 | 115.48 | 115.8 | 2235600.0 |
| 2001-09-04 15:00:00 | SPY | ETF | 115.77 | 115.77 | 113.6 | 113.65 | 5221600.0 |
| 2001-09-04 16:00:00 | SPY | ETF | 113.65 | 113.78 | 113.36 | 113.42 | 1972500.0 |
| 2001-09-04 17:00:00 | SPY | ETF | 113.55 | 113.55 | 113.25 | 113.25 | 5200.0 |
| 2001-09-04 18:00:00 | SPY | ETF | 113.45 | 113.45 | 113.45 | 113.45 | 1000.0 |
| 2001-09-04 09:00:00 | QQQ | ETF | 36.51 | 36.55 | 36.11 | 36.5 | 6886100.0 |
| 2001-09-04 10:00:00 | QQQ | ETF | 36.54 | 37.5 | 36.34 | 36.8 | 14341500.0 |
| 2001-09-04 11:00:00 | QQQ | ETF | 36.81 | 37.03 | 36.7 | 36.9 | 7834000.0 |
| 2001-09-04 12:00:00 | QQQ | ETF | 36.89 | 37.48 | 36.89 | 37.36 | 7351700.0 |
| 2001-09-04 13:00:00 | QQQ | ETF | 37.4 | 37.44 | 37.12 | 37.3 | 5156000.0 |
| 2001-09-04 14:00:00 | QQQ | ETF | 37.32 | 37.33 | 36.71 | 36.9 | 6033700.0 |
| 2001-09-04 15:00:00 | QQQ | ETF | 36.93 | 36.96 | 35.42 | 35.48 | 15555600.0 |
| 2001-09-04 16:00:00 | QQQ | ETF | 35.43 | 35.54 | 35.35 | 35.47 | 6358300.0 |
| 2001-09-04 17:00:00 | QQQ | ETF | 35.46 | 35.48 | 35.2 | 35.25 | 655200.0 |
| 2001-09-04 18:00:00 | QQQ | ETF | 35.23 | 37.33 | 35.2 | 35.37 | 13000.0 |
| 2001-09-04 09:00:00 | IWM | ETF | 46.85 | 46.85 | 46.505 | 46.745 | 30800.0 |
| 2001-09-04 10:00:00 | IWM | ETF | 46.9 | 47.095 | 46.9 | 47.045 | 57200.0 |
| 2001-09-04 11:00:00 | IWM | ETF | 47.045 | 47.095 | 46.95 | 47.055 | 37800.0 |
| 2001-09-04 12:00:00 | IWM | ETF | 47.12 | 47.245 | 47.095 | 47.125 | 289000.0 |
| 2001-09-04 13:00:00 | IWM | ETF | 47.125 | 47.195 | 47.105 | 47.105 | 18200.0 |
| 2001-09-04 14:00:00 | IWM | ETF | 47.15 | 47.18 | 46.96 | 47.155 | 10600.0 |
| 2001-09-04 15:00:00 | IWM | ETF | 47.17 | 47.17 | 46.5 | 46.505 | 225600.0 |
| 2001-09-04 16:00:00 | IWM | ETF | 46.5 | 46.6 | 46.5 | 46.6 | 14200.0 |
| 2001-09-04 09:00:00 | DIA | ETF | 99.7 | 99.92 | 99.36 | 99.9 | 458900.0 |
| 2001-09-04 10:00:00 | DIA | ETF | 99.9 | 100.98 | 99.75 | 100.9 | 2236700.0 |
| 2001-09-04 11:00:00 | DIA | ETF | 100.9 | 101.5 | 100.88 | 101.38 | 1969000.0 |
| 2001-09-04 12:00:00 | DIA | ETF | 101.37 | 102.01 | 101.37 | 101.81 | 685900.0 |
| 2001-09-04 13:00:00 | DIA | ETF | 101.82 | 102.03 | 101.69 | 102.0 | 453600.0 |
| 2001-09-04 14:00:00 | DIA | ETF | 102.03 | 102.07 | 101.66 | 101.99 | 1022900.0 |
| 2001-09-04 15:00:00 | DIA | ETF | 101.92 | 101.93 | 99.96 | 99.99 | 1303700.0 |
| 2001-09-04 16:00:00 | DIA | ETF | 100.01 | 100.1 | 99.8 | 99.86 | 118300.0 |
> showing 36 of 250 rows — these rows as CSV