PREVIEW / etf_1hour / 2002-05-28
file: by_date/etf_1hour/2002/2002-05-28.parquet size: 14 KB rows: 305
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-28 09:00:00 | SPY | ETF | 109.05 | 109.13 | 108.58 | 108.62 | 3666400.0 |
| 2002-05-28 10:00:00 | SPY | ETF | 108.64 | 108.85 | 107.5 | 107.61 | 6684600.0 |
| 2002-05-28 11:00:00 | SPY | ETF | 107.68 | 107.8 | 107.45 | 107.7 | 2356700.0 |
| 2002-05-28 12:00:00 | SPY | ETF | 107.71 | 107.78 | 107.49 | 107.67 | 758200.0 |
| 2002-05-28 13:00:00 | SPY | ETF | 107.74 | 107.94 | 107.68 | 107.92 | 2592900.0 |
| 2002-05-28 14:00:00 | SPY | ETF | 107.9 | 108.25 | 107.66 | 107.81 | 2199800.0 |
| 2002-05-28 15:00:00 | SPY | ETF | 107.79 | 108.16 | 107.68 | 107.9 | 3356000.0 |
| 2002-05-28 16:00:00 | SPY | ETF | 107.91 | 108.18 | 107.86 | 108.0 | 1620100.0 |
| 2002-05-28 17:00:00 | SPY | ETF | 107.97 | 107.97 | 107.9 | 107.92 | 4100.0 |
| 2002-05-28 18:00:00 | SPY | ETF | 107.88 | 107.88 | 107.88 | 107.88 | 100.0 |
| 2002-05-28 09:00:00 | QQQ | ETF | 31.47 | 31.52 | 31.08 | 31.18 | 10573700.0 |
| 2002-05-28 10:00:00 | QQQ | ETF | 31.19 | 31.35 | 30.49 | 30.56 | 22337800.0 |
| 2002-05-28 11:00:00 | QQQ | ETF | 30.58 | 30.77 | 30.52 | 30.66 | 6360500.0 |
| 2002-05-28 12:00:00 | QQQ | ETF | 30.66 | 30.74 | 30.52 | 30.7 | 3992300.0 |
| 2002-05-28 13:00:00 | QQQ | ETF | 30.7 | 30.89 | 30.68 | 30.85 | 3943000.0 |
| 2002-05-28 14:00:00 | QQQ | ETF | 30.85 | 31.06 | 30.71 | 30.77 | 8538100.0 |
| 2002-05-28 15:00:00 | QQQ | ETF | 30.77 | 31.09 | 30.74 | 30.98 | 9405500.0 |
| 2002-05-28 16:00:00 | QQQ | ETF | 30.98 | 31.24 | 30.93 | 30.96 | 2962100.0 |
| 2002-05-28 17:00:00 | QQQ | ETF | 30.96 | 30.97 | 30.82 | 30.91 | 498700.0 |
| 2002-05-28 18:00:00 | QQQ | ETF | 30.92 | 30.94 | 30.89 | 30.9 | 21100.0 |
| 2002-05-28 09:00:00 | IWM | ETF | 49.4 | 49.4 | 49.0 | 49.005 | 356200.0 |
| 2002-05-28 10:00:00 | IWM | ETF | 49.01 | 49.17 | 48.5 | 48.505 | 816800.0 |
| 2002-05-28 11:00:00 | IWM | ETF | 48.505 | 48.64 | 48.5 | 48.6 | 249600.0 |
| 2002-05-28 12:00:00 | IWM | ETF | 48.6 | 48.62 | 48.55 | 48.62 | 33800.0 |
| 2002-05-28 13:00:00 | IWM | ETF | 48.62 | 48.69 | 48.585 | 48.68 | 604400.0 |
| 2002-05-28 14:00:00 | IWM | ETF | 48.68 | 48.925 | 48.675 | 48.775 | 403200.0 |
| 2002-05-28 15:00:00 | IWM | ETF | 48.835 | 49.065 | 48.775 | 48.985 | 407200.0 |
| 2002-05-28 16:00:00 | IWM | ETF | 48.965 | 49.125 | 48.695 | 49.06 | 110400.0 |
| 2002-05-28 09:00:00 | DIA | ETF | 101.34 | 101.35 | 101.03 | 101.07 | 273900.0 |
| 2002-05-28 10:00:00 | DIA | ETF | 101.01 | 101.2 | 99.95 | 100.08 | 639400.0 |
| 2002-05-28 11:00:00 | DIA | ETF | 100.04 | 100.13 | 99.8 | 100.0 | 379000.0 |
| 2002-05-28 12:00:00 | DIA | ETF | 100.02 | 100.06 | 99.8 | 99.99 | 113200.0 |
| 2002-05-28 13:00:00 | DIA | ETF | 99.96 | 100.2 | 99.96 | 100.16 | 226600.0 |
| 2002-05-28 14:00:00 | DIA | ETF | 100.17 | 100.39 | 99.76 | 99.84 | 460500.0 |
| 2002-05-28 15:00:00 | DIA | ETF | 99.88 | 100.18 | 99.8 | 99.95 | 336300.0 |
| 2002-05-28 16:00:00 | DIA | ETF | 99.99 | 100.14 | 99.92 | 100.0 | 105500.0 |
> showing 36 of 305 rows — these rows as CSV