PREVIEW / etf_1hour / 2002-03-21
file: by_date/etf_1hour/2002/2002-03-21.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-03-21 09:00:00 | SPY | ETF | 115.3 | 115.37 | 114.9 | 114.93 | 2112800.0 |
| 2002-03-21 10:00:00 | SPY | ETF | 114.94 | 115.35 | 114.76 | 115.03 | 4877400.0 |
| 2002-03-21 11:00:00 | SPY | ETF | 115.05 | 115.13 | 114.6 | 114.71 | 2973400.0 |
| 2002-03-21 12:00:00 | SPY | ETF | 114.69 | 114.71 | 114.12 | 114.67 | 4363400.0 |
| 2002-03-21 13:00:00 | SPY | ETF | 114.66 | 115.09 | 114.65 | 114.76 | 2738100.0 |
| 2002-03-21 14:00:00 | SPY | ETF | 114.78 | 115.49 | 114.52 | 115.38 | 2932200.0 |
| 2002-03-21 15:00:00 | SPY | ETF | 115.4 | 115.83 | 115.21 | 115.6 | 4305600.0 |
| 2002-03-21 16:00:00 | SPY | ETF | 115.6 | 115.66 | 115.02 | 115.35 | 1381100.0 |
| 2002-03-21 17:00:00 | SPY | ETF | 115.3 | 115.3 | 115.15 | 115.3 | 13400.0 |
| 2002-03-21 18:00:00 | SPY | ETF | 115.3 | 115.35 | 115.28 | 115.31 | 3600.0 |
| 2002-03-21 09:00:00 | QQQ | ETF | 36.15 | 36.21 | 35.95 | 36.05 | 10632000.0 |
| 2002-03-21 10:00:00 | QQQ | ETF | 36.05 | 36.49 | 35.9 | 36.3 | 18765500.0 |
| 2002-03-21 11:00:00 | QQQ | ETF | 36.3 | 36.38 | 36.15 | 36.2 | 5602800.0 |
| 2002-03-21 12:00:00 | QQQ | ETF | 36.21 | 36.33 | 35.93 | 36.3 | 14002300.0 |
| 2002-03-21 13:00:00 | QQQ | ETF | 36.32 | 36.5 | 36.25 | 36.34 | 7210600.0 |
| 2002-03-21 14:00:00 | QQQ | ETF | 36.34 | 36.83 | 36.25 | 36.8 | 10553900.0 |
| 2002-03-21 15:00:00 | QQQ | ETF | 36.78 | 37.14 | 36.69 | 37.1 | 17342000.0 |
| 2002-03-21 16:00:00 | QQQ | ETF | 37.1 | 37.11 | 36.94 | 37.06 | 2346900.0 |
| 2002-03-21 17:00:00 | QQQ | ETF | 37.04 | 37.05 | 36.76 | 37.0 | 477300.0 |
| 2002-03-21 18:00:00 | QQQ | ETF | 36.95 | 37.01 | 36.9 | 37.01 | 53600.0 |
| 2002-03-21 09:00:00 | IWM | ETF | 49.775 | 49.775 | 49.555 | 49.66 | 50000.0 |
| 2002-03-21 10:00:00 | IWM | ETF | 49.64 | 49.87 | 49.515 | 49.79 | 185800.0 |
| 2002-03-21 11:00:00 | IWM | ETF | 49.76 | 49.81 | 49.575 | 49.675 | 73600.0 |
| 2002-03-21 12:00:00 | IWM | ETF | 49.585 | 49.67 | 49.5 | 49.625 | 130600.0 |
| 2002-03-21 13:00:00 | IWM | ETF | 49.625 | 49.79 | 49.615 | 49.79 | 104800.0 |
| 2002-03-21 14:00:00 | IWM | ETF | 49.725 | 50.075 | 49.72 | 50.04 | 95600.0 |
| 2002-03-21 15:00:00 | IWM | ETF | 50.01 | 50.31 | 49.925 | 50.27 | 294000.0 |
| 2002-03-21 16:00:00 | IWM | ETF | 50.265 | 50.275 | 50.11 | 50.265 | 14400.0 |
| 2002-03-21 09:00:00 | DIA | ETF | 105.0 | 105.08 | 104.5 | 104.71 | 779900.0 |
| 2002-03-21 10:00:00 | DIA | ETF | 104.7 | 104.75 | 104.35 | 104.48 | 1056700.0 |
| 2002-03-21 11:00:00 | DIA | ETF | 104.46 | 104.58 | 104.15 | 104.24 | 652700.0 |
| 2002-03-21 12:00:00 | DIA | ETF | 104.24 | 104.24 | 103.61 | 104.14 | 2372200.0 |
| 2002-03-21 13:00:00 | DIA | ETF | 104.08 | 104.45 | 104.05 | 104.12 | 1540600.0 |
| 2002-03-21 14:00:00 | DIA | ETF | 104.13 | 104.77 | 103.9 | 104.72 | 730600.0 |
| 2002-03-21 15:00:00 | DIA | ETF | 104.73 | 105.08 | 104.51 | 104.87 | 2552000.0 |
| 2002-03-21 16:00:00 | DIA | ETF | 104.86 | 104.96 | 104.56 | 104.67 | 168900.0 |
| 2002-03-21 17:00:00 | DIA | ETF | 104.6 | 104.6 | 104.6 | 104.6 | 1300.0 |
> showing 37 of 302 rows — these rows as CSV