PREVIEW / etf_1hour / 2001-01-30
file: by_date/etf_1hour/2001/2001-01-30.parquet size: 11 KB rows: 198
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-01-30 09:00:00 | SPY | ETF | 136.3 | 136.76 | 136.3 | 136.72 | 830500.0 |
| 2001-01-30 10:00:00 | SPY | ETF | 136.73 | 136.73 | 135.79 | 136.42 | 1654900.0 |
| 2001-01-30 11:00:00 | SPY | ETF | 136.54 | 136.96 | 136.5 | 136.67 | 615700.0 |
| 2001-01-30 12:00:00 | SPY | ETF | 136.7 | 136.95 | 136.31 | 136.79 | 917800.0 |
| 2001-01-30 13:00:00 | SPY | ETF | 136.74 | 137.16 | 136.74 | 136.97 | 522900.0 |
| 2001-01-30 14:00:00 | SPY | ETF | 136.92 | 137.29 | 136.65 | 137.1 | 403100.0 |
| 2001-01-30 15:00:00 | SPY | ETF | 137.2 | 137.92 | 137.15 | 137.75 | 1385300.0 |
| 2001-01-30 16:00:00 | SPY | ETF | 137.75 | 137.8 | 137.12 | 137.8 | 599300.0 |
| 2001-01-30 09:00:00 | QQQ | ETF | 67.15 | 67.74 | 66.88 | 67.74 | 7526500.0 |
| 2001-01-30 10:00:00 | QQQ | ETF | 67.72 | 67.74 | 66.31 | 66.8 | 10041600.0 |
| 2001-01-30 11:00:00 | QQQ | ETF | 66.8 | 67.38 | 66.76 | 66.97 | 4322400.0 |
| 2001-01-30 12:00:00 | QQQ | ETF | 66.98 | 67.09 | 66.51 | 66.87 | 2628400.0 |
| 2001-01-30 13:00:00 | QQQ | ETF | 66.88 | 67.2 | 66.71 | 67.08 | 2418000.0 |
| 2001-01-30 14:00:00 | QQQ | ETF | 67.0 | 67.08 | 66.3 | 66.51 | 3778500.0 |
| 2001-01-30 15:00:00 | QQQ | ETF | 66.51 | 67.23 | 66.46 | 66.86 | 7207000.0 |
| 2001-01-30 16:00:00 | QQQ | ETF | 66.88 | 67.0 | 63.55 | 66.88 | 1927400.0 |
| 2001-01-30 17:00:00 | QQQ | ETF | 66.85 | 67.25 | 66.6 | 66.75 | 56200.0 |
| 2001-01-30 18:00:00 | QQQ | ETF | 66.8 | 67.0 | 66.71 | 66.8 | 10000.0 |
| 2001-01-30 09:00:00 | IWM | ETF | 51.0 | 51.0 | 50.6 | 50.95 | 62600.0 |
| 2001-01-30 10:00:00 | IWM | ETF | 50.9 | 50.9 | 50.425 | 50.76 | 122200.0 |
| 2001-01-30 11:00:00 | IWM | ETF | 50.775 | 50.95 | 50.65 | 50.725 | 174200.0 |
| 2001-01-30 12:00:00 | IWM | ETF | 50.655 | 50.9 | 50.655 | 50.81 | 183000.0 |
| 2001-01-30 13:00:00 | IWM | ETF | 50.85 | 50.915 | 50.7 | 50.9 | 169200.0 |
| 2001-01-30 14:00:00 | IWM | ETF | 50.75 | 50.87 | 50.53 | 50.775 | 114400.0 |
| 2001-01-30 15:00:00 | IWM | ETF | 50.7 | 51.0 | 50.615 | 51.0 | 368600.0 |
| 2001-01-30 16:00:00 | IWM | ETF | 51.075 | 51.155 | 50.875 | 51.155 | 119800.0 |
| 2001-01-30 09:00:00 | DIA | ETF | 107.24 | 107.4 | 107.06 | 107.3 | 47900.0 |
| 2001-01-30 10:00:00 | DIA | ETF | 107.3 | 107.5 | 106.8 | 107.35 | 94800.0 |
| 2001-01-30 11:00:00 | DIA | ETF | 107.4 | 107.74 | 107.4 | 107.61 | 119300.0 |
| 2001-01-30 12:00:00 | DIA | ETF | 107.65 | 108.05 | 107.43 | 107.83 | 239400.0 |
| 2001-01-30 13:00:00 | DIA | ETF | 107.9 | 108.17 | 107.85 | 108.0 | 72800.0 |
| 2001-01-30 14:00:00 | DIA | ETF | 107.99 | 108.5 | 107.8 | 108.44 | 139300.0 |
| 2001-01-30 15:00:00 | DIA | ETF | 108.49 | 109.05 | 108.33 | 108.81 | 384700.0 |
| 2001-01-30 16:00:00 | DIA | ETF | 108.87 | 108.9 | 108.5 | 108.73 | 38000.0 |
> showing 34 of 198 rows — these rows as CSV