PREVIEW / etf_1hour / 2002-05-23
file: by_date/etf_1hour/2002/2002-05-23.parquet size: 14 KB rows: 302
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-23 09:00:00 | SPY | ETF | 109.26 | 109.45 | 108.78 | 109.1 | 1766400.0 |
| 2002-05-23 10:00:00 | SPY | ETF | 109.1 | 109.34 | 108.8 | 109.16 | 1969600.0 |
| 2002-05-23 11:00:00 | SPY | ETF | 109.15 | 109.19 | 108.51 | 108.61 | 1339100.0 |
| 2002-05-23 12:00:00 | SPY | ETF | 108.6 | 109.0 | 108.48 | 108.85 | 1116100.0 |
| 2002-05-23 13:00:00 | SPY | ETF | 108.84 | 109.08 | 108.68 | 108.84 | 919200.0 |
| 2002-05-23 14:00:00 | SPY | ETF | 108.84 | 109.7 | 108.75 | 109.65 | 1978800.0 |
| 2002-05-23 15:00:00 | SPY | ETF | 109.63 | 110.24 | 109.6 | 110.16 | 3388400.0 |
| 2002-05-23 16:00:00 | SPY | ETF | 110.18 | 110.36 | 109.97 | 110.18 | 1225800.0 |
| 2002-05-23 17:00:00 | SPY | ETF | 110.11 | 110.2 | 110.09 | 110.2 | 16900.0 |
| 2002-05-23 18:00:00 | SPY | ETF | 110.13 | 110.19 | 110.13 | 110.19 | 1400.0 |
| 2002-05-23 09:00:00 | QQQ | ETF | 31.63 | 31.74 | 31.15 | 31.43 | 17601400.0 |
| 2002-05-23 10:00:00 | QQQ | ETF | 31.43 | 31.45 | 31.08 | 31.15 | 10410000.0 |
| 2002-05-23 11:00:00 | QQQ | ETF | 31.16 | 31.17 | 30.8 | 30.88 | 13801200.0 |
| 2002-05-23 12:00:00 | QQQ | ETF | 30.91 | 31.15 | 30.87 | 31.03 | 5626800.0 |
| 2002-05-23 13:00:00 | QQQ | ETF | 31.03 | 31.2 | 30.96 | 31.14 | 5860900.0 |
| 2002-05-23 14:00:00 | QQQ | ETF | 31.14 | 31.78 | 31.05 | 31.68 | 15739200.0 |
| 2002-05-23 15:00:00 | QQQ | ETF | 31.7 | 32.1 | 31.6 | 32.06 | 20399800.0 |
| 2002-05-23 16:00:00 | QQQ | ETF | 32.05 | 32.1 | 31.85 | 31.93 | 2805400.0 |
| 2002-05-23 17:00:00 | QQQ | ETF | 31.94 | 31.97 | 31.89 | 31.97 | 100900.0 |
| 2002-05-23 18:00:00 | QQQ | ETF | 31.97 | 31.98 | 31.91 | 31.96 | 23600.0 |
| 2002-05-23 09:00:00 | IWM | ETF | 49.35 | 49.35 | 49.0 | 49.0 | 282600.0 |
| 2002-05-23 10:00:00 | IWM | ETF | 49.05 | 49.095 | 48.75 | 48.965 | 300000.0 |
| 2002-05-23 11:00:00 | IWM | ETF | 48.99 | 49.025 | 48.85 | 48.85 | 408000.0 |
| 2002-05-23 12:00:00 | IWM | ETF | 48.85 | 49.02 | 48.815 | 49.0 | 247800.0 |
| 2002-05-23 13:00:00 | IWM | ETF | 49.01 | 49.145 | 48.935 | 49.135 | 279000.0 |
| 2002-05-23 14:00:00 | IWM | ETF | 49.13 | 49.7 | 49.055 | 49.58 | 337400.0 |
| 2002-05-23 15:00:00 | IWM | ETF | 49.64 | 49.995 | 49.58 | 49.995 | 476400.0 |
| 2002-05-23 16:00:00 | IWM | ETF | 49.99 | 49.99 | 49.9 | 49.975 | 2600.0 |
| 2002-05-23 18:00:00 | IWM | ETF | 49.94 | 49.94 | 49.94 | 49.94 | 208000.0 |
| 2002-05-23 09:00:00 | DIA | ETF | 102.0 | 102.04 | 101.35 | 101.6 | 446800.0 |
| 2002-05-23 10:00:00 | DIA | ETF | 101.61 | 101.87 | 101.36 | 101.72 | 156900.0 |
| 2002-05-23 11:00:00 | DIA | ETF | 101.72 | 101.72 | 101.01 | 101.13 | 335700.0 |
| 2002-05-23 12:00:00 | DIA | ETF | 101.07 | 101.3 | 101.0 | 101.2 | 218000.0 |
| 2002-05-23 13:00:00 | DIA | ETF | 101.2 | 101.41 | 101.06 | 101.23 | 35600.0 |
| 2002-05-23 14:00:00 | DIA | ETF | 101.22 | 101.82 | 101.15 | 101.75 | 489200.0 |
| 2002-05-23 15:00:00 | DIA | ETF | 101.8 | 102.35 | 101.8 | 102.23 | 675500.0 |
| 2002-05-23 16:00:00 | DIA | ETF | 102.34 | 102.43 | 102.19 | 102.32 | 152400.0 |
> showing 37 of 302 rows — these rows as CSV