PREVIEW / etf_1hour / 2001-05-31
file: by_date/etf_1hour/2001/2001-05-31.parquet size: 11 KB rows: 223
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-31 09:00:00 | SPY | ETF | 125.43 | 126.0 | 125.43 | 126.0 | 1519100.0 |
| 2001-05-31 10:00:00 | SPY | ETF | 125.87 | 126.15 | 125.31 | 125.44 | 1271500.0 |
| 2001-05-31 11:00:00 | SPY | ETF | 125.44 | 125.99 | 125.26 | 125.87 | 755700.0 |
| 2001-05-31 12:00:00 | SPY | ETF | 125.81 | 126.38 | 125.58 | 126.27 | 1868300.0 |
| 2001-05-31 13:00:00 | SPY | ETF | 126.22 | 126.76 | 126.12 | 126.39 | 613300.0 |
| 2001-05-31 14:00:00 | SPY | ETF | 126.36 | 126.73 | 126.15 | 126.5 | 869000.0 |
| 2001-05-31 15:00:00 | SPY | ETF | 126.55 | 126.59 | 126.0 | 126.1 | 2107000.0 |
| 2001-05-31 16:00:00 | SPY | ETF | 126.04 | 126.12 | 125.7 | 125.82 | 550000.0 |
| 2001-05-31 17:00:00 | SPY | ETF | 125.79 | 126.04 | 125.79 | 125.96 | 4100.0 |
| 2001-05-31 09:00:00 | QQQ | ETF | 44.54 | 45.22 | 44.5 | 45.15 | 8320200.0 |
| 2001-05-31 10:00:00 | QQQ | ETF | 45.14 | 45.42 | 44.39 | 44.77 | 11911600.0 |
| 2001-05-31 11:00:00 | QQQ | ETF | 44.77 | 45.34 | 44.62 | 45.25 | 7430700.0 |
| 2001-05-31 12:00:00 | QQQ | ETF | 45.24 | 45.57 | 45.01 | 45.38 | 7562100.0 |
| 2001-05-31 13:00:00 | QQQ | ETF | 45.35 | 45.85 | 45.25 | 45.6 | 7334400.0 |
| 2001-05-31 14:00:00 | QQQ | ETF | 45.6 | 45.8 | 45.41 | 45.6 | 5094700.0 |
| 2001-05-31 15:00:00 | QQQ | ETF | 45.59 | 45.61 | 44.72 | 44.85 | 12686800.0 |
| 2001-05-31 16:00:00 | QQQ | ETF | 44.81 | 45.6 | 44.7 | 44.77 | 1768800.0 |
| 2001-05-31 17:00:00 | QQQ | ETF | 44.83 | 44.97 | 44.73 | 44.86 | 193400.0 |
| 2001-05-31 18:00:00 | QQQ | ETF | 44.87 | 45.0 | 44.75 | 45.0 | 46100.0 |
| 2001-05-31 09:00:00 | IWM | ETF | 49.575 | 49.865 | 49.575 | 49.865 | 61200.0 |
| 2001-05-31 10:00:00 | IWM | ETF | 49.745 | 49.89 | 49.665 | 49.71 | 65400.0 |
| 2001-05-31 11:00:00 | IWM | ETF | 49.725 | 49.875 | 49.665 | 49.855 | 110200.0 |
| 2001-05-31 12:00:00 | IWM | ETF | 49.85 | 49.89 | 49.75 | 49.85 | 80600.0 |
| 2001-05-31 13:00:00 | IWM | ETF | 49.845 | 50.045 | 49.8 | 49.955 | 148000.0 |
| 2001-05-31 14:00:00 | IWM | ETF | 49.955 | 50.09 | 49.925 | 50.025 | 86600.0 |
| 2001-05-31 15:00:00 | IWM | ETF | 50.0 | 50.1 | 49.6 | 49.65 | 267600.0 |
| 2001-05-31 16:00:00 | IWM | ETF | 49.4 | 49.55 | 49.4 | 49.55 | 133600.0 |
| 2001-05-31 09:00:00 | DIA | ETF | 109.25 | 109.49 | 109.1 | 109.39 | 378200.0 |
| 2001-05-31 10:00:00 | DIA | ETF | 109.39 | 109.4 | 108.77 | 108.82 | 407500.0 |
| 2001-05-31 11:00:00 | DIA | ETF | 108.8 | 109.25 | 108.75 | 109.19 | 172600.0 |
| 2001-05-31 12:00:00 | DIA | ETF | 109.21 | 109.65 | 108.9 | 109.48 | 271500.0 |
| 2001-05-31 13:00:00 | DIA | ETF | 109.55 | 109.93 | 109.49 | 109.56 | 189300.0 |
| 2001-05-31 14:00:00 | DIA | ETF | 109.6 | 109.79 | 109.42 | 109.6 | 63600.0 |
| 2001-05-31 15:00:00 | DIA | ETF | 109.55 | 109.62 | 109.21 | 109.32 | 500000.0 |
| 2001-05-31 16:00:00 | DIA | ETF | 109.32 | 109.32 | 109.08 | 109.08 | 88800.0 |
> showing 35 of 223 rows — these rows as CSV