PREVIEW / etf_1hour / 2002-05-21
file: by_date/etf_1hour/2002/2002-05-21.parquet size: 14 KB rows: 316
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-21 09:00:00 | SPY | ETF | 110.11 | 110.48 | 109.9 | 110.08 | 1961500.0 |
| 2002-05-21 10:00:00 | SPY | ETF | 110.06 | 110.19 | 109.61 | 109.64 | 1874700.0 |
| 2002-05-21 11:00:00 | SPY | ETF | 109.63 | 109.65 | 109.15 | 109.21 | 3699600.0 |
| 2002-05-21 12:00:00 | SPY | ETF | 109.24 | 109.35 | 109.03 | 109.14 | 1540100.0 |
| 2002-05-21 13:00:00 | SPY | ETF | 109.15 | 109.34 | 109.05 | 109.24 | 913200.0 |
| 2002-05-21 14:00:00 | SPY | ETF | 109.24 | 109.29 | 108.61 | 108.73 | 2413100.0 |
| 2002-05-21 15:00:00 | SPY | ETF | 108.68 | 108.75 | 108.32 | 108.48 | 2760100.0 |
| 2002-05-21 16:00:00 | SPY | ETF | 108.52 | 109.15 | 108.32 | 108.67 | 1017100.0 |
| 2002-05-21 17:00:00 | SPY | ETF | 108.6 | 108.7 | 108.6 | 108.65 | 41100.0 |
| 2002-05-21 18:00:00 | SPY | ETF | 108.72 | 108.73 | 108.6 | 108.61 | 800.0 |
| 2002-05-21 09:00:00 | QQQ | ETF | 32.36 | 32.59 | 32.12 | 32.21 | 11043200.0 |
| 2002-05-21 10:00:00 | QQQ | ETF | 32.21 | 32.3 | 31.6 | 31.62 | 19812200.0 |
| 2002-05-21 11:00:00 | QQQ | ETF | 31.62 | 31.67 | 31.38 | 31.5 | 18581000.0 |
| 2002-05-21 12:00:00 | QQQ | ETF | 31.52 | 31.6 | 31.25 | 31.37 | 10173900.0 |
| 2002-05-21 13:00:00 | QQQ | ETF | 31.38 | 31.54 | 31.31 | 31.47 | 5962700.0 |
| 2002-05-21 14:00:00 | QQQ | ETF | 31.47 | 31.55 | 31.12 | 31.16 | 17764200.0 |
| 2002-05-21 15:00:00 | QQQ | ETF | 31.17 | 31.4 | 31.09 | 31.3 | 12971300.0 |
| 2002-05-21 16:00:00 | QQQ | ETF | 31.28 | 32.15 | 31.23 | 31.32 | 3397600.0 |
| 2002-05-21 17:00:00 | QQQ | ETF | 31.32 | 31.33 | 31.29 | 31.3 | 44700.0 |
| 2002-05-21 18:00:00 | QQQ | ETF | 31.3 | 31.33 | 31.28 | 31.31 | 16700.0 |
| 2002-05-21 09:00:00 | IWM | ETF | 50.175 | 50.32 | 50.055 | 50.055 | 36400.0 |
| 2002-05-21 10:00:00 | IWM | ETF | 50.075 | 50.14 | 49.785 | 49.86 | 125000.0 |
| 2002-05-21 11:00:00 | IWM | ETF | 49.745 | 49.8 | 49.51 | 49.585 | 395800.0 |
| 2002-05-21 12:00:00 | IWM | ETF | 49.595 | 49.64 | 49.38 | 49.38 | 189200.0 |
| 2002-05-21 13:00:00 | IWM | ETF | 49.39 | 49.51 | 49.36 | 49.425 | 129000.0 |
| 2002-05-21 14:00:00 | IWM | ETF | 49.425 | 49.525 | 49.25 | 49.31 | 239000.0 |
| 2002-05-21 15:00:00 | IWM | ETF | 49.215 | 49.345 | 49.135 | 49.22 | 401400.0 |
| 2002-05-21 16:00:00 | IWM | ETF | 49.3 | 49.36 | 49.3 | 49.36 | 154800.0 |
| 2002-05-21 18:00:00 | IWM | ETF | 49.36 | 49.36 | 49.36 | 49.36 | 66000.0 |
| 2002-05-21 09:00:00 | DIA | ETF | 102.8 | 102.95 | 102.34 | 102.54 | 437800.0 |
| 2002-05-21 10:00:00 | DIA | ETF | 102.58 | 102.74 | 102.35 | 102.35 | 247500.0 |
| 2002-05-21 11:00:00 | DIA | ETF | 102.35 | 102.35 | 101.8 | 102.01 | 508800.0 |
| 2002-05-21 12:00:00 | DIA | ETF | 102.01 | 102.04 | 101.7 | 101.89 | 185300.0 |
| 2002-05-21 13:00:00 | DIA | ETF | 101.81 | 102.04 | 101.72 | 101.72 | 44500.0 |
| 2002-05-21 14:00:00 | DIA | ETF | 101.79 | 101.8 | 101.2 | 101.33 | 148400.0 |
| 2002-05-21 15:00:00 | DIA | ETF | 101.34 | 101.41 | 100.92 | 101.16 | 569500.0 |
| 2002-05-21 16:00:00 | DIA | ETF | 101.1 | 101.8 | 101.01 | 101.26 | 60200.0 |
> showing 37 of 316 rows — these rows as CSV