PREVIEW / etf_1hour / 2002-05-30
file: by_date/etf_1hour/2002/2002-05-30.parquet size: 14 KB rows: 309
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-30 09:00:00 | SPY | ETF | 106.55 | 106.93 | 106.4 | 106.81 | 3001000.0 |
| 2002-05-30 10:00:00 | SPY | ETF | 106.81 | 107.51 | 106.63 | 107.24 | 3493000.0 |
| 2002-05-30 11:00:00 | SPY | ETF | 107.23 | 107.41 | 106.91 | 107.0 | 1410100.0 |
| 2002-05-30 12:00:00 | SPY | ETF | 107.0 | 107.03 | 106.24 | 106.35 | 1438900.0 |
| 2002-05-30 13:00:00 | SPY | ETF | 106.34 | 106.42 | 105.9 | 106.31 | 3050800.0 |
| 2002-05-30 14:00:00 | SPY | ETF | 106.35 | 106.92 | 106.26 | 106.89 | 1625900.0 |
| 2002-05-30 15:00:00 | SPY | ETF | 106.89 | 107.31 | 106.72 | 107.0 | 2921300.0 |
| 2002-05-30 16:00:00 | SPY | ETF | 107.0 | 107.14 | 106.9 | 107.04 | 1041500.0 |
| 2002-05-30 17:00:00 | SPY | ETF | 106.98 | 107.05 | 106.98 | 107.01 | 2400.0 |
| 2002-05-30 09:00:00 | QQQ | ETF | 30.01 | 30.24 | 29.91 | 30.14 | 13849400.0 |
| 2002-05-30 10:00:00 | QQQ | ETF | 30.16 | 30.68 | 30.01 | 30.49 | 22377800.0 |
| 2002-05-30 11:00:00 | QQQ | ETF | 30.5 | 30.61 | 30.17 | 30.29 | 8995700.0 |
| 2002-05-30 12:00:00 | QQQ | ETF | 30.29 | 30.3 | 29.95 | 30.0 | 9657400.0 |
| 2002-05-30 13:00:00 | QQQ | ETF | 30.0 | 30.23 | 29.9 | 30.18 | 10646500.0 |
| 2002-05-30 14:00:00 | QQQ | ETF | 30.18 | 30.54 | 30.12 | 30.5 | 8776200.0 |
| 2002-05-30 15:00:00 | QQQ | ETF | 30.53 | 30.72 | 30.4 | 30.59 | 14253600.0 |
| 2002-05-30 16:00:00 | QQQ | ETF | 30.58 | 30.64 | 30.52 | 30.59 | 2330000.0 |
| 2002-05-30 17:00:00 | QQQ | ETF | 30.57 | 30.61 | 30.56 | 30.56 | 18600.0 |
| 2002-05-30 18:00:00 | QQQ | ETF | 30.57 | 30.59 | 30.56 | 30.59 | 18800.0 |
| 2002-05-30 09:00:00 | IWM | ETF | 48.435 | 48.445 | 48.25 | 48.445 | 101200.0 |
| 2002-05-30 10:00:00 | IWM | ETF | 48.41 | 48.825 | 48.325 | 48.755 | 456600.0 |
| 2002-05-30 11:00:00 | IWM | ETF | 48.755 | 48.805 | 48.535 | 48.58 | 219400.0 |
| 2002-05-30 12:00:00 | IWM | ETF | 48.575 | 48.575 | 48.23 | 48.23 | 231400.0 |
| 2002-05-30 13:00:00 | IWM | ETF | 48.24 | 48.275 | 48.02 | 48.18 | 443200.0 |
| 2002-05-30 14:00:00 | IWM | ETF | 48.145 | 48.355 | 48.125 | 48.32 | 577400.0 |
| 2002-05-30 15:00:00 | IWM | ETF | 48.35 | 48.59 | 48.265 | 48.59 | 361000.0 |
| 2002-05-30 16:00:00 | IWM | ETF | 48.59 | 48.61 | 48.5 | 48.61 | 654400.0 |
| 2002-05-30 18:00:00 | IWM | ETF | 48.61 | 48.61 | 48.61 | 48.61 | 1658000.0 |
| 2002-05-30 09:00:00 | DIA | ETF | 98.96 | 99.1 | 98.74 | 98.95 | 676900.0 |
| 2002-05-30 10:00:00 | DIA | ETF | 99.0 | 99.71 | 98.82 | 99.45 | 1195700.0 |
| 2002-05-30 11:00:00 | DIA | ETF | 99.47 | 99.59 | 99.14 | 99.24 | 473800.0 |
| 2002-05-30 12:00:00 | DIA | ETF | 99.2 | 99.25 | 98.6 | 98.73 | 363500.0 |
| 2002-05-30 13:00:00 | DIA | ETF | 98.74 | 98.8 | 98.21 | 98.69 | 1063700.0 |
| 2002-05-30 14:00:00 | DIA | ETF | 98.69 | 99.2 | 98.61 | 99.18 | 678100.0 |
| 2002-05-30 15:00:00 | DIA | ETF | 99.2 | 99.64 | 99.01 | 99.44 | 599400.0 |
| 2002-05-30 16:00:00 | DIA | ETF | 99.4 | 99.48 | 99.2 | 99.4 | 97000.0 |
| 2002-05-30 17:00:00 | DIA | ETF | 99.3 | 99.3 | 99.3 | 99.3 | 200.0 |
> showing 37 of 309 rows — these rows as CSV