PREVIEW / etf_1hour / 2002-03-26
file: by_date/etf_1hour/2002/2002-03-26.parquet size: 14 KB rows: 294
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-26 09:00:00 | SPY | ETF | 113.52 | 114.26 | 113.47 | 114.21 | 2778800.0 |
| 2002-03-26 10:00:00 | SPY | ETF | 114.23 | 115.02 | 114.21 | 114.45 | 5056800.0 |
| 2002-03-26 11:00:00 | SPY | ETF | 114.46 | 114.67 | 114.33 | 114.55 | 1144200.0 |
| 2002-03-26 12:00:00 | SPY | ETF | 114.58 | 114.8 | 114.45 | 114.53 | 1283100.0 |
| 2002-03-26 13:00:00 | SPY | ETF | 114.53 | 114.73 | 114.17 | 114.17 | 1444800.0 |
| 2002-03-26 14:00:00 | SPY | ETF | 114.19 | 114.25 | 113.65 | 113.68 | 2682500.0 |
| 2002-03-26 15:00:00 | SPY | ETF | 113.69 | 114.16 | 113.51 | 114.08 | 3319400.0 |
| 2002-03-26 16:00:00 | SPY | ETF | 114.06 | 114.34 | 114.05 | 114.2 | 802500.0 |
| 2002-03-26 17:00:00 | SPY | ETF | 114.2 | 114.24 | 114.2 | 114.24 | 6200.0 |
| 2002-03-26 18:00:00 | SPY | ETF | 114.21 | 114.21 | 114.2 | 114.2 | 3000.0 |
| 2002-03-26 09:00:00 | QQQ | ETF | 35.42 | 35.83 | 35.4 | 35.82 | 12316100.0 |
| 2002-03-26 10:00:00 | QQQ | ETF | 35.82 | 36.42 | 35.75 | 36.03 | 26182500.0 |
| 2002-03-26 11:00:00 | QQQ | ETF | 36.04 | 36.14 | 35.93 | 36.08 | 10003900.0 |
| 2002-03-26 12:00:00 | QQQ | ETF | 36.1 | 36.25 | 36.07 | 36.11 | 5537600.0 |
| 2002-03-26 13:00:00 | QQQ | ETF | 36.11 | 36.26 | 35.87 | 35.88 | 6384100.0 |
| 2002-03-26 14:00:00 | QQQ | ETF | 35.87 | 35.95 | 35.46 | 35.46 | 12836200.0 |
| 2002-03-26 15:00:00 | QQQ | ETF | 35.46 | 35.84 | 35.41 | 35.8 | 14692000.0 |
| 2002-03-26 16:00:00 | QQQ | ETF | 35.84 | 35.9 | 35.72 | 35.9 | 1953200.0 |
| 2002-03-26 17:00:00 | QQQ | ETF | 35.84 | 35.86 | 35.8 | 35.81 | 54200.0 |
| 2002-03-26 18:00:00 | QQQ | ETF | 35.83 | 35.9 | 35.83 | 35.87 | 9400.0 |
| 2002-03-26 09:00:00 | IWM | ETF | 49.4 | 49.64 | 49.4 | 49.62 | 36800.0 |
| 2002-03-26 10:00:00 | IWM | ETF | 49.63 | 49.85 | 49.63 | 49.76 | 270000.0 |
| 2002-03-26 11:00:00 | IWM | ETF | 49.65 | 49.79 | 49.65 | 49.775 | 55400.0 |
| 2002-03-26 12:00:00 | IWM | ETF | 49.8 | 49.84 | 49.745 | 49.745 | 31800.0 |
| 2002-03-26 13:00:00 | IWM | ETF | 49.8 | 49.81 | 49.665 | 49.675 | 30600.0 |
| 2002-03-26 14:00:00 | IWM | ETF | 49.635 | 49.65 | 49.5 | 49.58 | 277800.0 |
| 2002-03-26 15:00:00 | IWM | ETF | 49.53 | 49.93 | 49.425 | 49.93 | 112600.0 |
| 2002-03-26 16:00:00 | IWM | ETF | 49.84 | 49.85 | 49.84 | 49.85 | 1200.0 |
| 2002-03-26 09:00:00 | DIA | ETF | 102.86 | 103.58 | 102.8 | 103.5 | 545400.0 |
| 2002-03-26 10:00:00 | DIA | ETF | 103.45 | 105.2 | 103.45 | 103.99 | 1998300.0 |
| 2002-03-26 11:00:00 | DIA | ETF | 103.93 | 104.15 | 103.84 | 104.05 | 159500.0 |
| 2002-03-26 12:00:00 | DIA | ETF | 104.06 | 104.26 | 103.92 | 104.03 | 371200.0 |
| 2002-03-26 13:00:00 | DIA | ETF | 103.98 | 104.18 | 103.78 | 103.81 | 156700.0 |
| 2002-03-26 14:00:00 | DIA | ETF | 103.82 | 103.82 | 103.3 | 103.34 | 460400.0 |
| 2002-03-26 15:00:00 | DIA | ETF | 103.31 | 103.69 | 103.15 | 103.61 | 736300.0 |
| 2002-03-26 16:00:00 | DIA | ETF | 103.59 | 103.82 | 103.57 | 103.77 | 86600.0 |
> showing 36 of 294 rows — these rows as CSV