PREVIEW / etf_1hour / 2002-07-26
file: by_date/etf_1hour/2002/2002-07-26.parquet size: 14 KB rows: 307
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-07-26 09:00:00 | SPY | ETF | 84.65 | 85.2 | 83.81 | 85.1 | 8034300.0 |
| 2002-07-26 10:00:00 | SPY | ETF | 85.11 | 85.28 | 84.05 | 84.64 | 6324400.0 |
| 2002-07-26 11:00:00 | SPY | ETF | 84.52 | 85.11 | 84.46 | 84.46 | 3398400.0 |
| 2002-07-26 12:00:00 | SPY | ETF | 84.52 | 84.7 | 83.9 | 84.36 | 3283400.0 |
| 2002-07-26 13:00:00 | SPY | ETF | 84.4 | 84.65 | 83.8 | 84.28 | 4197400.0 |
| 2002-07-26 14:00:00 | SPY | ETF | 84.32 | 84.6 | 83.9 | 84.43 | 3050900.0 |
| 2002-07-26 15:00:00 | SPY | ETF | 84.43 | 85.69 | 84.36 | 85.6 | 8614200.0 |
| 2002-07-26 16:00:00 | SPY | ETF | 85.63 | 85.93 | 85.55 | 85.6 | 1815500.0 |
| 2002-07-26 09:00:00 | QQQ | ETF | 22.56 | 22.68 | 22.32 | 22.62 | 17753800.0 |
| 2002-07-26 10:00:00 | QQQ | ETF | 22.65 | 22.73 | 22.22 | 22.61 | 19340000.0 |
| 2002-07-26 11:00:00 | QQQ | ETF | 22.6 | 22.84 | 22.49 | 22.51 | 11897100.0 |
| 2002-07-26 12:00:00 | QQQ | ETF | 22.51 | 22.59 | 22.18 | 22.35 | 8375500.0 |
| 2002-07-26 13:00:00 | QQQ | ETF | 22.35 | 22.48 | 22.16 | 22.31 | 7840200.0 |
| 2002-07-26 14:00:00 | QQQ | ETF | 22.32 | 22.38 | 22.01 | 22.32 | 8815000.0 |
| 2002-07-26 15:00:00 | QQQ | ETF | 22.31 | 22.67 | 22.26 | 22.63 | 15795500.0 |
| 2002-07-26 16:00:00 | QQQ | ETF | 22.63 | 22.75 | 22.56 | 22.67 | 1244300.0 |
| 2002-07-26 09:00:00 | IWM | ETF | 37.975 | 38.025 | 37.75 | 38.025 | 448400.0 |
| 2002-07-26 10:00:00 | IWM | ETF | 38.1 | 38.26 | 37.75 | 37.755 | 305600.0 |
| 2002-07-26 11:00:00 | IWM | ETF | 37.835 | 38.005 | 37.8 | 37.85 | 226800.0 |
| 2002-07-26 12:00:00 | IWM | ETF | 37.845 | 37.87 | 37.6 | 37.63 | 245600.0 |
| 2002-07-26 13:00:00 | IWM | ETF | 37.705 | 37.825 | 37.55 | 37.57 | 193200.0 |
| 2002-07-26 14:00:00 | IWM | ETF | 37.575 | 37.695 | 37.325 | 37.54 | 261200.0 |
| 2002-07-26 15:00:00 | IWM | ETF | 37.55 | 38.13 | 37.545 | 38.035 | 638800.0 |
| 2002-07-26 16:00:00 | IWM | ETF | 38.05 | 38.3 | 38.05 | 38.3 | 5400.0 |
| 2002-07-26 09:00:00 | DIA | ETF | 82.55 | 82.8 | 81.45 | 82.71 | 1436100.0 |
| 2002-07-26 10:00:00 | DIA | ETF | 82.76 | 82.95 | 81.56 | 82.06 | 1913100.0 |
| 2002-07-26 11:00:00 | DIA | ETF | 82.1 | 82.5 | 81.9 | 82.01 | 641300.0 |
| 2002-07-26 12:00:00 | DIA | ETF | 82.0 | 82.13 | 81.2 | 81.65 | 1401600.0 |
| 2002-07-26 13:00:00 | DIA | ETF | 81.7 | 81.95 | 81.16 | 81.63 | 910100.0 |
| 2002-07-26 14:00:00 | DIA | ETF | 81.66 | 81.92 | 81.19 | 81.77 | 823000.0 |
| 2002-07-26 15:00:00 | DIA | ETF | 81.77 | 82.78 | 81.77 | 82.67 | 1890400.0 |
| 2002-07-26 16:00:00 | DIA | ETF | 82.7 | 82.95 | 82.63 | 82.85 | 43800.0 |
> showing 32 of 307 rows — these rows as CSV