PREVIEW / etf_1hour / 2001-02-01
file: by_date/etf_1hour/2001/2001-02-01.parquet size: 11 KB rows: 202
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-02-01 09:00:00 | SPY | ETF | 137.1 | 137.18 | 136.75 | 136.95 | 1372800.0 |
| 2001-02-01 10:00:00 | SPY | ETF | 136.98 | 137.05 | 136.26 | 136.59 | 1423800.0 |
| 2001-02-01 11:00:00 | SPY | ETF | 136.59 | 137.5 | 136.59 | 137.48 | 1643900.0 |
| 2001-02-01 12:00:00 | SPY | ETF | 137.48 | 137.48 | 136.73 | 136.92 | 421100.0 |
| 2001-02-01 13:00:00 | SPY | ETF | 136.94 | 137.13 | 136.25 | 136.48 | 348200.0 |
| 2001-02-01 14:00:00 | SPY | ETF | 136.35 | 136.95 | 136.3 | 136.7 | 580100.0 |
| 2001-02-01 15:00:00 | SPY | ETF | 136.84 | 137.56 | 136.65 | 137.48 | 1772200.0 |
| 2001-02-01 16:00:00 | SPY | ETF | 137.32 | 138.0 | 137.2 | 138.0 | 458500.0 |
| 2001-02-01 09:00:00 | QQQ | ETF | 64.55 | 64.9 | 64.02 | 64.53 | 6911500.0 |
| 2001-02-01 10:00:00 | QQQ | ETF | 64.49 | 64.69 | 63.6 | 64.2 | 7787000.0 |
| 2001-02-01 11:00:00 | QQQ | ETF | 64.2 | 65.61 | 64.1 | 65.43 | 8954300.0 |
| 2001-02-01 12:00:00 | QQQ | ETF | 65.46 | 65.5 | 64.5 | 64.65 | 4306700.0 |
| 2001-02-01 13:00:00 | QQQ | ETF | 64.64 | 64.9 | 63.9 | 64.0 | 3641800.0 |
| 2001-02-01 14:00:00 | QQQ | ETF | 63.99 | 64.76 | 63.95 | 64.62 | 4043300.0 |
| 2001-02-01 15:00:00 | QQQ | ETF | 64.58 | 65.2 | 64.4 | 65.0 | 6309300.0 |
| 2001-02-01 16:00:00 | QQQ | ETF | 65.0 | 65.5 | 64.85 | 65.2 | 998100.0 |
| 2001-02-01 17:00:00 | QQQ | ETF | 65.25 | 65.3 | 65.1 | 65.18 | 13600.0 |
| 2001-02-01 18:00:00 | QQQ | ETF | 65.17 | 65.18 | 65.17 | 65.18 | 1200.0 |
| 2001-02-01 09:00:00 | IWM | ETF | 50.475 | 50.625 | 50.475 | 50.475 | 34600.0 |
| 2001-02-01 10:00:00 | IWM | ETF | 50.465 | 50.465 | 50.25 | 50.37 | 80800.0 |
| 2001-02-01 11:00:00 | IWM | ETF | 50.37 | 50.7 | 50.34 | 50.685 | 60800.0 |
| 2001-02-01 12:00:00 | IWM | ETF | 50.75 | 50.75 | 50.5 | 50.585 | 9200.0 |
| 2001-02-01 13:00:00 | IWM | ETF | 50.625 | 50.63 | 50.3 | 50.33 | 34200.0 |
| 2001-02-01 14:00:00 | IWM | ETF | 50.4 | 50.6 | 50.4 | 50.45 | 41800.0 |
| 2001-02-01 15:00:00 | IWM | ETF | 50.65 | 50.8 | 50.505 | 50.8 | 436200.0 |
| 2001-02-01 16:00:00 | IWM | ETF | 50.82 | 50.82 | 50.82 | 50.82 | 3200.0 |
| 2001-02-01 09:00:00 | DIA | ETF | 108.72 | 109.21 | 108.4 | 109.09 | 189900.0 |
| 2001-02-01 10:00:00 | DIA | ETF | 109.13 | 109.2 | 108.65 | 108.9 | 257800.0 |
| 2001-02-01 11:00:00 | DIA | ETF | 108.83 | 109.62 | 108.83 | 109.26 | 472300.0 |
| 2001-02-01 12:00:00 | DIA | ETF | 109.43 | 109.43 | 108.8 | 108.91 | 65500.0 |
| 2001-02-01 13:00:00 | DIA | ETF | 108.97 | 109.2 | 108.6 | 108.72 | 140700.0 |
| 2001-02-01 14:00:00 | DIA | ETF | 108.67 | 109.0 | 108.67 | 109.0 | 71700.0 |
| 2001-02-01 15:00:00 | DIA | ETF | 109.0 | 110.0 | 109.0 | 109.99 | 399600.0 |
| 2001-02-01 16:00:00 | DIA | ETF | 109.86 | 110.25 | 109.86 | 110.2 | 88400.0 |
| 2001-02-01 17:00:00 | DIA | ETF | 110.2 | 110.22 | 110.2 | 110.22 | 4700.0 |
> showing 35 of 202 rows — these rows as CSV