PREVIEW / etf_1hour / 2002-05-31
file: by_date/etf_1hour/2002/2002-05-31.parquet size: 14 KB rows: 312
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-31 09:00:00 | SPY | ETF | 107.4 | 107.81 | 107.21 | 107.68 | 2149500.0 |
| 2002-05-31 10:00:00 | SPY | ETF | 107.6 | 108.16 | 107.6 | 107.93 | 4471600.0 |
| 2002-05-31 11:00:00 | SPY | ETF | 107.9 | 108.3 | 107.9 | 108.01 | 1626000.0 |
| 2002-05-31 12:00:00 | SPY | ETF | 108.01 | 108.47 | 107.91 | 108.45 | 1950700.0 |
| 2002-05-31 13:00:00 | SPY | ETF | 108.48 | 108.56 | 108.0 | 108.1 | 1763500.0 |
| 2002-05-31 14:00:00 | SPY | ETF | 108.1 | 108.17 | 107.27 | 107.37 | 2056900.0 |
| 2002-05-31 15:00:00 | SPY | ETF | 107.36 | 107.69 | 107.08 | 107.22 | 2474800.0 |
| 2002-05-31 16:00:00 | SPY | ETF | 107.25 | 107.37 | 106.84 | 106.9 | 2743900.0 |
| 2002-05-31 17:00:00 | SPY | ETF | 106.95 | 106.95 | 106.95 | 106.95 | 500.0 |
| 2002-05-31 09:00:00 | QQQ | ETF | 30.76 | 30.84 | 30.37 | 30.63 | 10547100.0 |
| 2002-05-31 10:00:00 | QQQ | ETF | 30.63 | 30.98 | 30.56 | 30.82 | 16557600.0 |
| 2002-05-31 11:00:00 | QQQ | ETF | 30.84 | 31.04 | 30.81 | 30.84 | 8086800.0 |
| 2002-05-31 12:00:00 | QQQ | ETF | 30.85 | 30.99 | 30.76 | 30.93 | 4974800.0 |
| 2002-05-31 13:00:00 | QQQ | ETF | 30.93 | 30.98 | 30.6 | 30.65 | 5093900.0 |
| 2002-05-31 14:00:00 | QQQ | ETF | 30.65 | 30.74 | 30.12 | 30.2 | 12193500.0 |
| 2002-05-31 15:00:00 | QQQ | ETF | 30.17 | 30.35 | 30.03 | 30.08 | 16677400.0 |
| 2002-05-31 16:00:00 | QQQ | ETF | 30.08 | 30.14 | 29.99 | 29.99 | 4604100.0 |
| 2002-05-31 17:00:00 | QQQ | ETF | 30.02 | 30.07 | 29.98 | 30.04 | 36300.0 |
| 2002-05-31 18:00:00 | QQQ | ETF | 30.05 | 30.05 | 30.01 | 30.01 | 1900.0 |
| 2002-05-31 09:00:00 | IWM | ETF | 48.775 | 48.8 | 48.625 | 48.69 | 372200.0 |
| 2002-05-31 10:00:00 | IWM | ETF | 48.745 | 49.025 | 48.745 | 48.8 | 258600.0 |
| 2002-05-31 11:00:00 | IWM | ETF | 48.97 | 49.115 | 48.935 | 48.95 | 175000.0 |
| 2002-05-31 12:00:00 | IWM | ETF | 48.945 | 49.1 | 48.925 | 49.1 | 66400.0 |
| 2002-05-31 13:00:00 | IWM | ETF | 49.1 | 49.12 | 48.92 | 48.925 | 192400.0 |
| 2002-05-31 14:00:00 | IWM | ETF | 48.995 | 48.995 | 48.755 | 48.755 | 181200.0 |
| 2002-05-31 15:00:00 | IWM | ETF | 48.765 | 48.83 | 48.48 | 48.48 | 1769200.0 |
| 2002-05-31 16:00:00 | IWM | ETF | 48.425 | 48.585 | 48.25 | 48.58 | 3111200.0 |
| 2002-05-31 17:00:00 | IWM | ETF | 48.085 | 48.085 | 48.085 | 48.085 | 506800.0 |
| 2002-05-31 09:00:00 | DIA | ETF | 99.85 | 99.92 | 99.48 | 99.9 | 810500.0 |
| 2002-05-31 10:00:00 | DIA | ETF | 99.87 | 100.38 | 99.87 | 100.09 | 985400.0 |
| 2002-05-31 11:00:00 | DIA | ETF | 100.13 | 100.44 | 100.1 | 100.21 | 210400.0 |
| 2002-05-31 12:00:00 | DIA | ETF | 100.21 | 100.56 | 100.07 | 100.56 | 186400.0 |
| 2002-05-31 13:00:00 | DIA | ETF | 100.55 | 100.66 | 100.25 | 100.27 | 382700.0 |
| 2002-05-31 14:00:00 | DIA | ETF | 100.33 | 100.4 | 99.61 | 99.69 | 843900.0 |
| 2002-05-31 15:00:00 | DIA | ETF | 99.65 | 99.99 | 99.43 | 99.55 | 934600.0 |
| 2002-05-31 16:00:00 | DIA | ETF | 99.55 | 99.6 | 99.0 | 99.2 | 186400.0 |
| 2002-05-31 18:00:00 | DIA | ETF | 99.2 | 99.2 | 99.2 | 99.2 | 200.0 |
> showing 37 of 312 rows — these rows as CSV