PREVIEW / etf_1hour / 2001-05-08
file: by_date/etf_1hour/2001/2001-05-08.parquet size: 11 KB rows: 232
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-05-08 09:00:00 | SPY | ETF | 126.86 | 127.1 | 126.58 | 126.72 | 1219200.0 |
| 2001-05-08 10:00:00 | SPY | ETF | 126.77 | 126.79 | 125.56 | 126.13 | 1632600.0 |
| 2001-05-08 11:00:00 | SPY | ETF | 126.03 | 126.36 | 125.71 | 125.75 | 863700.0 |
| 2001-05-08 12:00:00 | SPY | ETF | 125.76 | 126.08 | 125.6 | 126.06 | 429100.0 |
| 2001-05-08 13:00:00 | SPY | ETF | 126.09 | 126.37 | 125.91 | 126.22 | 550300.0 |
| 2001-05-08 14:00:00 | SPY | ETF | 126.21 | 126.5 | 125.81 | 126.22 | 599300.0 |
| 2001-05-08 15:00:00 | SPY | ETF | 126.27 | 126.61 | 126.17 | 126.52 | 1041900.0 |
| 2001-05-08 16:00:00 | SPY | ETF | 126.45 | 127.3 | 126.02 | 126.07 | 355700.0 |
| 2001-05-08 17:00:00 | SPY | ETF | 126.0 | 126.0 | 125.71 | 125.78 | 2300.0 |
| 2001-05-08 18:00:00 | SPY | ETF | 125.9 | 125.9 | 125.81 | 125.81 | 50300.0 |
| 2001-05-08 09:00:00 | QQQ | ETF | 48.3 | 48.35 | 47.85 | 47.96 | 10297000.0 |
| 2001-05-08 10:00:00 | QQQ | ETF | 48.02 | 48.02 | 47.2 | 47.6 | 11387500.0 |
| 2001-05-08 11:00:00 | QQQ | ETF | 47.6 | 47.84 | 47.11 | 47.25 | 9264000.0 |
| 2001-05-08 12:00:00 | QQQ | ETF | 47.19 | 47.5 | 46.99 | 47.49 | 5441600.0 |
| 2001-05-08 13:00:00 | QQQ | ETF | 47.49 | 47.65 | 47.3 | 47.55 | 4055200.0 |
| 2001-05-08 14:00:00 | QQQ | ETF | 47.54 | 47.88 | 47.21 | 47.73 | 5544500.0 |
| 2001-05-08 15:00:00 | QQQ | ETF | 47.73 | 48.18 | 47.68 | 48.15 | 6961900.0 |
| 2001-05-08 16:00:00 | QQQ | ETF | 48.15 | 48.75 | 47.0 | 48.0 | 1903900.0 |
| 2001-05-08 17:00:00 | QQQ | ETF | 47.97 | 47.97 | 47.3 | 47.55 | 510500.0 |
| 2001-05-08 18:00:00 | QQQ | ETF | 47.52 | 47.59 | 47.4 | 47.5 | 87000.0 |
| 2001-05-08 09:00:00 | IWM | ETF | 49.05 | 49.2 | 49.0 | 49.05 | 8800.0 |
| 2001-05-08 10:00:00 | IWM | ETF | 49.105 | 49.105 | 48.525 | 48.65 | 117800.0 |
| 2001-05-08 11:00:00 | IWM | ETF | 48.8 | 48.8 | 48.65 | 48.65 | 4400.0 |
| 2001-05-08 12:00:00 | IWM | ETF | 48.7 | 48.725 | 48.65 | 48.705 | 3800.0 |
| 2001-05-08 13:00:00 | IWM | ETF | 48.71 | 48.855 | 48.71 | 48.85 | 22400.0 |
| 2001-05-08 14:00:00 | IWM | ETF | 48.83 | 48.945 | 48.8 | 48.825 | 8800.0 |
| 2001-05-08 15:00:00 | IWM | ETF | 48.945 | 49.25 | 48.945 | 49.225 | 238400.0 |
| 2001-05-08 16:00:00 | IWM | ETF | 49.225 | 49.225 | 49.0 | 49.0 | 13600.0 |
| 2001-05-08 09:00:00 | DIA | ETF | 109.64 | 109.64 | 109.06 | 109.07 | 500600.0 |
| 2001-05-08 10:00:00 | DIA | ETF | 109.1 | 109.19 | 108.2 | 108.61 | 1106300.0 |
| 2001-05-08 11:00:00 | DIA | ETF | 108.6 | 108.85 | 108.31 | 108.44 | 238500.0 |
| 2001-05-08 12:00:00 | DIA | ETF | 108.46 | 108.73 | 108.36 | 108.67 | 187100.0 |
| 2001-05-08 13:00:00 | DIA | ETF | 108.65 | 108.92 | 108.58 | 108.92 | 109400.0 |
| 2001-05-08 14:00:00 | DIA | ETF | 108.89 | 109.1 | 108.57 | 108.99 | 153700.0 |
| 2001-05-08 15:00:00 | DIA | ETF | 108.76 | 109.05 | 108.6 | 108.99 | 205900.0 |
| 2001-05-08 16:00:00 | DIA | ETF | 108.9 | 108.93 | 108.8 | 108.8 | 115700.0 |
> showing 36 of 232 rows — these rows as CSV