PREVIEW / etf_1hour / 2002-04-03
file: by_date/etf_1hour/2002/2002-04-03.parquet size: 14 KB rows: 299
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-04-03 09:00:00 | SPY | ETF | 114.01 | 114.19 | 113.67 | 114.13 | 2804600.0 |
| 2002-04-03 10:00:00 | SPY | ETF | 114.18 | 114.21 | 112.91 | 113.17 | 6475900.0 |
| 2002-04-03 11:00:00 | SPY | ETF | 113.2 | 113.35 | 112.99 | 113.07 | 1913200.0 |
| 2002-04-03 12:00:00 | SPY | ETF | 113.07 | 113.26 | 112.94 | 113.2 | 1444300.0 |
| 2002-04-03 13:00:00 | SPY | ETF | 113.22 | 113.42 | 113.03 | 113.04 | 835400.0 |
| 2002-04-03 14:00:00 | SPY | ETF | 113.06 | 113.23 | 112.43 | 112.56 | 3613800.0 |
| 2002-04-03 15:00:00 | SPY | ETF | 112.54 | 112.79 | 112.16 | 112.74 | 6004300.0 |
| 2002-04-03 16:00:00 | SPY | ETF | 112.78 | 113.25 | 112.71 | 113.14 | 1618800.0 |
| 2002-04-03 17:00:00 | SPY | ETF | 113.18 | 113.19 | 113.11 | 113.11 | 5600.0 |
| 2002-04-03 18:00:00 | SPY | ETF | 113.05 | 113.1 | 113.04 | 113.05 | 2000.0 |
| 2002-04-03 09:00:00 | QQQ | ETF | 35.3 | 35.45 | 35.02 | 35.4 | 10145000.0 |
| 2002-04-03 10:00:00 | QQQ | ETF | 35.39 | 35.43 | 34.65 | 34.81 | 20472600.0 |
| 2002-04-03 11:00:00 | QQQ | ETF | 34.82 | 34.94 | 34.63 | 34.7 | 8356700.0 |
| 2002-04-03 12:00:00 | QQQ | ETF | 34.66 | 34.79 | 34.57 | 34.76 | 7352700.0 |
| 2002-04-03 13:00:00 | QQQ | ETF | 34.77 | 34.94 | 34.67 | 34.7 | 6518500.0 |
| 2002-04-03 14:00:00 | QQQ | ETF | 34.71 | 34.79 | 34.39 | 34.46 | 9112100.0 |
| 2002-04-03 15:00:00 | QQQ | ETF | 34.47 | 34.7 | 34.3 | 34.69 | 13838400.0 |
| 2002-04-03 16:00:00 | QQQ | ETF | 34.64 | 35.07 | 34.62 | 35.0 | 7959500.0 |
| 2002-04-03 17:00:00 | QQQ | ETF | 35.01 | 35.05 | 34.97 | 35.04 | 103000.0 |
| 2002-04-03 18:00:00 | QQQ | ETF | 35.01 | 35.05 | 34.95 | 35.05 | 27500.0 |
| 2002-04-03 09:00:00 | IWM | ETF | 49.875 | 49.955 | 49.76 | 49.955 | 61200.0 |
| 2002-04-03 10:00:00 | IWM | ETF | 49.85 | 49.86 | 49.55 | 49.64 | 1851200.0 |
| 2002-04-03 11:00:00 | IWM | ETF | 49.635 | 49.77 | 49.56 | 49.71 | 404200.0 |
| 2002-04-03 12:00:00 | IWM | ETF | 49.68 | 49.69 | 49.6 | 49.69 | 688400.0 |
| 2002-04-03 13:00:00 | IWM | ETF | 49.7 | 49.82 | 49.7 | 49.775 | 312400.0 |
| 2002-04-03 14:00:00 | IWM | ETF | 49.7 | 49.765 | 49.34 | 49.35 | 506400.0 |
| 2002-04-03 15:00:00 | IWM | ETF | 49.32 | 49.625 | 49.26 | 49.625 | 1968200.0 |
| 2002-04-03 16:00:00 | IWM | ETF | 49.465 | 49.64 | 49.425 | 49.425 | 271800.0 |
| 2002-04-03 09:00:00 | DIA | ETF | 103.56 | 103.56 | 103.0 | 103.46 | 883700.0 |
| 2002-04-03 10:00:00 | DIA | ETF | 103.47 | 103.47 | 102.25 | 102.58 | 1526800.0 |
| 2002-04-03 11:00:00 | DIA | ETF | 102.57 | 102.69 | 102.34 | 102.48 | 1753800.0 |
| 2002-04-03 12:00:00 | DIA | ETF | 102.42 | 102.6 | 102.34 | 102.59 | 132300.0 |
| 2002-04-03 13:00:00 | DIA | ETF | 102.58 | 102.67 | 102.39 | 102.4 | 377700.0 |
| 2002-04-03 14:00:00 | DIA | ETF | 102.4 | 102.53 | 101.72 | 101.81 | 652900.0 |
| 2002-04-03 15:00:00 | DIA | ETF | 101.84 | 102.05 | 101.45 | 102.05 | 2230500.0 |
| 2002-04-03 16:00:00 | DIA | ETF | 102.01 | 102.37 | 102.01 | 102.2 | 166500.0 |
> showing 36 of 299 rows — these rows as CSV